Snowflake Extension

Connect your own Snowflake account by saving its account identifier plus a Key-Pair private key or Programmatic Access Token, after checking it actually works.

List the connected Snowflake accounts.

Disconnect a Snowflake account: deletes the saved Key-Pair/PAT. Nothing in Snowflake itself is changed.

Execute a SQL statement (query, DDL, or DML) against the connected Snowflake account. Resolves inline if it finishes within timeout_seconds, otherwise returns a statement_handle to poll with get_statement_status/get_statement_result.

Read a SQL statement's current status -- whether it's done, and its row count once finished.

Read a page of results from a completed (or still-running) SQL statement.

Cancel a running SQL statement.

List virtual warehouses (compute clusters) configured on the connected Snowflake account -- their size, state (started/suspended), and auto-suspend setting.

Create a new virtual warehouse (compute cluster) on the connected Snowflake account.

Change a warehouse's size (e.g. from SMALL to LARGE) to adjust its compute power.

Suspend a running warehouse to stop consuming credits.

Resume (start) a suspended warehouse.

Permanently delete a warehouse. Cannot be undone.

List databases on the connected Snowflake account.

Create a new database on the connected Snowflake account.

Permanently delete a database and everything inside it. Cannot be undone.

List schemas inside one database on the connected Snowflake account.

Create a new schema inside an existing database.

Permanently delete a schema and everything inside it. Cannot be undone.

List tables and views inside one schema on the connected Snowflake account.

Permanently delete a table. Cannot be undone.

List roles configured on the connected Snowflake account.

Create a new role on the connected Snowflake account.

Permanently delete a role. Cannot be undone.

List users configured on the connected Snowflake account.

Create a new user on the connected Snowflake account.

Enable or disable a user's sign-in access on the connected Snowflake account.

Permanently delete a user. Cannot be undone.

Grant a role to a user or to another role (role hierarchy). Set exactly one of to_user/to_role.

Revoke a role from a user or from another role. Set exactly one of from_user/from_role.

List privileges granted to a role, or the users/roles a role has been granted to. Set exactly one of to_role/of_role.

List resource monitors (credit-quota cost guards) configured on the connected Snowflake account, with current usage against quota.

Create a new resource monitor -- a credit-quota cost guard that can suspend warehouses once a spending limit is reached.

Permanently delete a resource monitor. Cannot be undone -- warehouses it was guarding lose that cost protection.

List scheduled SQL tasks in a database/schema on the connected Snowflake account.

Resume (start) or suspend a scheduled task.

List recent query execution history on the connected Snowflake account -- status, duration, bytes scanned, and which warehouse/user ran it.

Build one aggregated health report for the connected Snowflake account: warehouses without auto_suspend (credit leakage risk), resource monitors near their quota, and the most expensive queries in the last 24 hours.