Execute SQL queries, manage databases, and handle data warehousing with Snowflake.
Execute SQL queries and manage data warehousing operations in Snowflake, including submitting statements for execution, monitoring their status, and canceling long-running queries when needed.
Required:
action
- The operation to perform (execute, check-status, cancel)Optional:
timeout
- Query timeout in seconds (default: 60)statement-handle
- Handle for status checking or cancellationSubmit a SQL statement for execution in Snowflake
Parameters:
statement
(required) - The SQL statement to executetimeout
(optional) - Query timeout in secondsExample:
Response:
Retrieve the status of a previously submitted SQL statement
Parameters:
statement-handle
(required) - The handle of the statement to checkExample:
Response:
Cancel the execution of a running SQL statement
Parameters:
statement-handle
(required) - The handle of the statement to cancelExample:
Response:
Snowflake supports standard SQL syntax and provides detailed metadata about query results including row types, column names, and data types.