Actions

89 actions

Action

Description

Execute Query

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

Execute SQL Statement

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

Check Statement Status

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

Get Statement Results

Retrieve results from executed SQL queries

Cancel Statement Execution

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

List Databases

Retrieve list of all databases in the account

Fetch Database Details

Fetch metadata and properties of a specific database

Create Database

Create a new database in the Snowflake account

Update Database

Modify database properties like data retention or ownership

Delete Database

Drop a database and all its contained objects

Clone Database

Create a copy of an existing database with all its objects

Undrop Database

Restore a previously dropped database within the Time Travel retention period

List Schemas

Get all schemas in a specific database

Fetch Schema Details

Retrieve metadata for a specific schema

Create Schema

Create a new schema within a database

Update Schema

Modify schema properties like data retention or managed access

Delete Schema

Drop a schema and all its contained objects

List Tables

Retrieve all tables within a schema

Fetch Table Details

Fetch table metadata including columns, constraints, and statistics

Create Table

Create new permanent, transient, or temporary table

Update Table

Modify table properties like clustering keys or retention period

Delete Table

Drop a table and its data

Create Table As Select

Create a new table populated from a SQL SELECT query

Alter Table

Create or replace a table with updated structure and properties

Clone Table

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

Undrop Table

Restore a previously dropped table within the Time Travel retention period

List Views

Get all views in a schema

Fetch View Details

Retrieve view definition and metadata

Create View

Create standard, secure, or materialized view

Delete View

Drop a view

List Warehouses

Get all warehouses in the account

Fetch Warehouse Details

Retrieve warehouse configuration and current status

Create Warehouse

Provision a new virtual warehouse with specified size and properties

Delete Warehouse

Drop a virtual warehouse

Start Warehouse

Resume a suspended warehouse to begin processing queries

Suspend Warehouse

Pause a running warehouse to stop consuming credits

Alter Warehouse

Create or replace a warehouse with updated configuration

List Users

Retrieve all user accounts in the account

Fetch User Details

Fetch user profile information and settings

Create User

Provision a new user account with authentication settings

Update User

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

Delete User

Remove a user account from the system

List Roles

Get all roles in the account

Create Role

Define a new role for access control

Delete Role

Drop a custom role

Grant Role To User

Assign a role to a user account

Revoke Role From User

Remove role assignment from a user

Grant Privileges To Role

Grant object privileges to a role for access control

List Grants To Role

List all privileges granted to a role

Revoke Privileges From Role

Revoke object privileges from a role

List Grants Of Role

List the users and roles this role has been granted to

List Grants On Role

List privileges granted on the role object itself

List Future Grants To Role

List future grants defined for a role

Grant Future Privileges To Role

Grant privileges on future objects to a role

Revoke Future Grants From Role

Revoke future-object privileges from a role

Set Tags On Role

Assign tag values to a role

Unset Tags From Role

Remove tag assignments from a role

Get Role Tags

Get the tag assignments for a role

List Stages

Get all stages in a schema

Fetch Stage Details

Retrieve stage configuration and storage integration details

Create Stage

Create internal or external stage for data loading and unloading

Update Stage

Modify stage properties like file format or credentials

Delete Stage

Drop a stage object

List Pipes

Get all pipes in a schema

Fetch Pipe Details

Retrieve pipe configuration and status

Create Pipe

Set up Snowpipe for continuous data ingestion

Update Pipe

Modify pipe properties or COPY statement

Delete Pipe

Drop a Snowpipe object

List Streams

Get all streams in a schema

Fetch Stream Details

Retrieve stream metadata and current offset

Create Stream

Create change data capture stream on table or view

Delete Stream

Drop a stream object

List Tasks

Get all tasks in a schema

Fetch Task Details

Retrieve task definition, schedule, and status

Create Task

Define scheduled or DAG-based task for automation

Update Task

Modify task schedule, definition, or warehouse

Delete Task

Drop a task object

Resume Task

Enable a suspended task to run on schedule

Suspend Task

Pause a running task to stop scheduled execution

Execute Task

Manually trigger a task to run immediately

List Functions

Get all user-defined functions in a schema

Fetch Function Details

Retrieve function signature and implementation

Delete Function

Drop a user-defined function

Create Function

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

List Procedures

Get all stored procedures in a schema

Fetch Procedure Details

Retrieve procedure definition and metadata

Create Procedure

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

Delete Procedure

Drop a stored procedure

Call Stored Procedure

Execute a stored procedure with parameters