- 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
- Modify view definition or properties
- 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
- Modify warehouse size, auto-suspend, or other 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
- 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
- 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
No matching actions