Connect OpenClaw to Snowflake

Execute a SQL statement (query / DML / DDL) via the SQL API.

Check status / fetch result rows for a previously submitted statement.

Abort an in-flight async statement.

List accessible databases.

Create a new database.

Describe a single database.

Drop a named database.

List schemas within a database.

List tables in a schema.

Describe a single table's metadata / columns.

List available compute warehouses.

Create (or replace) a compute warehouse.

Resume a suspended warehouse.

Suspend a warehouse to stop credit usage.

Abort all running / queued queries on a warehouse.

List scheduled tasks in a schema.

Create a scheduled SQL task.

Trigger an immediate manual run of a task.

Resume (un-suspend) a task.

Pause an active task.

List completed task graph runs (status / timing).

List Snowflake account users.

Create a new user account.

Drop a named user.

List account roles.

List named stages (for file / data loading).

List the accessible accounts in the organization.

Create an account in the organization.

Delete an account.

Restore a dropped account that is still within its grace period.

List alerts in a schema.

Create an alert in a schema.

Fetch a single alert's definition.

Drop an alert.

Clone an alert into a (possibly different) schema.

Execute an alert immediately.

Set a tag on an alert.

Unset a tag from an alert.

Get the tag assignments for an alert (requires an active warehouse).

List API integrations in the account.

Create an API integration.

Fetch a single API integration's definition.

Create an API integration, or alter it to match if it already exists.

Drop an API integration.

Set a tag on an API integration.

Unset a tag from an API integration.

Get the tag assignments for an API integration.

List artifact repositories in a schema.

Create an artifact repository in a schema.

Fetch a single artifact repository's definition.

Create an artifact repository, or alter it to match if it already exists.

Drop an artifact repository.

Rename an artifact repository to a new identifier.

List catalog integrations in the account.

Create a catalog integration.

Fetch a single catalog integration's definition.

Drop a catalog integration.

Set a tag on a catalog integration.

Unset a tag from a catalog integration.

Get the tag assignments for a catalog integration (requires an active warehouse).

List compute pools under the account.

Create a compute pool.

Fetch a single compute pool's definition.

Create a compute pool, or alter it to match if it already exists.

Drop a compute pool.

Resume a suspended compute pool.

Suspend an active compute pool.

Stop all services on a compute pool (deprecated endpoint).

Stop all services on a compute pool.

List available compute pool instance families.

Set a tag on a compute pool.

Unset a tag from a compute pool.

Get the tag assignments for a compute pool.

Create a database from a share.

Create a database from a share (deprecated endpoint).

Clone an existing database.

Create a new, or alter an existing, database.

Undrop a database.

Enable replication for a database.

Disable replication for a database.

Refresh a secondary database from its primary.

Enable failover for a database.

Disable failover for a database.

Promote a secondary database to primary.

Set a tag on a database.

Unset tags from a database.

Get the tag assignments for a database.

List database roles in a database.

Create a database role in a database.

Drop a database role.

Clone a database role into a (possibly different) database.

List all grants to a database role.

Grant privileges to a database role.

Revoke grants from a database role.

List all future grants to a database role.

Grant future privileges to a database role.

Revoke future grants from a database role.

Set a tag on a database role.

Unset a tag from a database role.

Get the tag assignments for a database role (requires an active warehouse).

List dynamic tables under a database and schema.

Create a dynamic table in a schema.

Fetch a single dynamic table's definition.

Drop a dynamic table.

Clone a dynamic table into a (possibly different) schema.

Undrop a previously dropped dynamic table.

Suspend refreshes on a dynamic table.

Resume refreshes on a dynamic table.

Manually refresh a dynamic table.

Suspend recluster of a dynamic table.

Resume recluster of a dynamic table.

Swap a dynamic table with another dynamic table.

Set a tag on a dynamic table.

Unset a tag from a dynamic table.

Get the tag assignments for a dynamic table.

List event tables in a schema.

Create an event table in a schema.

Fetch a single event table's definition.

Drop an event table.

Rename an event table to a new identifier.

Set a tag on an event table.

Unset a tag from an event table.

Get the tag assignments for an event table (requires an active warehouse).

List external volumes in the account.

Create an external volume.

Fetch a single external volume's definition.

Drop an external volume.

Restore the most recently dropped external volume with a given name.

List user functions in a schema.

Create a function in a schema.

Fetch a single function's definition.

Drop a function.

Execute a function.

Set tags on a function.

Unset tags from a function.

Get the tag assignments for a function.

Grant the specified privilege(s) on the named securable to the named grantee.

Grant privilege(s) on all/future securables of a type in a scope to the named grantee.

Revoke the specified privilege on the named securable from the named grantee.

Revoke the grant option for the specified privilege on the named securable.

Revoke a privilege on all/future securables in the given scope from the named grantee.

Revoke the grant option for a privilege on all/future securables in the given scope.

List the roles and privileges granted to the specified grantee.

List iceberg tables in a schema.

Create a Snowflake-managed iceberg table.

Create a Snowflake-managed iceberg table from a SELECT query.

Create an unmanaged iceberg table from an AWS Glue catalog.

Create an unmanaged iceberg table from Delta files.

Create an unmanaged iceberg table from Iceberg files.

Create an unmanaged iceberg table from an Iceberg REST catalog.

Describe a single iceberg table.

Drop an iceberg table.

Resume reclustering of an iceberg table.

Suspend reclustering of an iceberg table.

Refresh metadata for an externally-cataloged iceberg table.

Convert an unmanaged iceberg table to a Snowflake-managed one.

Undrop a previously dropped iceberg table.

Clone a Snowflake-managed iceberg table.

Create a new iceberg table with the same column definitions as an existing one.

Set a tag on an iceberg table.

Unset a tag from an iceberg table.

Get the tag assignments for an iceberg table.

List image repositories in a schema.

Create an image repository in a schema.

Fetch a single image repository's definition.

Drop an image repository.

List the images stored in an image repository.

Set a tag on an image repository.

Unset a tag from an image repository.

Get the tag assignments for an image repository.

List the accessible managed accounts.

Create a managed account (reader account).

Delete a managed account, including all objects created in it.

List network policies in the account.

Create a network policy.

Fetch a single network policy's definition.

Drop a network policy.

Set a tag on a network policy.

Unset a tag from a network policy.

Get the tag assignments for a network policy.

List network rules in a schema.

Create a network rule in a schema.

Fetch a single network rule's definition.

Drop a network rule.

List notebooks in a schema.

Create a notebook in a schema.

Fetch a single notebook's definition.

Drop a notebook.

Execute a notebook.

Rename a notebook to a new identifier.

Add a LIVE version to a notebook.

Commit the LIVE version of a notebook to its Git repository.

Set a tag on a notebook.

Unset a tag from a notebook.

Get the tag assignments for a notebook (requires an active warehouse).

List notification integrations in the account.

Create a notification integration.

Fetch a single notification integration's definition.

Drop a notification integration.

Set a tag on a notification integration.

Unset a tag from a notification integration.

Get the tag assignments for a notification integration.

List password policies in a schema.

Create a password policy in a schema.

Fetch a single password policy's definition.

Drop a password policy.

Rename a password policy to a new identifier.

Set a tag on a password policy.

Unset a tag from a password policy.

Get the tag assignments for a password policy.

List pipes in a schema.

Create a pipe in a schema.

Fetch a single pipe's definition.

Drop a pipe.

Refresh a pipe to load staged files into the ingest queue.

Set a tag on a pipe.

Unset a tag from a pipe.

Get the tag assignments for a pipe (requires an active warehouse).

List procedures in a schema.

Create a procedure in a schema.

Fetch a single procedure's definition.

Drop a procedure.

Call a procedure with arguments.

Set tags on a procedure.

Unset tags from a procedure.

Get the tag assignments for a procedure.

Create a role.

Delete a role.

List all grants (privileges/roles) granted to the role.

Grant privileges to the role.

Revoke grants from the role.

List all grants of the role (users/roles it is granted to).

List all grants on the role (privileges held on the role securable).

List all future grants to the role.

Grant future privileges to the role.

Revoke future grants from the role.

Set tags on a role.

Unset tags from a role.

Get the tag assignments for a role (requires an active warehouse).

Create a schema in a database.

Clone an existing schema into a (possibly different) database.

Restore a dropped schema.

Fetch a single schema's definition.

Create a new, or alter an existing, schema.

Drop a schema.

Set a tag on a schema.

Unset tags from a schema.

Get the tag assignments for a schema.

List secrets in a schema.

Create a secret in a schema.

Fetch a single secret's definition.

Drop a secret.

List sequences in a schema.

Create a sequence in a schema.

Fetch a single sequence's definition.

Drop a sequence.

Clone a sequence into a (possibly different) schema.

Rename a sequence to a new identifier.

List services in a schema.

Create a service in a schema.

Create and execute a job service.

Fetch a single service's definition.

Create a service, or alter it to match if it already exists.

Drop a service.

Fetch the logs for a service container instance.

Fetch the status for a service (deprecated — prefer List Service Containers).

List all containers of a service.

List all instances of a service.

List all service roles of a service.

List all grants of a service role (who the role is granted to).

List all grants given to a service role (privileges the role holds).

Resume a suspended service.

Suspend a running service.

List the endpoints exposed by a service.

Create a stage in a schema.

Fetch a single stage's definition.

Drop a stage.

List files in a stage (equivalent to LIST @stage).

Generate a presigned url (and optional encryption materials) for a stage file.

List streams in a schema.

Create a stream on a table, external table, view, or stage.

Fetch a single stream's definition.

Drop a stream.

Clone a stream into a (possibly different) schema.

Set a tag on a stream.

Unset a tag from a stream.

Get the tag assignments for a stream (requires an active warehouse).

List Streamlits in a schema.

Create a Streamlit application, or replace an existing one.

Fetch a single Streamlit's details.

Delete a Streamlit (restorable via undrop within the retention period).

Restore a previously deleted Streamlit within the retention period.

Rename a Streamlit, optionally into a different database or schema.

Add a live version to a Streamlit, making a version active for users.

Commit the LIVE version of a Streamlit to its connected Git repository.

Add a new version to a Streamlit by copying files from a stage location.

Add a new version to a Streamlit using a Git tag or commit reference URI.

Abort the live version of a Streamlit, discarding uncommitted changes.

Pull the latest changes from the Git repository for a Streamlit.

Push committed changes from a Streamlit back to its Git repository.

Set a tag on a Streamlit.

Unset a tag from a Streamlit.

Get the tag assignments for a Streamlit.

Create a table in a schema.

Create a table from the result of a SELECT query.

(Deprecated) Create a table from a SELECT query (name in the path).

Create a table using templates in staged files (INFER_SCHEMA).

(Deprecated) Create a table using templates in staged files (name in the path).

Create a table, or alter it to match if it already exists.

Drop a table.

Clone a table into a (possibly different) schema.

Create a new empty table like an existing one.

(Deprecated) Create a new empty table like an existing one.

Undrop a previously dropped table.

Suspend automatic reclustering for a table.

(Deprecated) Suspend automatic reclustering for a table.

Resume automatic reclustering for a table.

(Deprecated) Resume automatic reclustering for a table.

Swap a table's metadata and data with another table.

(Deprecated) Swap a table with another table (fully-qualified target).

Set a tag on a table.

Unset a tag from a table.

Get the tag assignments for a table (requires an active warehouse).

List tags in a schema.

Create a tag in a schema.

Fetch a single tag's definition.

Create a tag, or alter it to match if it already exists.

Drop a tag.

Restore the most recently dropped tag of this name.

Rename a tag to a new identifier.

Fetch a single task's definition.

Create a task, or alter it to match if it already exists.

Drop a task.

Fetch the dependent tasks of a task.

Get graph runs executing or scheduled for the task (deprecated path).

Get graph runs executing or scheduled for the task.

Get completed graph runs for the task (deprecated path).

Get completed graph runs for the task.

Set a tag on an existing task.

Unset a tag from an existing task.

Get the tag assignments for a task.

Fetch information about a single user (DESCRIBE result).

Create a user, or alter it to match if it already exists (full property set required).

List all grants (roles) granted to the user.

Grant a role to the user.

Revoke grants (roles) from the user.

Set tags on a user.

Unset tags from a user.

Get the tag assignments for a user (requires an active warehouse).

List user-defined functions in a schema.

Create a user-defined function in a schema.

Fetch a single UDF's definition.

Drop a UDF.

Execute a UDF with the given arguments.

Rename a UDF to a new identifier.

Set tags on a UDF.

Unset tags from a UDF.

Get the tag assignments for a UDF.

List views in a schema.

Create a view in a schema.

Fetch a single view's definition.

Drop a view.

Set tags on a view.

Unset tags from a view.

Get the tag assignments for a view (requires an active warehouse).

Describe a single warehouse.

Drop a warehouse.

Create a warehouse, or alter it to match if it already exists (full property set required).

Rename a warehouse to a new identifier.

[Deprecated] Set the active warehouse for the session.

Enable an adaptive warehouse.

Disable an adaptive warehouse.

Set a tag on a warehouse.

Unset a tag from a warehouse.

Get the tag assignments for a warehouse (requires an active warehouse).