> ## Documentation Index
> Fetch the complete documentation index at: https://docs.stackone.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Snowflake

> How to set up the Snowflake connector, plus the actions that are available.

![Snowflake](https://stackone-logos.com/api/snowflake/filled/svg)

v2.0.0[See changelog](https://docs.stackone.com/connectors/snowflake/changelog.md)

[98 actions](#actions) · 3 auth methods

Databases
IAM

## Getting Started

**1. Create or Select a Project**

Set up a new project or select an existing one. See [Organizations & Projects](https://docs.stackone.com/gateway/concepts/organizations-and-projects.md).

**2. Configure the Connector**

Enable the connector and create a Connector Profile in your project. See [Setup Connector Profile](https://docs.stackone.com/gateway/quickstart.md#setup-connector-profile).

> [card] [OAuth 2.0 · Connector Profile](https://docs.stackone.com/connectors/snowflake/guides/connector-profile/oauth-2-0.md)
>
> Requires creating an OAuth security integration in one Snowflake account. The integration and its Account Identifier are...

> [card] [OAuth 2.0 (Your Own App) · Connector Profile](https://docs.stackone.com/connectors/snowflake/guides/connector-profile/oauth-2-0-your-own-app.md)
>
> The OAuth security integration is created in the connecting Snowflake account and its credentials are entered at connect...

> [card] [Key Pair · Connector Profile](https://docs.stackone.com/connectors/snowflake/guides/connector-profile/key-pair.md)
>
> Uses RSA key pair authentication. Requires assigning a public key to a Snowflake user.

**3. Link an Account**

Link an account [from the dashboard](https://docs.stackone.com/connect/managing-connectors/linking-accounts.md#link-from-the-dashboard) (or via [StackOne Hub](https://docs.stackone.com/embed/account-linking/overview)).

See the guide for the authentication type chosen in the Connector Profile:

> [card] [OAuth 2.0 · Link Account](https://docs.stackone.com/connectors/snowflake/guides/link-account/oauth-2-0.md)

> [card] [OAuth 2.0 (Your Own App) · Link Account](https://docs.stackone.com/connectors/snowflake/guides/link-account/oauth-2-0-your-own-app.md)

> [card] [Key Pair · Link Account](https://docs.stackone.com/connectors/snowflake/guides/link-account/key-pair.md)

**4. Use Actions**

Connect an AI platform to the linked account's actions. See [AI Platforms](https://docs.stackone.com/ai-platforms/overview.md).

Other ways to call actions are listed in [Protocols & SDKs](https://docs.stackone.com/connect/protocols-and-sdks.md).

## Actions

Authentication type

Select all
|
Clear

Key Pair

OAuth 2.0

OAuth 2.0 (Your Own App)

No auth methods found

98 actions

ActionDescription

List Databases`snowflake_list_databases`

Retrieve list of all databases in the account

Fetch Database Details`snowflake_fetch_database`

Fetch metadata and properties of a specific database

Create Database`snowflake_create_database`

Create a new database in the Snowflake account

Update Database`snowflake_update_database`

Modify database properties like data retention or ownership

Delete Database`snowflake_delete_database`

Drop a database and all its contained objects

Clone Database`snowflake_clone_database`

Create a copy of an existing database with all its objects

Undrop Database`snowflake_undrop_database`

Restore a previously dropped database within the Time Travel retention period

List Functions`snowflake_list_functions`

Get all user-defined functions in a schema

Fetch Function Details`snowflake_fetch_function`

Retrieve function signature and implementation

Delete Function`snowflake_delete_function`

Drop a user-defined function

Create Function`snowflake_create_function`

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

Get Unified Credentials`snowflake_unified_get_me`

Return the authenticated identity for the current Snowflake connection via the SQL API (SELECT CURRENT\_USER, CURRENT\_ROL...

List Unified Organizations`snowflake_unified_list_organizations`

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

Get Unified Organization`snowflake_unified_get_organization`

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

List Unified Resource Types`snowflake_unified_list_resource_types`

List the resource types this Snowflake connector supports for resource-scoped permission queries. Always returns "role"...

List Unified Resource Users`snowflake_unified_list_resource_users`

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

List Unified Roles`snowflake_unified_list_roles`

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

Get Unified Role`snowflake_unified_get_role`

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

List Unified Users`snowflake_unified_list_users`

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

Get Unified User`snowflake_unified_get_user`

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

List Pipes`snowflake_list_pipes`

Get all pipes in a schema

Fetch Pipe Details`snowflake_fetch_pipe`

Retrieve pipe configuration and status

Create Pipe`snowflake_create_pipe`

Set up Snowpipe for continuous data ingestion

Update Pipe`snowflake_update_pipe`

Modify pipe properties or COPY statement

Delete Pipe`snowflake_delete_pipe`

Drop a Snowpipe object

List Procedures`snowflake_list_procedures`

Get all stored procedures in a schema

Fetch Procedure Details`snowflake_fetch_procedure`

Retrieve procedure definition and metadata

Create Procedure`snowflake_create_procedure`

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

Delete Procedure`snowflake_delete_procedure`

Drop a stored procedure

Call Stored Procedure`snowflake_call_procedure`

Execute a stored procedure with parameters

List Roles`snowflake_list_roles`

Get all roles in the account

Create Role`snowflake_create_role`

Define a new role for access control

Delete Role`snowflake_delete_role`

Drop a custom role

Grant Role To User`snowflake_grant_role_to_user`

Assign a role to a user account

Revoke Role From User`snowflake_revoke_role_from_user`

Remove role assignment from a user

Grant Privileges To Role`snowflake_grant_privileges`

Grant object privileges to a role for access control

List Grants To Role`snowflake_list_grants`

List all privileges granted to a role

Revoke Privileges From Role`snowflake_revoke_grants`

Revoke object privileges from a role

List Grants Of Role`snowflake_list_grants_of`

List the users and roles this role has been granted to

List Grants On Role`snowflake_list_grants_on`

List privileges granted on the role object itself

List Future Grants To Role`snowflake_list_future_grants`

List future grants defined for a role

Grant Future Privileges To Role`snowflake_grant_future_privileges`

Grant privileges on future objects to a role

Revoke Future Grants From Role`snowflake_revoke_future_grants`

Revoke future-object privileges from a role

Set Tags On Role`snowflake_set_role_tags`

Assign tag values to a ROLE (roles only)

Unset Tags From Role`snowflake_unset_role_tags`

Remove tag assignments from a ROLE (roles only)

Get Role Tags`snowflake_get_role_tags`

Get the tag assignments for a ROLE (roles only)

List Schemas`snowflake_list_schemas`

Get all schemas in a specific database

Fetch Schema Details`snowflake_fetch_schema`

Retrieve metadata for a specific schema

Create Schema`snowflake_create_schema`

Create a new schema within a database

Update Schema`snowflake_update_schema`

Modify schema properties like data retention or managed access

Delete Schema`snowflake_delete_schema`

Drop a schema and all its contained objects

Execute Query`snowflake_execute_query`

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

Execute SQL Statement`snowflake_execute_sql_statement`

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

Check Statement Status`snowflake_check_statement_status`

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

Get Statement Results`snowflake_get_statement_results`

Retrieve an additional result partition (page) for a completed async SQL statement

Cancel Statement Execution`snowflake_cancel_statement`

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

List Stages`snowflake_list_stages`

Get all stages in a schema

Fetch Stage Details`snowflake_fetch_stage`

Retrieve stage configuration and storage integration details

Create Stage`snowflake_create_stage`

Create internal or external stage for data loading and unloading

Update Stage`snowflake_update_stage`

Modify stage properties like file format or credentials

Delete Stage`snowflake_delete_stage`

Drop a stage object

List Streams`snowflake_list_streams`

Get all streams in a schema

Fetch Stream Details`snowflake_fetch_stream`

Retrieve stream metadata and current offset

Create Stream`snowflake_create_stream`

Create change data capture stream on table or view

Delete Stream`snowflake_delete_stream`

Drop a stream object

List Tables`snowflake_list_tables`

Retrieve all tables within a schema

Fetch Table Details`snowflake_fetch_table`

Fetch table metadata including columns, constraints, and statistics

Create Table`snowflake_create_table`

Create new permanent, transient, or temporary table

Update Table`snowflake_update_table`

Modify table properties like clustering keys or retention period

Delete Table`snowflake_delete_table`

Drop a table and its data

Create Table As Select`snowflake_create_table_as_select`

Create a new table populated from a SQL SELECT query

Alter Table`snowflake_alter_table`

Create or replace a table with updated structure and properties

Clone Table`snowflake_clone_table`

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

Undrop Table`snowflake_undrop_table`

Restore a previously dropped table within the Time Travel retention period

List Tasks`snowflake_list_tasks`

Get all tasks in a schema

Fetch Task Details`snowflake_fetch_task`

Retrieve task definition, schedule, and status

Create Task`snowflake_create_task`

Define scheduled or DAG-based task for automation

Update Task`snowflake_update_task`

Modify task schedule, definition, or warehouse

Delete Task`snowflake_delete_task`

Drop a task object

Resume Task`snowflake_resume_task`

Enable a suspended task to run on schedule

Suspend Task`snowflake_suspend_task`

Pause a running task to stop scheduled execution

Execute Task`snowflake_execute_task`

Manually trigger a task to run immediately

List Users`snowflake_list_users`

Retrieve all user accounts in the account

Fetch User Details`snowflake_fetch_user`

Fetch user profile information and settings

Create User`snowflake_create_user`

Provision a new user account with authentication settings

Update User`snowflake_update_user`

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

Delete User`snowflake_delete_user`

Remove a user account from the system

List Views`snowflake_list_views`

Get all views in a schema

Fetch View Details`snowflake_fetch_view`

Retrieve view definition and metadata

Create View`snowflake_create_view`

Create standard, secure, or materialized view

Delete View`snowflake_delete_view`

Drop a view

List Warehouses`snowflake_list_warehouses`

Get all warehouses in the account

Fetch Warehouse Details`snowflake_fetch_warehouse`

Retrieve warehouse configuration and current status

Create Warehouse`snowflake_create_warehouse`

Provision a new virtual warehouse with specified size and properties

Delete Warehouse`snowflake_delete_warehouse`

Drop a virtual warehouse

Start Warehouse`snowflake_start_warehouse`

Resume a suspended warehouse to begin processing queries

Suspend Warehouse`snowflake_suspend_warehouse`

Pause a running warehouse to stop consuming credits

Alter Warehouse`snowflake_alter_warehouse`

Create or replace a warehouse with updated configuration (full property set required — omitted properties are reset to d...


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.