Skip to main content

​
Cancel SQL statement

Action ID: tools.snowflake.cancel_statement Cancel execution of a Snowflake SQL statement. Reference: https://docs.snowflake.com/en/developer-guide/sql-api/reference#post-apiv2statementsstatementhandlecancel

​
Secrets

Optional secrets:
  • snowflake_oauth: OAuth token SNOWFLAKE_USER_TOKEN.
  • snowflake_oauth: OAuth token SNOWFLAKE_SERVICE_TOKEN.
  • snowflake: required values SNOWFLAKE_OAUTH_CLIENT_ID, SNOWFLAKE_OAUTH_CLIENT_SECRET, SNOWFLAKE_OAUTH_TOKEN_URL; optional values SNOWFLAKE_OAUTH_SCOPE, SNOWFLAKE_OAUTH_AUDIENCE, SNOWFLAKE_OAUTH_TOKEN_ENDPOINT_AUTH_METHOD.

​
Input fields

​
string
required
Handle of the statement to cancel.
​
string | null
Snowflake account URL, for example https://org-account.snowflakecomputing.com.Default: null.
​
string | null
Unique UUID for the API request.Default: null.

​
Execute SQL statement

Action ID: tools.snowflake.execute_statement Submit one or more Snowflake SQL statements for execution. Reference: https://docs.snowflake.com/en/developer-guide/sql-api/reference#post-apiv2statements

​
Secrets

Optional secrets:
  • snowflake_oauth: OAuth token SNOWFLAKE_USER_TOKEN.
  • snowflake_oauth: OAuth token SNOWFLAKE_SERVICE_TOKEN.
  • snowflake: required values SNOWFLAKE_OAUTH_CLIENT_ID, SNOWFLAKE_OAUTH_CLIENT_SECRET, SNOWFLAKE_OAUTH_TOKEN_URL; optional values SNOWFLAKE_OAUTH_SCOPE, SNOWFLAKE_OAUTH_AUDIENCE, SNOWFLAKE_OAUTH_TOKEN_ENDPOINT_AUTH_METHOD.

​
Input fields

​
object
required
SQL API request body. Documented fields are statement, timeout, database, schema, warehouse, role, bindings, and parameters.
​
boolean | null
Execute asynchronously and return the statement handle.Default: null.
​
string | null
Snowflake account URL, for example https://org-account.snowflakecomputing.com.Default: null.
​
boolean | null
Set false to return SQL NULL as the string “null”.Default: null.
​
string | null
Unique UUID for the API request.Default: null.
​
boolean | null
Set true with the same requestId when resubmitting a request.Default: null.

​
Get SQL statement

Action ID: tools.snowflake.get_statement Check statement status or retrieve a result partition. Reference: https://docs.snowflake.com/en/developer-guide/sql-api/reference#get-apiv2statementsstatementhandle

​
Secrets

Optional secrets:
  • snowflake_oauth: OAuth token SNOWFLAKE_USER_TOKEN.
  • snowflake_oauth: OAuth token SNOWFLAKE_SERVICE_TOKEN.
  • snowflake: required values SNOWFLAKE_OAUTH_CLIENT_ID, SNOWFLAKE_OAUTH_CLIENT_SECRET, SNOWFLAKE_OAUTH_TOKEN_URL; optional values SNOWFLAKE_OAUTH_SCOPE, SNOWFLAKE_OAUTH_AUDIENCE, SNOWFLAKE_OAUTH_TOKEN_ENDPOINT_AUTH_METHOD.

​
Input fields

​
string
required
Handle of the statement to check.
​
string | null
Snowflake account URL, for example https://org-account.snowflakecomputing.com.Default: null.
​
integer | null
Partition number to return.Default: null.
​
string | null
Unique UUID for the API request.Default: null.