Snowflake - NoClick

The Snowflake node adds Snowflake operations to your workflows. Add it on the canvas or ask the AI builder for it by name, then pick an operation and fill in its fields. Snowflake also includes 1 trigger operation (marked in the tables below) that can start a workflow when something happens in Snowflake.

You can wire the Snowflake node into an AI agent as a tool provider: the agent calls the operations you allow. See Agent tools.

Credentials

Connect Snowflake under Credentials in the node settings. See Connecting credentials for the general flow. Enter the values manually when creating the credential. Get your credentials here.

Operations

Account

Operation	ID	Description
Create Account	`create_account`	Create an account in the organization.
Delete Account	`delete_account`	Delete an account.
List Accounts	`list_accounts`	List the accessible accounts in the organization.
Undrop Account	`undrop_account`	Restore a dropped account that is still within its grace period.

Alerts

Operation	ID	Description
Clone Alert	`clone_alert`	Clone an alert into a (possibly different) schema.
Create Alert	`create_alert`	Create an alert in a schema.
Delete Alert	`delete_alert`	Drop an alert.
Execute Alert	`execute_alert`	Execute an alert immediately.
Fetch Alert	`fetch_alert`	Fetch a single alert’s definition.
Get Alert Tags	`get_alert_tags`	Get the tag assignments for an alert (requires an active warehouse).
List Alerts	`list_alerts`	List alerts in a schema.
Set Alert Tags	`set_alert_tags`	Set a tag on an alert.
Unset Alert Tags	`unset_alert_tags`	Unset a tag from an alert.

API integrations

Operation	ID	Description
Create API Integration	`create_api_integration`	Create an API integration.
Create or Alter API Integration	`create_or_alter_api_integration`	Create an API integration, or alter it to match if it already exists.
Delete API Integration	`delete_api_integration`	Drop an API integration.
Fetch API Integration	`fetch_api_integration`	Fetch a single API integration’s definition.
Get Tags on API Integration	`get_tags_api_integration`	Get the tag assignments for an API integration.
List API Integrations	`list_api_integrations`	List API integrations in the account.
Set Tags on API Integration	`set_tags_api_integration`	Set a tag on an API integration.
Unset Tags from API Integration	`unset_tags_api_integration`	Unset a tag from an API integration.

Artifact repositories

Operation	ID	Description
Create Artifact Repository	`create_artifact_repository`	Create an artifact repository in a schema.
Create or Alter Artifact Repository	`create_or_alter_artifact_repository`	Create an artifact repository, or alter it to match if it already exists.
Delete Artifact Repository	`delete_artifact_repository`	Drop an artifact repository.
Fetch Artifact Repository	`fetch_artifact_repository`	Fetch a single artifact repository’s definition.
List Artifact Repositories	`list_artifact_repositories`	List artifact repositories in a schema.
Rename Artifact Repository	`rename_artifact_repository`	Rename an artifact repository to a new identifier.

Catalog integrations

Operation	ID	Description
Create Catalog Integration	`create_catalog_integration`	Create a catalog integration.
Delete Catalog Integration	`delete_catalog_integration`	Drop a catalog integration.
Fetch Catalog Integration	`fetch_catalog_integration`	Fetch a single catalog integration’s definition.
Get Catalog Integration Tags	`get_catalog_integration_tags`	Get the tag assignments for a catalog integration (requires an active warehouse).
List Catalog Integrations	`list_catalog_integrations`	List catalog integrations in the account.
Set Catalog Integration Tags	`set_catalog_integration_tags`	Set a tag on a catalog integration.
Unset Catalog Integration Tags	`unset_catalog_integration_tags`	Unset a tag from a catalog integration.

Compute pools

Operation	ID	Description
Create Compute Pool	`create_compute_pool`	Create a compute pool.
Create or Alter Compute Pool	`create_or_alter_compute_pool`	Create a compute pool, or alter it to match if it already exists.
Delete Compute Pool	`delete_compute_pool`	Drop a compute pool.
Fetch Compute Pool	`fetch_compute_pool`	Fetch a single compute pool’s definition.
Get Compute Pool Tags	`get_tags_compute_pool`	Get the tag assignments for a compute pool.
List Compute Pools	`list_compute_pools`	List compute pools under the account.
List Instance Families	`list_compute_pool_instance_families`	List available compute pool instance families.
Resume Compute Pool	`resume_compute_pool`	Resume a suspended compute pool.
Set Tags on Compute Pool	`set_tags_compute_pool`	Set a tag on a compute pool.
Stop All Services	`stop_all_services_in_compute_pool`	Stop all services on a compute pool.
Stop All Services (Deprecated)	`stop_all_services_in_compute_pool_deprecated`	Stop all services on a compute pool (deprecated endpoint).
Suspend Compute Pool	`suspend_compute_pool`	Suspend an active compute pool.
Unset Tags from Compute Pool	`unset_tags_compute_pool`	Unset a tag from a compute pool.

Database roles

Operation	ID	Description
Clone Database Role	`clone_database_role`	Clone a database role into a (possibly different) database.
Create Database Role	`create_database_role`	Create a database role in a database.
Delete Database Role	`delete_database_role`	Drop a database role.
Get Tags on Database Role	`get_tags_database_role`	Get the tag assignments for a database role (requires an active warehouse).
Grant Future Privileges	`grant_future_privileges_database_role`	Grant future privileges to a database role.
Grant Privileges	`grant_privileges_database_role`	Grant privileges to a database role.
List Database Roles	`list_database_roles`	List database roles in a database.
List Future Grants	`list_future_grants_database_role`	List all future grants to a database role.
List Grants	`list_grants_database_role`	List all grants to a database role.
Revoke Future Grants	`revoke_future_grants_database_role`	Revoke future grants from a database role.
Revoke Grants	`revoke_grants_database_role`	Revoke grants from a database role.
Set Tags on Database Role	`set_tags_database_role`	Set a tag on a database role.
Unset Tags on Database Role	`unset_tags_database_role`	Unset a tag from a database role.

Databases

Operation	ID	Description
Clone Database	`clone_database`	Clone an existing database.
Create Database	`create_database`	Create a new database.
Create Database from Share	`create_database_from_share`	Create a database from a share.
Create Database from Share (Deprecated)	`create_database_from_share_deprecated`	Create a database from a share (deprecated endpoint).
Create or Alter Database	`create_or_alter_database`	Create a new, or alter an existing, database.
Delete Database	`delete_database`	Drop a named database.
Disable Database Failover	`disable_database_failover`	Disable failover for a database.
Disable Database Replication	`disable_database_replication`	Disable replication for a database.
Enable Database Failover	`enable_database_failover`	Enable failover for a database.
Enable Database Replication	`enable_database_replication`	Enable replication for a database.
Fetch Database	`fetch_database`	Describe a single database.
Get Database Tags	`get_tags`	Get the tag assignments for a database.
List Databases	`list_databases`	List accessible databases.
Refresh Database Replication	`refresh_database_replication`	Refresh a secondary database from its primary.
Set Database Tags	`set_tags`	Set a tag on a database.
Set Primary Database (Failover)	`primary_database_failover`	Promote a secondary database to primary.
Undrop Database	`undrop_database`	Undrop a database.
Unset Database Tags	`unset_tags`	Unset tags from a database.

Dynamic tables

Operation	ID	Description
Clone Dynamic Table	`clone_dynamic_table`	Clone a dynamic table into a (possibly different) schema.
Create Dynamic Table	`create_dynamic_table`	Create a dynamic table in a schema.
Delete Dynamic Table	`delete_dynamic_table`	Drop a dynamic table.
Fetch Dynamic Table	`fetch_dynamic_table`	Fetch a single dynamic table’s definition.
Get Tags on Dynamic Table	`get_tags_dynamic_table`	Get the tag assignments for a dynamic table.
List Dynamic Tables	`list_dynamic_tables`	List dynamic tables under a database and schema.
Refresh Dynamic Table	`refresh_dynamic_table`	Manually refresh a dynamic table.
Resume Dynamic Table	`resume_dynamic_table`	Resume refreshes on a dynamic table.
Resume Recluster Dynamic Table	`resume_recluster_dynamic_table`	Resume recluster of a dynamic table.
Set Tags on Dynamic Table	`set_tags_dynamic_table`	Set a tag on a dynamic table.
Suspend Dynamic Table	`suspend_dynamic_table`	Suspend refreshes on a dynamic table.
Suspend Recluster Dynamic Table	`suspend_recluster_dynamic_table`	Suspend recluster of a dynamic table.
Swap With Dynamic Table	`swap_with_dynamic_table`	Swap a dynamic table with another dynamic table.
Undrop Dynamic Table	`undrop_dynamic_table`	Undrop a previously dropped dynamic table.
Unset Tags on Dynamic Table	`unset_tags_dynamic_table`	Unset a tag from a dynamic table.

Event tables

Operation	ID	Description
Create Event Table	`create_event_table`	Create an event table in a schema.
Delete Event Table	`delete_event_table`	Drop an event table.
Fetch Event Table	`fetch_event_table`	Fetch a single event table’s definition.
Get Event Table Tags	`get_tags_event_table`	Get the tag assignments for an event table (requires an active warehouse).
List Event Tables	`list_event_tables`	List event tables in a schema.
Rename Event Table	`rename_event_table`	Rename an event table to a new identifier.
Set Event Table Tags	`set_tags_event_table`	Set a tag on an event table.
Unset Event Table Tags	`unset_tags_event_table`	Unset a tag from an event table.

External volumes

Operation	ID	Description
Create External Volume	`create_external_volume`	Create an external volume.
Delete External Volume	`delete_external_volume`	Drop an external volume.
Fetch External Volume	`fetch_external_volume`	Fetch a single external volume’s definition.
List External Volumes	`list_external_volumes`	List external volumes in the account.
Undrop External Volume	`undrop_external_volume`	Restore the most recently dropped external volume with a given name.

Functions

Operation	ID	Description
Create Function	`create_function`	Create a function in a schema.
Delete Function	`delete_function`	Drop a function.
Execute Function	`execute_function`	Execute a function.
Fetch Function	`fetch_function`	Fetch a single function’s definition.
Get Function Tags	`get_function_tags`	Get the tag assignments for a function.
List Functions	`list_functions`	List user functions in a schema.
Set Function Tags	`set_function_tags`	Set tags on a function.
Unset Function Tags	`unset_function_tags`	Unset tags from a function.

Grants

Operation	ID	Description
Grant Group Privilege	`grant_group_privilege`	Grant privilege(s) on all/future securables of a type in a scope to the named grantee.
Grant Privilege	`grant_privilege`	Grant the specified privilege(s) on the named securable to the named grantee.
List Grants To	`list_grants_to`	List the roles and privileges granted to the specified grantee.
Revoke Group Privilege	`revoke_group_privilege`	Revoke a privilege on all/future securables in the given scope from the named grantee.
Revoke Group Privilege Grant Option	`revoke_group_privilege_grant_option`	Revoke the grant option for a privilege on all/future securables in the given scope.
Revoke Privilege	`revoke_privilege`	Revoke the specified privilege on the named securable from the named grantee.
Revoke Privilege Grant Option	`revoke_privilege_grant_option`	Revoke the grant option for the specified privilege on the named securable.

Iceberg tables

Operation	ID	Description
Clone Iceberg Table	`clone_snowflake_managed_iceberg_table`	Clone a Snowflake-managed iceberg table.
Convert to Managed Iceberg Table	`convert_to_managed_iceberg_table`	Convert an unmanaged iceberg table to a Snowflake-managed one.
Create Iceberg Table	`create_snowflake_managed_iceberg_table`	Create a Snowflake-managed iceberg table.
Create Iceberg Table as Select	`create_snowflake_managed_iceberg_table_as_select`	Create a Snowflake-managed iceberg table from a SELECT query.
Create Iceberg Table from AWS Glue	`create_unmanaged_iceberg_table_from_aws_glue_catalog`	Create an unmanaged iceberg table from an AWS Glue catalog.
Create Iceberg Table from Delta	`create_unmanaged_iceberg_table_from_delta`	Create an unmanaged iceberg table from Delta files.
Create Iceberg Table from Iceberg Files	`create_unmanaged_iceberg_table_from_iceberg_files`	Create an unmanaged iceberg table from Iceberg files.
Create Iceberg Table from Iceberg REST	`create_unmanaged_iceberg_table_from_iceberg_rest`	Create an unmanaged iceberg table from an Iceberg REST catalog.
Create Iceberg Table Like	`create_snowflake_managed_iceberg_table_like`	Create a new iceberg table with the same column definitions as an existing one.
Drop Iceberg Table	`drop_iceberg_table`	Drop an iceberg table.
Fetch Iceberg Table	`fetch_iceberg_table`	Describe a single iceberg table.
Get Iceberg Table Tags	`get_tags_iceberg_table`	Get the tag assignments for an iceberg table.
List Iceberg Tables	`list_iceberg_tables`	List iceberg tables in a schema.
Refresh Iceberg Table	`refresh_iceberg_table`	Refresh metadata for an externally-cataloged iceberg table.
Resume Recluster Iceberg Table	`resume_recluster_iceberg_table`	Resume reclustering of an iceberg table.
Set Iceberg Table Tags	`set_tags_iceberg_table`	Set a tag on an iceberg table.
Suspend Recluster Iceberg Table	`suspend_recluster_iceberg_table`	Suspend reclustering of an iceberg table.
Undrop Iceberg Table	`undrop_iceberg_table`	Undrop a previously dropped iceberg table.
Unset Iceberg Table Tags	`unset_tags_iceberg_table`	Unset a tag from an iceberg table.

Image repositories

Operation	ID	Description
Create Image Repository	`create_image_repository`	Create an image repository in a schema.
Delete Image Repository	`delete_image_repository`	Drop an image repository.
Fetch Image Repository	`fetch_image_repository`	Fetch a single image repository’s definition.
Get Tags on Image Repository	`get_tags_image_repository`	Get the tag assignments for an image repository.
List Image Repositories	`list_image_repositories`	List image repositories in a schema.
List Images in Repository	`list_images_in_repository`	List the images stored in an image repository.
Set Tags on Image Repository	`set_tags_image_repository`	Set a tag on an image repository.
Unset Tags from Image Repository	`unset_tags_image_repository`	Unset a tag from an image repository.

Managed accounts

Operation	ID	Description
Create Managed Account	`create_managed_account`	Create a managed account (reader account).
Delete Managed Account	`delete_managed_account`	Delete a managed account, including all objects created in it.
List Managed Accounts	`list_managed_accounts`	List the accessible managed accounts.

Network policies

Operation	ID	Description
Create Network Policy	`create_network_policy`	Create a network policy.
Delete Network Policy	`delete_network_policy`	Drop a network policy.
Fetch Network Policy	`fetch_network_policy`	Fetch a single network policy’s definition.
Get Tags on Network Policy	`get_tags_network_policy`	Get the tag assignments for a network policy.
List Network Policies	`list_network_policies`	List network policies in the account.
Set Tags on Network Policy	`set_tags_network_policy`	Set a tag on a network policy.
Unset Tags from Network Policy	`unset_tags_network_policy`	Unset a tag from a network policy.

Network rules

Operation	ID	Description
Create Network Rule	`create_network_rule`	Create a network rule in a schema.
Delete Network Rule	`delete_network_rule`	Drop a network rule.
Fetch Network Rule	`fetch_network_rule`	Fetch a single network rule’s definition.
List Network Rules	`list_network_rules`	List network rules in a schema.

Notebooks

Operation	ID	Description
Add Live Version to Notebook	`add_live_version_notebook`	Add a LIVE version to a notebook.
Commit Notebook	`commit_notebook`	Commit the LIVE version of a notebook to its Git repository.
Create Notebook	`create_notebook`	Create a notebook in a schema.
Delete Notebook	`delete_notebook`	Drop a notebook.
Execute Notebook	`execute_notebook`	Execute a notebook.
Fetch Notebook	`fetch_notebook`	Fetch a single notebook’s definition.
Get Notebook Tags	`get_notebook_tags`	Get the tag assignments for a notebook (requires an active warehouse).
List Notebooks	`list_notebooks`	List notebooks in a schema.
Rename Notebook	`rename_notebook`	Rename a notebook to a new identifier.
Set Notebook Tags	`set_notebook_tags`	Set a tag on a notebook.
Unset Notebook Tags	`unset_notebook_tags`	Unset a tag from a notebook.

Notification integrations

Operation	ID	Description
Create Notification Integration	`create_notification_integration`	Create a notification integration.
Delete Notification Integration	`delete_notification_integration`	Drop a notification integration.
Fetch Notification Integration	`fetch_notification_integration`	Fetch a single notification integration’s definition.
Get Tags on Notification Integration	`get_tags_notification_integration`	Get the tag assignments for a notification integration.
List Notification Integrations	`list_notification_integrations`	List notification integrations in the account.
Set Tags on Notification Integration	`set_tags_notification_integration`	Set a tag on a notification integration.
Unset Tags from Notification Integration	`unset_tags_notification_integration`	Unset a tag from a notification integration.

Password policies

Operation	ID	Description
Create Password Policy	`create_password_policy`	Create a password policy in a schema.
Delete Password Policy	`delete_password_policy`	Drop a password policy.
Fetch Password Policy	`fetch_password_policy`	Fetch a single password policy’s definition.
Get Password Policy Tags	`get_password_policy_tags`	Get the tag assignments for a password policy.
List Password Policies	`list_password_policies`	List password policies in a schema.
Rename Password Policy	`rename_password_policy`	Rename a password policy to a new identifier.
Set Password Policy Tags	`set_password_policy_tags`	Set a tag on a password policy.
Unset Password Policy Tags	`unset_password_policy_tags`	Unset a tag from a password policy.

Pipes

Operation	ID	Description
Create Pipe	`create_pipe`	Create a pipe in a schema.
Delete Pipe	`delete_pipe`	Drop a pipe.
Fetch Pipe	`fetch_pipe`	Fetch a single pipe’s definition.
Get Pipe Tags	`get_tags_pipe`	Get the tag assignments for a pipe (requires an active warehouse).
List Pipes	`list_pipes`	List pipes in a schema.
Refresh Pipe	`refresh_pipe`	Refresh a pipe to load staged files into the ingest queue.
Set Pipe Tags	`set_tags_pipe`	Set a tag on a pipe.
Unset Pipe Tags	`unset_tags_pipe`	Unset a tag from a pipe.

Procedures

Operation	ID	Description
Call Procedure	`call_procedure`	Call a procedure with arguments.
Create Procedure	`create_procedure`	Create a procedure in a schema.
Delete Procedure	`delete_procedure`	Drop a procedure.
Fetch Procedure	`fetch_procedure`	Fetch a single procedure’s definition.
Get Procedure Tags	`get_procedure_tags`	Get the tag assignments for a procedure.
List Procedures	`list_procedures`	List procedures in a schema.
Set Procedure Tags	`set_procedure_tags`	Set tags on a procedure.
Unset Procedure Tags	`unset_procedure_tags`	Unset tags from a procedure.

Roles

Operation	ID	Description
Create Role	`create_role`	Create a role.
Delete Role	`delete_role`	Delete a role.
Get Tags On Role	`get_tags_role`	Get the tag assignments for a role (requires an active warehouse).
Grant Future Privileges To Role	`grant_future_privileges`	Grant future privileges to the role.
Grant Privileges To Role	`grant_privileges`	Grant privileges to the role.
List Future Grants To Role	`list_future_grants`	List all future grants to the role.
List Grants Of Role	`list_grants_of`	List all grants of the role (users/roles it is granted to).
List Grants On Role	`list_grants_on`	List all grants on the role (privileges held on the role securable).
List Grants To Role	`list_grants`	List all grants (privileges/roles) granted to the role.
Revoke Future Grants From Role	`revoke_future_grants`	Revoke future grants from the role.
Revoke Grants From Role	`revoke_grants`	Revoke grants from the role.
Set Tags On Role	`set_tags_role`	Set tags on a role.
Unset Tags From Role	`unset_tags_role`	Unset tags from a role.

Schemas

Operation	ID	Description
Clone Schema	`clone_schema`	Clone an existing schema into a (possibly different) database.
Create or Alter Schema	`create_or_alter_schema`	Create a new, or alter an existing, schema.
Create Schema	`create_schema`	Create a schema in a database.
Delete Schema	`delete_schema`	Drop a schema.
Fetch Schema	`fetch_schema`	Fetch a single schema’s definition.
Get Schema Tags	`get_schema_tags`	Get the tag assignments for a schema.
Set Schema Tags	`set_schema_tags`	Set a tag on a schema.
Undrop Schema	`undrop_schema`	Restore a dropped schema.
Unset Schema Tags	`unset_schema_tags`	Unset tags from a schema.

Schemas & tables

Operation	ID	Description
Fetch Table	`fetch_table`	Describe a single table’s metadata / columns.
List Schemas	`list_schemas`	List schemas within a database.
List Tables	`list_tables`	List tables in a schema.

Secrets

Operation	ID	Description
Create Secret	`create_secret`	Create a secret in a schema.
Delete Secret	`delete_secret`	Drop a secret.
Fetch Secret	`fetch_secret`	Fetch a single secret’s definition.
List Secrets	`list_secrets`	List secrets in a schema.

Sequences

Operation	ID	Description
Clone Sequence	`clone_sequence`	Clone a sequence into a (possibly different) schema.
Create Sequence	`create_sequence`	Create a sequence in a schema.
Delete Sequence	`delete_sequence`	Drop a sequence.
Fetch Sequence	`fetch_sequence`	Fetch a single sequence’s definition.
List Sequences	`list_sequences`	List sequences in a schema.
Rename Sequence	`rename_sequence`	Rename a sequence to a new identifier.

Services

Operation	ID	Description
Create or Alter Service	`create_or_alter_service`	Create a service, or alter it to match if it already exists.
Create Service	`create_service`	Create a service in a schema.
Delete Service	`delete_service`	Drop a service.
Execute Job Service	`execute_job_service`	Create and execute a job service.
Fetch Service	`fetch_service`	Fetch a single service’s definition.
Fetch Service Logs	`fetch_service_logs`	Fetch the logs for a service container instance.
Fetch Service Status	`fetch_service_status`	Fetch the status for a service (deprecated, prefer List Service Containers).
List Service Containers	`list_service_containers`	List all containers of a service.
List Service Instances	`list_service_instances`	List all instances of a service.
List Service Role Grants Of	`list_service_role_grants_of`	List all grants of a service role (who the role is granted to).
List Service Role Grants To	`list_service_role_grants_to`	List all grants given to a service role (privileges the role holds).
List Service Roles	`list_service_roles`	List all service roles of a service.
List Services	`list_services`	List services in a schema.
Resume Service	`resume_service`	Resume a suspended service.
Show Service Endpoints	`show_service_endpoints`	List the endpoints exposed by a service.
Suspend Service	`suspend_service`	Suspend a running service.

SQL

Operation	ID	Description
Cancel Statement	`cancel_statement`	Abort an in-flight async statement.
Get Statement Status / Results	`get_statement`	Check status / fetch result rows for a previously submitted statement.
Run SQL Statement	`run_statement`	Execute a SQL statement (query / DML / DDL) via the SQL API.

Stages

Operation	ID	Description
Create Stage	`create_stage`	Create a stage in a schema.
Delete Stage	`delete_stage`	Drop a stage.
Fetch Stage	`fetch_stage`	Fetch a single stage’s definition.
Get Presigned URL	`get_presigned_url`	Generate a presigned url (and optional encryption materials) for a stage file.
List Files	`list_files`	List files in a stage (equivalent to LIST @stage).
List Stages	`list_stages`	List named stages (for file / data loading).

Streamlit apps

Operation	ID	Description
Abort Live Version	`abort_streamlit`	Abort the live version of a Streamlit, discarding uncommitted changes.
Add Live Version	`add_live_version_streamlit`	Add a live version to a Streamlit, making a version active for users.
Add Version From Git	`add_version_from_git_streamlit`	Add a new version to a Streamlit using a Git tag or commit reference URI.
Add Version From Source	`add_version_streamlit`	Add a new version to a Streamlit by copying files from a stage location.
Commit Live Version	`commit_streamlit`	Commit the LIVE version of a Streamlit to its connected Git repository.
Create Streamlit	`create_streamlit`	Create a Streamlit application, or replace an existing one.
Delete Streamlit	`delete_streamlit`	Delete a Streamlit (restorable via undrop within the retention period).
Fetch Streamlit	`fetch_streamlit`	Fetch a single Streamlit’s details.
Get Tags on Streamlit	`get_tags_streamlit`	Get the tag assignments for a Streamlit.
List Streamlits	`list_streamlits`	List Streamlits in a schema.
Pull From Git	`pull_streamlit`	Pull the latest changes from the Git repository for a Streamlit.
Push To Git	`push_streamlit`	Push committed changes from a Streamlit back to its Git repository.
Rename Streamlit	`rename_streamlit`	Rename a Streamlit, optionally into a different database or schema.
Set Tags on Streamlit	`set_tags_streamlit`	Set a tag on a Streamlit.
Undrop Streamlit	`undrop_streamlit`	Restore a previously deleted Streamlit within the retention period.
Unset Tags from Streamlit	`unset_tags_streamlit`	Unset a tag from a Streamlit.

Streams

Operation	ID	Description
Clone Stream	`clone_stream`	Clone a stream into a (possibly different) schema.
Create Stream	`create_stream`	Create a stream on a table, external table, view, or stage.
Delete Stream	`delete_stream`	Drop a stream.
Fetch Stream	`fetch_stream`	Fetch a single stream’s definition.
Get Stream Tags	`get_tags_stream`	Get the tag assignments for a stream (requires an active warehouse).
List Streams	`list_streams`	List streams in a schema.
Set Stream Tags	`set_tags_stream`	Set a tag on a stream.
Unset Stream Tags	`unset_tags_stream`	Unset a tag from a stream.

Tables

Operation	ID	Description
Clone Table	`clone_table`	Clone a table into a (possibly different) schema.
Create or Alter Table	`create_or_alter_table`	Create a table, or alter it to match if it already exists.
Create Table	`create_table`	Create a table in a schema.
Create Table As Select	`create_table_as_select`	Create a table from the result of a SELECT query.
Create Table As Select (Deprecated)	`create_table_as_select_deprecated`	(Deprecated) Create a table from a SELECT query (name in the path).
Create Table Like	`create_table_like`	Create a new empty table like an existing one.
Create Table Like (Deprecated)	`create_table_like_deprecated`	(Deprecated) Create a new empty table like an existing one.
Create Table Using Template	`create_table_using_template`	Create a table using templates in staged files (INFER_SCHEMA).
Create Table Using Template (Deprecated)	`create_table_using_template_deprecated`	(Deprecated) Create a table using templates in staged files (name in the path).
Delete Table	`delete_table`	Drop a table.
Get Table Tags	`get_table_tags`	Get the tag assignments for a table (requires an active warehouse).
Resume Recluster Table	`resume_recluster_table`	Resume automatic reclustering for a table.
Resume Recluster Table (Deprecated)	`resume_recluster_table_deprecated`	(Deprecated) Resume automatic reclustering for a table.
Set Table Tags	`set_table_tags`	Set a tag on a table.
Suspend Recluster Table	`suspend_recluster_table`	Suspend automatic reclustering for a table.
Suspend Recluster Table (Deprecated)	`suspend_recluster_table_deprecated`	(Deprecated) Suspend automatic reclustering for a table.
Swap With Table	`swap_with_table`	Swap a table’s metadata and data with another table.
Swap With Table (Deprecated)	`swap_with_table_deprecated`	(Deprecated) Swap a table with another table (fully-qualified target).
Undrop Table	`undrop_table`	Undrop a previously dropped table.
Unset Table Tags	`unset_table_tags`	Unset a tag from a table.

Operation	ID	Description
Create or Alter Tag	`create_or_alter_tag`	Create a tag, or alter it to match if it already exists.
Create Tag	`create_tag`	Create a tag in a schema.
Delete Tag	`delete_tag`	Drop a tag.
Fetch Tag	`fetch_tag`	Fetch a single tag’s definition.
List Tags	`list_tags`	List tags in a schema.
Rename Tag	`rename_tag`	Rename a tag to a new identifier.
Undrop Tag	`undrop_tag`	Restore the most recently dropped tag of this name.

Tasks

Operation	ID	Description
Create or Alter Task	`create_or_alter_task`	Create a task, or alter it to match if it already exists.
Create Task	`create_task`	Create a scheduled SQL task.
Delete Task	`delete_task`	Drop a task.
Execute Task	`execute_task`	Trigger an immediate manual run of a task.
Fetch Task	`fetch_task`	Fetch a single task’s definition.
Fetch Task Dependents	`fetch_task_dependents`	Fetch the dependent tasks of a task.
Get Complete Graphs	`get_complete_graphs`	Get completed graph runs for the task.
Get Complete Graphs (Deprecated)	`get_complete_graphs_deprecated`	Get completed graph runs for the task (deprecated path).
Get Current Graphs	`get_current_graphs`	Get graph runs executing or scheduled for the task.
Get Current Graphs (Deprecated)	`get_current_graphs_deprecated`	Get graph runs executing or scheduled for the task (deprecated path).
Get Task Tags	`get_tags_task`	Get the tag assignments for a task.
List Task Run History	`task_history`	List completed task graph runs (status / timing).
List Tasks	`list_tasks`	List scheduled tasks in a schema.
Resume Task	`resume_task`	Resume (un-suspend) a task.
Set Task Tags	`set_tags_task`	Set a tag on an existing task.
Suspend Task	`suspend_task`	Pause an active task.
Unset Task Tags	`unset_tags_task`	Unset a tag from an existing task.

Triggers

Operation	ID	Description	Trigger
On Scheduled Query Results	`on_query_results`	Poll a user-supplied SQL query on a schedule and emit only NEW rows.	Yes

User-Defined functions

Operation	ID	Description
Create User-Defined Function	`create_user_defined_function`	Create a user-defined function in a schema.
Delete User-Defined Function	`delete_user_defined_function`	Drop a UDF.
Execute User-Defined Function	`execute_user_defined_function`	Execute a UDF with the given arguments.
Fetch User-Defined Function	`fetch_user_defined_function`	Fetch a single UDF’s definition.
Get User-Defined Function Tags	`get_user_defined_function_tags`	Get the tag assignments for a UDF.
List User-Defined Functions	`list_user_defined_functions`	List user-defined functions in a schema.
Rename User-Defined Function	`rename_user_defined_function`	Rename a UDF to a new identifier.
Set User-Defined Function Tags	`set_user_defined_function_tags`	Set tags on a UDF.
Unset User-Defined Function Tags	`unset_user_defined_function_tags`	Unset tags from a UDF.

Users

Operation	ID	Description
Create or Alter User	`create_or_alter_user`	Create a user, or alter it to match if it already exists (full property set required).
Fetch User	`fetch_user`	Fetch information about a single user (DESCRIBE result).
Get Tags On User	`get_tags_user`	Get the tag assignments for a user (requires an active warehouse).
Grant Role To User	`grant_user`	Grant a role to the user.
List Grants To User	`list_grants_user`	List all grants (roles) granted to the user.
Revoke Grants From User	`revoke_grants_user`	Revoke grants (roles) from the user.
Set Tags On User	`set_tags_user`	Set tags on a user.
Unset Tags From User	`unset_tags_user`	Unset tags from a user.

Users & roles

Operation	ID	Description
Create User	`create_user`	Create a new user account.
Delete User	`delete_user`	Drop a named user.
List Roles	`list_roles`	List account roles.
List Users	`list_users`	List Snowflake account users.

Views

Operation	ID	Description
Create View	`create_view`	Create a view in a schema.
Delete View	`delete_view`	Drop a view.
Fetch View	`fetch_view`	Fetch a single view’s definition.
Get View Tags	`get_view_tags`	Get the tag assignments for a view (requires an active warehouse).
List Views	`list_views`	List views in a schema.
Set View Tags	`set_view_tags`	Set tags on a view.
Unset View Tags	`unset_view_tags`	Unset tags from a view.

Warehouses

Operation	ID	Description
Abort Warehouse Queries	`abort_warehouse`	Abort all running / queued queries on a warehouse.
Create or Alter Warehouse	`create_or_alter_warehouse`	Create a warehouse, or alter it to match if it already exists (full property set required).
Create Warehouse	`create_warehouse`	Create (or replace) a compute warehouse.
Delete Warehouse	`delete_warehouse`	Drop a warehouse.
Disable Warehouse	`disable_warehouse`	Disable an adaptive warehouse.
Enable Warehouse	`enable_warehouse`	Enable an adaptive warehouse.
Fetch Warehouse	`fetch_warehouse`	Describe a single warehouse.
Get Warehouse Tags	`get_warehouse_tags`	Get the tag assignments for a warehouse (requires an active warehouse).
List Warehouses	`list_warehouses`	List available compute warehouses.
Rename Warehouse	`rename_warehouse`	Rename a warehouse to a new identifier.
Resume Warehouse	`resume_warehouse`	Resume a suspended warehouse.
Set Warehouse Tags	`set_warehouse_tags`	Set a tag on a warehouse.
Suspend Warehouse	`suspend_warehouse`	Suspend a warehouse to stop credit usage.
Unset Warehouse Tags	`unset_warehouse_tags`	Unset a tag from a warehouse.
Use Warehouse	`use_warehouse`	[Deprecated] Set the active warehouse for the session.

​Credentials

​Operations

​Account

​Alerts

​API integrations

​Artifact repositories

​Catalog integrations

​Compute pools

​Database roles

​Databases

​Dynamic tables

​Event tables

​External volumes

​Functions

​Grants

​Iceberg tables

​Image repositories

​Managed accounts

​Network policies

​Network rules

​Notebooks

​Notification integrations

​Password policies

​Pipes

​Procedures

​Roles

​Schemas

​Schemas & tables

​Secrets

​Sequences

​Services

​SQL

​Stages

​Streamlit apps

​Streams

​Tables

​Tags

​Tasks

​Triggers

​User-Defined functions

​Users

​Users & roles

​Views

​Warehouses

Credentials

Operations

Account

Alerts

API integrations

Artifact repositories

Catalog integrations

Compute pools

Database roles

Databases

Dynamic tables

Event tables

External volumes

Functions

Grants

Iceberg tables

Image repositories

Managed accounts

Network policies

Network rules

Notebooks

Notification integrations

Password policies

Pipes

Procedures

Roles

Schemas

Schemas & tables

Secrets

Sequences

Services

SQL

Stages

Streamlit apps

Streams

Tables

Tags

Tasks

Triggers

User-Defined functions

Users

Users & roles

Views

Warehouses