Tools

Manage Task

Create, retrieve, list, execute, or delete Snowflake tasks. Tasks schedule SQL statements or stored procedure calls on a recurring basis. Use the **execute** action to manually trigger a task run.

Manage Warehouse

Create, retrieve, list, delete, resume, suspend, or abort queries on Snowflake virtual warehouses. Warehouses provide the compute resources for executing queries. Use the **action** field to control the operation.

Check Statement Status

Check the execution status of a previously submitted SQL statement and retrieve its results. Use this after submitting an asynchronous query to poll for completion and fetch result data, or to retrieve additional result partitions for large result sets.

Manage Role

Create, retrieve, list, or delete Snowflake roles. Roles control access privileges to objects and operations. Use roles in conjunction with grants to manage fine-grained permissions.

Manage User

Create, retrieve, list, or delete Snowflake users. Users represent individual accounts that can connect to and interact with Snowflake. When creating a user, optionally assign a default role, warehouse, and namespace.

Manage Grant

Grant or revoke privileges on Snowflake objects. Use this to control access by assigning specific privileges (e.g. SELECT, INSERT, USAGE) on resources (databases, schemas, tables, warehouses) to roles.

Manage Database

Create, retrieve, list, or delete Snowflake databases. Use the **action** field to specify the operation. When listing, optionally filter by pattern. When creating, provide the database name and optional settings like comment, data retention, etc.

Execute SQL

Execute one or more SQL statements against Snowflake and return the results. Supports SELECT queries, DDL (CREATE, ALTER, DROP), and DML (INSERT, UPDATE, DELETE) statements. Multiple statements can be separated by semicolons. Results include column metadata and row data for queries, or affected row counts for DML.

Cancel Statement

Cancel a running or queued SQL statement. Provide the statement handle from a previous execution to stop it.

Manage Table

Create, retrieve, list, or delete tables within a Snowflake database and schema. When creating, define columns with their data types. For complex table alterations, use the Execute SQL tool with ALTER TABLE statements.

Manage Schema

Create, retrieve, list, or delete schemas within a Snowflake database. Schemas organize tables and other objects within a database. Provide the parent database name and the desired action.