Snowflake

Snowflake is a cloud-based data warehouse offering elastic scaling, secure data sharing, and SQL analytics across multiple cloud environments snowflake · 17 tools · no triggers

Connect it

run auth snowflake
run auth snowflake --scope team    # shared with the organization

Or from the Integrations page in the console. See Connections for personal versus shared, and who may remove one.

Use it

run snowflake          # common commands
run snowflake --all    # every command

import { snowflake } from "@boxd/run";

Common tools

Tool	What it does
`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.
`drop-warehouse`	Drops (permanently deletes) a warehouse in Snowflake. This operation is irreversible - once a warehouse is dropped, it cannot be recovered.
`execute-sql`	Execute SQL statements in Snowflake and retrieve results. Supports SELECT queries for data retrieval, DDL statements (CREATE, ALTER, DROP) for schema…
`fetch-catalog-integration`	Retrieves detailed configuration and metadata for a specific catalog integration.
`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).
`get-unresolved-incidents`	Retrieves a list of any unresolved incidents from the Snowflake status page.
`get-upcoming-scheduled-maintenances`	Retrieves upcoming scheduled maintenances from Snowflake’s public status page.
`show-databases`	Lists all databases for which you have access privileges. Shows database metadata including name, creation date, owner, retention time, and more.
`show-schemas`	Lists all schemas for which you have access privileges. Shows schema metadata including name, creation date, owner, database, retention time, and more.
`show-tables`	Lists all tables for which you have access privileges. Shows table metadata including name, creation date, owner, database, schema, row count, size…
`submit-sql-statement`	DEPRECATED: Use ExecuteSql instead. Submits a SQL statement for execution.
`validate-credential`	Validates Snowflake credentials by executing a lightweight test query.

All 17 tools

Tool	What it does
`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.
`drop-warehouse`	Drops (permanently deletes) a warehouse in Snowflake. This operation is irreversible - once a warehouse is dropped, it cannot be recovered.
`execute-sql`	Execute SQL statements in Snowflake and retrieve results. Supports SELECT queries for data retrieval, DDL statements (CREATE, ALTER, DROP) for schema…
`fetch-catalog-integration`	Retrieves detailed configuration and metadata for a specific catalog integration.
`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).
`get-unresolved-incidents`	Retrieves a list of any unresolved incidents from the Snowflake status page.
`get-upcoming-scheduled-maintenances`	Retrieves upcoming scheduled maintenances from Snowflake’s public status page.
`show-databases`	Lists all databases for which you have access privileges. Shows database metadata including name, creation date, owner, retention time, and more.
`show-schemas`	Lists all schemas for which you have access privileges. Shows schema metadata including name, creation date, owner, database, retention time, and more.
`show-tables`	Lists all tables for which you have access privileges. Shows table metadata including name, creation date, owner, database, schema, row count, size…
`submit-sql-statement`	DEPRECATED: Use ExecuteSql instead. Submits a SQL statement for execution.
`validate-credential`	Validates Snowflake credentials by executing a lightweight test query.

Open Snowflake in the console →

Getting started

Guides

Integrations & automations

Use cases

References

Connect it

Use it

Common tools

​Connect it

​Use it

​Common tools

Connect it

Use it

Common tools