Authentication: OAuth, key-pair authentication, or programmatic access token. See Magic Link for the runtime auth flow, or Application credentials to bring your own OAuth app.
ANALYTICS.EVENTS.PROD schema by row count.List all databases in the Snowflake account
Create a new database in Snowflake
Alter an existing database in Snowflake
Drop a database from Snowflake
Get details of a specific database
List all schemas in a database
Create a new schema in a database
Alter an existing schema in Snowflake
Drop a schema from a database
Get details of a specific schema
List all roles in the Snowflake account
Create a new role in Snowflake
Drop a role from Snowflake
Get details of a specific role
Grant privileges to a role on a Snowflake object
Revoke privileges from a role on a Snowflake object
Grant a role to a user or another role
Revoke a role from a user or another role
Execute a SQL statement in Snowflake (query, DDL, or DML)
Get the status of an asynchronous SQL statement
Fetch results from a completed SQL query with pagination
Cancel a running SQL statement
List all stages in a schema
Create a new stage for data loading/unloading
Drop a stage from Snowflake
Get details of a specific stage
List files in a stage
Describe a stage to see its properties and file format settings
Load data from a stage into a table. Supports file patterns, error handling modes, and validation.
Unload data from a table or query to a stage. Supports file format and partitioning options.
List all tables in a schema
Create a new table in Snowflake
Alter an existing table in Snowflake
Drop a table from Snowflake
Get the structure and column definitions of a table
Get details of a specific table
List all tasks in a schema
Create a new scheduled task in Snowflake
Alter an existing task in Snowflake
Drop a task from Snowflake
Resume a suspended task to start scheduled execution
Suspend a running task to stop scheduled execution
Execute a task immediately without waiting for schedule
Get execution history for a task
Get details of a specific task
List all users in the Snowflake account
Create a new user in Snowflake
Alter an existing user in Snowflake
Drop a user from Snowflake
Get details of a specific user
Validate Snowflake credentials by executing a lightweight query. Supports OAuth2, key-pair, and programmatic access token authentication. Returns {success, message}.
List all warehouses in the Snowflake account
Create a new virtual warehouse in Snowflake
Alter an existing warehouse in Snowflake
Drop a warehouse from Snowflake
Resume a suspended warehouse
Suspend a running warehouse to stop billing
Get details of a specific warehouse