Snowflake

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 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

Return the authenticated identity for the current Snowflake connection via the SQL API (SELECT CURRENT_USER, CURRENT_ROL…

Return the Snowflake account as a single IAM organization record. Each connection targets exactly one Snowflake account…

Retrieve the Snowflake account as a single IAM organization. Each connection targets exactly one account - pass the id r…

List the resource types this Snowflake connector supports for resource-scoped permission queries. Always returns [“role”…

List the users granted a specific Snowflake role via the REST API, mapped to the StackOne IAM unified user schema with t…

List all roles in the connected Snowflake account via the REST API, mapped to the StackOne IAM unified role schema. Incl…

Retrieve a single Snowflake role by name via the REST API, mapped to the StackOne IAM unified role schema. Role.id is th…

List all users in the connected Snowflake account via the REST API, mapped to the StackOne IAM unified user schema. Retu…

Retrieve a single Snowflake user by username via the REST API, mapped to the StackOne IAM unified user schema. Returns i…

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 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

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 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

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

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 streams in a schema

Retrieve stream metadata and current offset

Create change data capture stream on table or view

Drop a stream object

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 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

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 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 (full property set required — omitted properties are reset to d…