Snowflake for AI agents
Agents read Snowflake at once. Changes and sends are held for a person's approval by default.
About Snowflake
Snowflake is a cloud-based data warehouse offering elastic scaling, secure data sharing, and SQL analytics across multiple cloud environments
What an agent can do in Snowflake
Every Snowflake action is classed by the platform as a read, a change or a send. Reads run at once. Changes and sends are held for a person by default.
Runs at once (reads)
Looks things up in Snowflake without asking first. 13 actions.
- Check Statement StatusRetrieves the status and results of a previously submitted SQL statement using its statement handle. Use this to poll async queries submitted via SNOWFLAKE_SUBMIT_SQL_STATEMENT; call repeatedly until
- 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/
- Get Active Scheduled MaintenancesRetrieves a list of any active scheduled maintenances currently in the In Progress or Verifying state.
- Get All Scheduled MaintenancesRetrieves a list of the 50 most recent scheduled maintenances, including those in the Completed state.
- Get Component StatusRetrieves the status of individual components, each listed with its current status.
- Get Status RollupRetrieves the status rollup for the entire page, including indicators and human-readable descriptions of the blended component status.
- Get Status SummaryRetrieves the current status summary from Snowflake's public status page (status.snowflake.com). Returns overall system status, operational status of all regional components (AWS, Azure, GCP regions),
- 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 t
- 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 'Sch
- 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 withi
- 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 w
- Show TablesLists all tables for which you have access privileges. Shows table metadata including name, creation date, owner, database, schema, row count, size in bytes, clustering keys, and more. Can filter resu
Show all 13
- Validate CredentialValidates Snowflake credentials by executing a lightweight test query. Returns session information if credentials are valid, or error details if authentication fails. Use this action when you need to
Held for approval by default (changes and sends)
Held for a person's approval by default. The approval is recorded and the action is sent once, never twice, with 10 seconds to undo. 3 actions.
- Cancel Statement ExecutionCancels the execution of a running SQL statement. Use this action to stop a long-running query.
- Drop WarehouseDrops (permanently deletes) a warehouse in Snowflake. This operation is irreversible — once a warehouse is dropped, it cannot be recovered. Use this action when you need to permanently remove a wareho
- Execute SQLExecute SQL statements in Snowflake and retrieve results. Supports SELECT queries for data retrieval, DDL statements (CREATE, ALTER, DROP) for schema management, and DML statements (INSERT, UPDATE, DE
Changes wait in Needs you
Changes and sends in Snowflake are held for a person's approval by default. The approval is recorded, and the action is sent once, never twice, with 10 seconds to undo.
Snowflake questions
Can an agent change data in Snowflake on its own?
Not by default. Changes and sends in Snowflake are held for a person's approval. The approval is recorded, and the action is sent once, never twice, with 10 seconds to undo.
What can an agent read in Snowflake?
This connector lists 13 read actions. Reads run at once, without waiting for approval.
How does Snowflake connect?
It connects with OAuth 2.0. Connectors are built and maintained by third-party developers; availability is confirmed during scoping.