- Category: databases
- Auth: OAUTH2
- Composio-managed OAuth available? No
- Tools: 17
- Triggers: 0
- Slug:
SNOWFLAKE - Version: 20261101_00
Frequently Asked Questions
How do I set up custom OAuth credentials for Snowflake?
How do I set up custom OAuth credentials for Snowflake?
How do I create a Snowflake OAuth app?
How do I create a Snowflake OAuth app?
How do I configure roles and permissions for Snowflake?
How do I configure roles and permissions for Snowflake?
Does Snowflake require per-user OAuth credentials?
Does Snowflake require per-user OAuth credentials?
Tools
Cancel Statement Execution
Cancel Statement Execution
SNOWFLAKE_CANCEL_STATEMENT_EXECUTIONCancels the execution of a running SQL statement. Use this action to stop a long-running query.Input Parameters
Output
Check Statement Status
Check Statement Status
Drop Warehouse
Drop Warehouse
SNOWFLAKE_DROP_WAREHOUSEDrops 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
Output
Execute SQL
Execute SQL
SNOWFLAKE_EXECUTE_SQLSubmits 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
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.Output
Fetch Catalog Integration
Fetch Catalog Integration
SNOWFLAKE_FETCH_CATALOG_INTEGRATIONRetrieves 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
Output
Get Active Scheduled Maintenances
Get Active Scheduled Maintenances
Get All Scheduled Maintenances
Get All Scheduled Maintenances
Get Component Status
Get Component Status
Get Status Rollup
Get Status Rollup
Get Status Summary
Get Status Summary
SNOWFLAKE_GET_STATUS_SUMMARYRetrieves 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
Get Unresolved Incidents
Get Unresolved Incidents
SNOWFLAKE_GET_UNRESOLVED_INCIDENTSRetrieves 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
Get Upcoming Scheduled Maintenances
Get Upcoming Scheduled Maintenances
SNOWFLAKE_GET_UPCOMING_SCHEDULED_MAINTENANCESRetrieves 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
Show Databases
Show Databases
SNOWFLAKE_SHOW_DATABASESLists 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
Output
Show Schemas
Show Schemas
SNOWFLAKE_SHOW_SCHEMASLists 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
Output
Show Tables
Show Tables
SNOWFLAKE_SHOW_TABLESLists 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
Output
Submit SQL Statement (Deprecated)
Submit SQL Statement (Deprecated)
SNOWFLAKE_SUBMIT_SQL_STATEMENTDEPRECATED: 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
Output
Validate Credential
Validate Credential