> ## Documentation Index
> Fetch the complete documentation index at: https://composio-preview.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Snowflake

> Snowflake is a cloud-based data warehouse offering elastic scaling, secure data sharing, and SQL analytics across multiple cloud environments

![Snowflake logo](https://mintcdn.com/composio-preview/B09iGux45A5cYDuO/images/toolkits/snowflake.svg?fit=max\&auto=format\&n=B09iGux45A5cYDuO\&q=85\&s=701f561a53df3e6924af3c93a96cad1e)

* **Category:** databases
* **Auth:** OAUTH2
* **Composio-managed OAuth available?** No
* **Tools:** 17
* **Triggers:** 0
* **Slug:** `SNOWFLAKE`
* **Version:** 20261101\_00

## Frequently Asked Questions

> [accordion] How do I set up custom OAuth credentials for Snowflake?
>
> For a step-by-step guide on creating and configuring your own Snowflake OAuth credentials with Composio, see [How to create OAuth credentials for Snowflake](https://composio.dev/auth/snowflake).

> [accordion] How do I create a Snowflake OAuth app?
>
> Example Snowflake SQL to create a security integration for OAuth:
>
> ```sql theme={null}
> CREATE SECURITY INTEGRATION oauth_custom_all_roles
>   TYPE = oauth
>   ENABLED = true
>   OAUTH_CLIENT_TYPE = 'CONFIDENTIAL'
>   OAUTH_REDIRECT_URI = 'https://your-app.com/oauth/callback'
>   OAUTH_REFRESH_TOKEN_VALIDITY = 7776000;
> ```

> [accordion] How do I configure roles and permissions for Snowflake?
>
> Ensure the OAuth app and Snowflake roles, databases, and schemas are configured correctly for the integration.

> [accordion] Does Snowflake require per-user OAuth credentials?
>
> Yes. Snowflake OAuth is tied to the user's Snowflake account and security integration. There is not a single generic Snowflake OAuth app that can safely cover every account, role setup, redirect URI, and security policy.
>
> For a production integration, each Snowflake user should bring the OAuth client credentials from the security integration configured in their own Snowflake account. Create a Composio auth config with those credentials, then let the user connect with the account identifier and permissions for that Snowflake account. This keeps the connection aligned with the user's Snowflake roles, databases, schemas, and refresh-token policy.

## Tools

> [accordion] Cancel Statement Execution
>
> **Slug:** `SNOWFLAKE_CANCEL_STATEMENT_EXECUTION`
>
> Cancels the execution of a running SQL statement. Use this action to stop a long-running query.
>
> #### Input Parameters
>
> **request\_id** `string`
>
> Unique ID (a UUID) of the API request. This is an optional parameter that can be used to track the request.
>
> **statement\_handle** `string` *required*
>
> The handle of the statement to be cancelled. This can be obtained from the response of the execute\_statement action.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Check Statement Status
>
> **Slug:** `SNOWFLAKE_CHECK_STATEMENT_STATUS`
>
> Checks a submitted SQL statement by handle and retrieves results for a completed statement, optionally for a specified partition. If execution is still in progress, the tool reports an execution error indicating that it should be retried.
>
> #### Input Parameters
>
> **partition** `integer`
>
> The partition number to return. The size of each partition is determined by Snowflake.
>
> **requestId** `string`
>
> Unique ID (UUID) of the API request for idempotency.
>
> **statementHandle** `string` *required*
>
> The handle of the statement to be checked.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Drop Warehouse
>
> **Slug:** `SNOWFLAKE_DROP_WAREHOUSE`
>
> Drops a Snowflake warehouse by its case-sensitive name. Requires OWNERSHIP privilege on the warehouse. Optionally use the if-exists condition to avoid an error when the warehouse is absent.
>
> #### Input Parameters
>
> **name** `string` *required*
>
> Identifier (i.e. name) for the warehouse to drop. The value is case-sensitive and must match the exact warehouse name in Snowflake.
>
> **if\_exists** `boolean`
>
> If true, the endpoint does not throw an error if the warehouse does not exist. It returns a 200 success response without taking action. If false, the endpoint throws an error if the warehouse doesn't exist.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Execute SQL
>
> **Slug:** `SNOWFLAKE_EXECUTE_SQL`
>
> Submits SQL statements to Snowflake, including SELECT, DDL, and DML. Completed single-statement responses may include result rows and metadata; long-running statements may return a handle, and multi-statement responses provide handles for individual results.
>
> #### Input Parameters
>
> **role** `string`
>
> Role name to use for execution (case-sensitive). If not specified, uses the user's DEFAULT\_ROLE setting.
>
> **timeout** `integer`
>
> Execution timeout in seconds. Set to 0 for maximum timeout (604800 seconds). If not specified, uses the default timeout.
>
> **bindings** `object`
>
> Values of bind variables in the SQL statement. Use this for parameterized queries to prevent SQL injection.
>
> **database** `string`
>
> Database name to use for execution (case-sensitive). If not specified, uses the user's DEFAULT\_NAMESPACE setting.
>
> **statement** `string` *required*
>
> SQL statement(s) to execute. Supports SELECT queries, DDL (CREATE, ALTER, DROP), and DML (INSERT, UPDATE, DELETE). Multiple statements can be separated by semicolons; they will be executed in sequence automatically. When querying INFORMATION\_SCHEMA, always filter on both `table_schema` and `table_catalog` and wrap mixed AND/OR conditions in parentheses. For multi-statement batches, test critical sections in isolation first — a single failing statement obscures root cause.
>
> **warehouse** `string`
>
> Warehouse name to use for query execution (case-sensitive). Required for queries that need compute resources. If not specified, uses the user's DEFAULT\_WAREHOUSE setting. Suspended or undersized warehouses cause high latency or timeouts; verify the warehouse is active and appropriately sized before execution.
>
> **parameters** `object`
>
> Session parameters to set for the statement execution. These are Snowflake session-level parameters.
>
> **schema\_name** `string`
>
> Schema name to use for execution (case-sensitive). If not specified, uses the user's DEFAULT\_NAMESPACE setting.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Fetch Catalog Integration
>
> **Slug:** `SNOWFLAKE_FETCH_CATALOG_INTEGRATION`
>
> Retrieves detailed configuration and metadata for a specific catalog integration. Catalog integrations allow Snowflake to connect to external Apache Iceberg catalogs (AWS Glue, Snowflake Open Catalog/Polaris, or Apache Iceberg REST catalogs) to query Iceberg tables managed by those external systems.
>
> #### Input Parameters
>
> **name** `string` *required*
>
> The name (identifier) of the catalog integration to fetch details for. This is case-sensitive.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Get Active Scheduled Maintenances
>
> **Slug:** `SNOWFLAKE_GET_ACTIVE_SCHEDULED_MAINTENANCES`
>
> Retrieves a list of any active scheduled maintenances currently in the In Progress or Verifying state.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Get All Scheduled Maintenances
>
> **Slug:** `SNOWFLAKE_GET_ALL_SCHEDULED_MAINTENANCES`
>
> Retrieves up to 10 of the 50 most recent scheduled maintenances from Snowflake's status page, including completed events.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Get Component Status
>
> **Slug:** `SNOWFLAKE_GET_COMPONENT_STATUS`
>
> Retrieves the status of individual components, each listed with its current status.
>
> #### Input Parameters
>
> **limit** `integer`
>
> Limit number of components returned.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Get Status Rollup
>
> **Slug:** `SNOWFLAKE_GET_STATUS_ROLLUP`
>
> Retrieves the status rollup for the entire page, including indicators and human-readable descriptions of the blended component status.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Get Status Summary
>
> **Slug:** `SNOWFLAKE_GET_STATUS_SUMMARY`
>
> Retrieves Snowflake's public status summary, including overall status, component statuses, unresolved incidents, and upcoming or in-progress maintenance. Returns at most 50 components and 10 incidents and maintenances each; this is global service status, not account-specific information.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Get Unresolved Incidents
>
> **Slug:** `SNOWFLAKE_GET_UNRESOLVED_INCIDENTS`
>
> Retrieves a list of any unresolved incidents from the Snowflake status page. This endpoint returns incidents currently in the Investigating, Identified, or Monitoring state. Returns an empty list if there are no active incidents. This is a public status page API that does not require authentication.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Get Upcoming Scheduled Maintenances
>
> **Slug:** `SNOWFLAKE_GET_UPCOMING_SCHEDULED_MAINTENANCES`
>
> Retrieves upcoming scheduled maintenances from Snowflake's public status page. This action queries the Snowflake status API to get a list of any scheduled maintenance events that are still in the 'Scheduled' state (not yet started or completed). The response includes maintenance details such as impact level, scheduled time windows, incident updates, and direct links to the maintenance notices. Note: This uses Snowflake's public status API and does not require authentication.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Show Databases
>
> **Slug:** `SNOWFLAKE_SHOW_DATABASES`
>
> Lists all databases for which you have access privileges. Shows database metadata including name, creation date, owner, retention time, and more. Can filter results and include dropped databases within Time Travel retention period.
>
> #### Input Parameters
>
> **role** `string`
>
> Role to use when executing the statement.
>
> **limit** `integer`
>
> Maximum number of rows to return. Cannot exceed 10000.
>
> **terse** `boolean`
>
> If true, returns only a subset of output columns (created\_on, name, kind, database\_name, schema\_name).
>
> **history** `boolean`
>
> If true, includes dropped databases that are still within Time Travel retention period.
>
> **timeout** `integer`
>
> Timeout in seconds for statement execution.
>
> **from\_name** `string`
>
> Used with LIMIT for pagination. Returns results starting from databases whose names match this string.
>
> **warehouse** `string`
>
> Warehouse to use for the query (though SHOW DATABASES doesn't require a running warehouse).
>
> **starts\_with** `string`
>
> Filters results by databases whose names start with this string. Case-sensitive.
>
> **like\_pattern** `string`
>
> Filters results by database name using SQL wildcard pattern (% and \_). Case-insensitive.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Show Schemas
>
> **Slug:** `SNOWFLAKE_SHOW_SCHEMAS`
>
> Lists all schemas for which you have access privileges. Shows schema metadata including name, creation date, owner, database, retention time, and more. Can filter results and include dropped schemas within Time Travel retention period.
>
> #### Input Parameters
>
> **role** `string`
>
> Role to use when executing the statement.
>
> **limit** `integer`
>
> Maximum number of rows to return. Cannot exceed 10000.
>
> **terse** `boolean`
>
> If true, returns only a subset of output columns (created\_on, name, kind, database\_name, schema\_name).
>
> **history** `boolean`
>
> If true, includes dropped schemas that are still within Time Travel retention period.
>
> **timeout** `integer`
>
> Timeout in seconds for statement execution.
>
> **database** `string`
>
> Database context for the query.
>
> **in\_scope** `string`
>
> Scope for the command. Options: 'ACCOUNT', 'DATABASE', or a specific database name.
>
> **from\_name** `string`
>
> Used with LIMIT for pagination. Returns results starting from schemas whose names match this string.
>
> **warehouse** `string`
>
> Warehouse to use for the query (though SHOW SCHEMAS doesn't require a running warehouse).
>
> **starts\_with** `string`
>
> Filters results by schemas whose names start with this string. Case-sensitive.
>
> **like\_pattern** `string`
>
> Filters results by schema name using SQL wildcard pattern (% and \_). Case-insensitive.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Show Tables
>
> **Slug:** `SNOWFLAKE_SHOW_TABLES`
>
> Lists accessible Snowflake tables in the requested scope, with metadata, filters, and optional dropped-table history. Results may be incomplete: only the initial response is returned, and an in-progress response can appear as an empty list.
>
> #### Input Parameters
>
> **role** `string`
>
> Role to use when executing the statement.
>
> **limit** `integer`
>
> Maximum number of rows to return. Cannot exceed 10000.
>
> **terse** `boolean`
>
> If true, returns only a subset of output columns (created\_on, name, kind, database\_name, schema\_name).
>
> **schema** `string`
>
> Schema context for the query.
>
> **history** `boolean`
>
> If true, includes dropped tables that are still within Time Travel retention period.
>
> **timeout** `integer`
>
> Timeout in seconds for statement execution.
>
> **database** `string`
>
> Database context for the query.
>
> **in\_scope** `string`
>
> Scope for the command. Options: 'ACCOUNT', 'DATABASE', 'SCHEMA', or specific database/schema names.
>
> **from\_name** `string`
>
> Used with LIMIT for pagination. Returns results starting from tables whose names match this string.
>
> **warehouse** `string`
>
> Warehouse to use for the query (though SHOW TABLES doesn't require a running warehouse).
>
> **starts\_with** `string`
>
> Filters results by tables whose names start with this string. Case-sensitive.
>
> **like\_pattern** `string`
>
> Filters results by table name using SQL wildcard pattern (% and \_). Case-insensitive.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Submit SQL Statement (Deprecated)
>
> **Slug:** `SNOWFLAKE_SUBMIT_SQL_STATEMENT`
>
> DEPRECATED: Submits a SQL statement to Snowflake for execution. Results may be returned immediately; longer-running statements may return a handle for status checks.
>
> #### Input Parameters
>
> **role** `string`
>
> Role to use when executing the statement. The value in this field is case-sensitive. If you omit this field, the SQL API uses the value of the DEFAULT\_ROLE property of the user.
>
> **schema** `string`
>
> Schema in which the statement should be executed. The value in this field is case-sensitive. If you omit this field, the SQL API uses the schema from the value of the DEFAULT\_NAMESPACE property of the user.
>
> **timeout** `integer`
>
> Timeout in seconds for statement execution. If the execution of a statement takes longer than the specified timeout, the execution is automatically canceled. To set the timeout to the maximum value (604800 seconds), set timeout to 0. If this field is not set, the timeout specified by the STATEMENT\_TIMEOUT\_IN\_SECONDS parameter is used.
>
> **bindings** `object`
>
> Values of bind variables in the SQL statement. When executing the statement, Snowflake replaces placeholders ( ? and :name) in the statement with these specified values.
>
> **database** `string`
>
> Database in which the statement should be executed. The value in this field is case-sensitive. If you omit this field, the SQL API uses the database from the value of the DEFAULT\_NAMESPACE property of the user.
>
> **statement** `string` *required*
>
> The SQL statement to execute. Unquoted identifiers are automatically uppercased by Snowflake; quote identifiers to preserve case. When querying INFORMATION\_SCHEMA views, filter by both table\_schema and table\_catalog to avoid results from unintended databases or schemas.
>
> **warehouse** `string`
>
> Warehouse to use when executing the statement. The value in this field is case-sensitive. If you omit this field, the SQL API uses the value of the DEFAULT\_WAREHOUSE property of the user.
>
> **parameters** `object`
>
> Session parameters that you want to set for this request.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Validate Credential
>
> **Slug:** `SNOWFLAKE_VALIDATE_CREDENTIAL`
>
> Checks Snowflake credentials by submitting a lightweight session query, useful before running other account operations. Returns a validity flag, a session ID when available, and a status message. Basic authentication is not supported for this check.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not
