Connect your own Snowflake account to run SQL, manage warehouses (create/resize/suspend/resume), databases/schemas/tables, roles/users/grants, tasks, resource monitors, and audit account health and...
What this app can do
38 tools registered
Connect SnowflakeFree
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 ConnectionsFree
List the connected Snowflake accounts.
Disconnect SnowflakeFree
Disconnect a Snowflake account: deletes the saved Key-Pair/PAT. Nothing in Snowflake itself is changed.
Execute Sql16 tok
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.
Get Statement Status8 tok
Read a SQL statement's current status -- whether it's done, and its row count once finished.
Get Statement Result8 tok
Read a page of results from a completed (or still-running) SQL statement.
Cancel Statement20 tok
Cancel a running SQL statement.
List Warehouses8 tok
List virtual warehouses (compute clusters) configured on the connected Snowflake account -- their size, state (started/suspended), and auto-suspend setting.
Create Warehouse16 tok
Create a new virtual warehouse (compute cluster) on the connected Snowflake account.
Resize Warehouse16 tok
Change a warehouse's size (e.g. from SMALL to LARGE) to adjust its compute power.
Suspend Warehouse16 tok
Suspend a running warehouse to stop consuming credits.
Resume Warehouse16 tok
Resume (start) a suspended warehouse.
Delete Warehouse20 tok
Permanently delete a warehouse. Cannot be undone.
List Databases8 tok
List databases on the connected Snowflake account.
Create Database16 tok
Create a new database on the connected Snowflake account.
Delete Database20 tok
Permanently delete a database and everything inside it. Cannot be undone.
List Schemas8 tok
List schemas inside one database on the connected Snowflake account.
Create Schema16 tok
Create a new schema inside an existing database.
Delete Schema20 tok
Permanently delete a schema and everything inside it. Cannot be undone.
List Tables8 tok
List tables and views inside one schema on the connected Snowflake account.
Delete Table20 tok
Permanently delete a table. Cannot be undone.
List Roles8 tok
List roles configured on the connected Snowflake account.
Create Role16 tok
Create a new role on the connected Snowflake account.
Delete Role20 tok
Permanently delete a role. Cannot be undone.
List Users8 tok
List users configured on the connected Snowflake account.
Create User16 tok
Create a new user on the connected Snowflake account.
Set User Disabled20 tok
Enable or disable a user's sign-in access on the connected Snowflake account.
Delete User20 tok
Permanently delete a user. Cannot be undone.
Grant Role16 tok
Grant a role to a user or to another role (role hierarchy). Set exactly one of to_user/to_role.
Revoke Role20 tok
Revoke a role from a user or from another role. Set exactly one of from_user/from_role.
List Grants8 tok
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 Monitors8 tok
List resource monitors (credit-quota cost guards) configured on the connected Snowflake account, with current usage against quota.
Create Resource Monitor16 tok
Create a new resource monitor -- a credit-quota cost guard that can suspend warehouses once a spending limit is reached.
Delete Resource Monitor20 tok
Permanently delete a resource monitor. Cannot be undone -- warehouses it was guarding lose that cost protection.
List Tasks8 tok
List scheduled SQL tasks in a database/schema on the connected Snowflake account.
Set Task State16 tok
Resume (start) or suspend a scheduled task.
List Query History8 tok
List recent query execution history on the connected Snowflake account -- status, duration, bytes scanned, and which warehouse/user ran it.
Audit Account40 tok
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.