Team
Shared credential for production and unattended runs.
Connect Snowflake with Hookshot™ and your stack
Snowflake is a cloud-based data warehouse offering elastic scaling, secure data sharing, and SQL analytics across multiple cloud environments
Tools and triggers
What Agents can do in Snowflake
Available tools and events after Snowflake is connected.
-
Cancel Statement Execution
Cancels the execution of a running SQL statement. Use this action to stop a long-running query.
-
Check Statement Status
Retrieves 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 status is no…
-
Drop Warehouse
Drops (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 warehouse that is no…
-
Execute SQL
Execute 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, DELETE) for data…
-
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…
-
Get Active Scheduled Maintenances
Retrieves a list of any active scheduled maintenances currently in the In Progress or Verifying state.
-
Get All Scheduled Maintenances
Retrieves a list of the 50 most recent scheduled maintenances, including those in the Completed state.
-
Get Component Status
Retrieves the status of individual components, each listed with its current status.
-
Get Status Rollup
Retrieves the status rollup for the entire page, including indicators and human-readable descriptions of the blended component status.
-
Get Status Summary
Retrieves 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), any unresolved…
-
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…
-
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…
-
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…
-
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…
-
Show Tables
Lists 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 results and include…
-
Validate Credential
Validates 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 verify that API…
Setup
Connect Snowflake in Hookshot™
Pick a scope, then confirm what can start a Protege and what it can do.
Trigger Access
What can start a Protege from this app.
Tool Access
What a Protege can do after it starts.
Connection scope
Prefer team for production.
Personal
Tied to one user—only when the workflow needs their account.
Chat
Team-scoped for supported chat surfaces.
Build with us
See Hookshot™ in your stack.
Request early access or book a live walkthrough with the team.
