Snowflake

Execute simple SELECT queries that complete within 45 seconds and return results immediately

Execute SQL statements with custom formatting and optional async execution for operations exceeding 45 seconds

Retrieve execution status, progress, and results for asynchronously submitted SQL statements

Retrieve results from executed SQL queries

Terminate actively running SQL statements to reclaim compute resources and prevent unwanted operations

Retrieve list of all databases in the account

Fetch metadata and properties of a specific database

Create a new database in the Snowflake account

Modify database properties like data retention or ownership

Drop a database and all its contained objects

Create a copy of an existing database with all its objects

Restore a previously dropped database within the Time Travel retention period

Get all schemas in a specific database

Retrieve metadata for a specific schema

Create a new schema within a database

Modify schema properties like data retention or managed access

Drop a schema and all its contained objects

Retrieve all tables within a schema

Fetch table metadata including columns, constraints, and statistics

Create new permanent, transient, or temporary table

Modify table properties like clustering keys or retention period

Drop a table and its data

Create a new table populated from a SQL SELECT query

Create or replace a table with updated structure and properties

Create a copy of an existing table with its data and structure

Restore a previously dropped table within the Time Travel retention period

Get all views in a schema

Retrieve view definition and metadata

Create standard, secure, or materialized view

Drop a view

Get all warehouses in the account

Retrieve warehouse configuration and current status

Provision a new virtual warehouse with specified size and properties

Drop a virtual warehouse

Resume a suspended warehouse to begin processing queries

Pause a running warehouse to stop consuming credits

Create or replace a warehouse with updated configuration

Retrieve all user accounts in the account

Fetch user profile information and settings

Provision a new user account with authentication settings

Modify user properties like email, default role, or MFA settings

Remove a user account from the system

Get all roles in the account

Define a new role for access control

Drop a custom role

Assign a role to a user account

Remove role assignment from a user

Grant object privileges to a role for access control

List all privileges granted to a role

Revoke object privileges from a role

List the users and roles this role has been granted to

List privileges granted on the role object itself

List future grants defined for a role

Grant privileges on future objects to a role

Revoke future-object privileges from a role

Assign tag values to a role

Remove tag assignments from a role

Get the tag assignments for a role

Get all stages in a schema

Retrieve stage configuration and storage integration details

Create internal or external stage for data loading and unloading

Modify stage properties like file format or credentials

Drop a stage object

Get all pipes in a schema

Retrieve pipe configuration and status

Set up Snowpipe for continuous data ingestion

Modify pipe properties or COPY statement

Drop a Snowpipe object

Get all streams in a schema

Retrieve stream metadata and current offset

Create change data capture stream on table or view

Drop a stream object

Get all tasks in a schema

Retrieve task definition, schedule, and status

Define scheduled or DAG-based task for automation

Modify task schedule, definition, or warehouse

Drop a task object

Enable a suspended task to run on schedule

Pause a running task to stop scheduled execution

Manually trigger a task to run immediately

Get all user-defined functions in a schema

Retrieve function signature and implementation

Drop a user-defined function

Define a user-defined function in SQL, JavaScript, Python, Java, or Scala

Get all stored procedures in a schema

Retrieve procedure definition and metadata

Define stored procedure in SQL, JavaScript, Python, Java, or Scala

Drop a stored procedure

Execute a stored procedure with parameters