> ## Documentation Index > Fetch the complete documentation index at: https://docs.boxd.sh/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 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 ```bash theme={"theme":"github-dark"} run auth snowflake run auth snowflake --scope team # shared with the organization ``` Or from the [Integrations page](https://app.boxd.sh/integrations) in the console. See [Connections](/guides/integrations/connections) for personal versus shared, and who may remove one. ## Use it ```bash theme={"theme":"github-dark"} run snowflake # common commands run snowflake --all # every command ``` ```ts theme={"theme":"github-dark"} 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. | | 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 →](https://app.boxd.sh/integrations/detail/snowflake)