What you can do with Snowflake
Every task in plain language. Pick one, and we can help you get access.
427 things you can do
Snowflake
Snowflake is a cloud-based data platform delivering data warehousing, data lakes, data engineering, data science and data application development as a single managed service across AWS, Azure and Google Cloud. Its developer surface is a 47-document OpenAPI corpus over /api/v2 covering databases, schemas, tables, Iceberg and dynamic tables, warehouses, tasks, pipes, streams, roles and grants, plus
19 multi-step recipesRecipes: multi-step jobs
Cancel a Running SQL StatementLaunch a SQL statement asynchronously and cancel it by its statement handle.Clone a Database and Verify
Clone a source database into a new database, then fetch the clone to confirm.Create Database, Verify, and Add Schema
Create a database, fetch it to confirm, then create a schema within it.Create Role and Grant Privileges
Create a role, grant privileges to it, then list its grants to verify.Create Schema and Table
Create a schema, create a table within it, then fetch the table to confirm.Create Stage, Verify, and List Files
Create a stage, fetch it to confirm, then list the files in it.Create Table and Insert Rows via SQL
Create a table with a DDL statement, then insert rows with a second statement.Create User and Grant Role
Create a user, grant a role to them, then list their grants to verify.Create a Table and a Change Stream On It
Create a table, create a stream tracking it, then fetch the stream to confirm.Create and Execute an Alert
Create an alert, fetch it to confirm, then execute it on demand.Create and Verify Warehouse
Create a warehouse, then fetch it to verify the created configuration.Create, Resume, and Execute a Task
Create a task, resume it, execute it once, then fetch it to confirm state.Create, Verify, and Refresh a Dynamic Table
Create a dynamic table, fetch it to confirm, then refresh it manually.Create, Verify, and Refresh a Pipe
Create a pipe, fetch it to confirm, then refresh it to queue staged files.Provision Database, Schema, and Table
Create a database, a schema within it, and a table within the schema.Resume Warehouse and Verify State
Resume a warehouse, then fetch it to verify it is no longer suspended.Submit Asynchronous SQL Statement
Submit a SQL statement asynchronously and read back its execution status.Submit SQL Statement and Poll for Results
Submit a SQL statement, poll its execution status, and retrieve the results.Warehouse Create, Verify, and Suspend Lifecycle
Create a warehouse, verify it with a describe, then suspend it.
Artificial Intelligence Management
Generate an LLM text completionGenerate text with the Cortex Messages APIRun a chat completion on CortexList the LLMs available to this sessionGenerate text embeddingsIT Infrastructure Management
Create a virtual warehouseCreate or alter a warehouse with full settingsDrop a warehouseResume a suspended warehouseSuspend a running warehouseRename a warehouseAbort all queries on a warehouseSet the session's current warehouseEnable an adaptive warehouseDisable an adaptive warehouseSet tags on a warehouseRemove tags from a warehouseCreate a compute poolCreate or update a compute pool definitionDelete a compute poolResume a suspended compute poolSuspend an active compute poolStop all services in a pool (legacy endpoint)Stop all services running in a compute poolAttach tags to a compute poolRemove tags from a compute poolList virtual warehousesDescribe a warehouseGet tag assignments for a warehouseList compute pools in the accountGet the details of a compute poolList available compute pool instance familiesShow the tags assigned to a compute poolIdentity & Access Management
Grant privileges on one object to a role or userGrant privileges on all or future objects in a scopeRevoke a privilege on one objectRevoke only the grant option on one objectRevoke a privilege on all or future objectsRevoke the grant option on all or future objectsCreate a roleDrop a roleGrant privileges on an object to a roleRevoke privileges from a roleGrant privileges on future objects to a roleRevoke future grants from a roleSet tags on a roleRemove tags from a roleCreate a database roleDelete a database roleClone a database roleGrant privileges to a database roleRevoke privileges from a database roleGrant future privileges to a database roleRevoke future grants from a database roleSet tags on a database roleRemove tags from a database roleCreate a userCreate or update a userDelete a userGrant a role to a userRevoke a role from a userAttach tags to a userRemove tags from a userList privileges granted to a role or userList account rolesList privileges granted to a roleList who has been granted a roleList grants on a role objectList future grants to a roleGet the tags assigned to a roleList database roles in a databaseList privileges granted to a database roleList future grants on a database roleGet tag assignments for a database roleList users in the accountGet a user's detailsList roles granted to a userShow the tags assigned to a userOther things you can do
Create a scheduled taskCreate or alter a task with a full definitionDrop a taskRun a task immediatelyResume a suspended taskSuspend a running taskSet tags on a taskRemove tags from a taskCreate a viewDelete a viewSet tags on a viewRemove tags from a viewRate a Cortex Analyst responseCreate a stored procedureDrop a stored procedureCall a stored procedureAttach tags to a stored procedureRemove tags from a stored procedureCreate a notebookDelete a notebookRun a notebookRename or move a notebookAdd a LIVE version to a notebookCommit a notebook's LIVE versionSet tags on a notebookRemove tags from a notebookRun a SQL statementCancel a running SQL statementCreate an external volumeDelete an external volumeRestore a dropped external volumeCreate an event tableDrop an event tableRename an event tableAttach tags to an event tableRemove tags from an event tableCreate a tagCreate or update a tag definitionDrop a tagRestore a dropped tagRename or move a tagCreate a user-defined functionDrop a user-defined functionCall a user-defined functionRename or move a user-defined functionSet tags on a user-defined functionRemove tags from a user-defined functionCreate a container serviceRun a one-off job serviceCreate or update a service definitionDelete a serviceResume a suspended serviceSuspend a running serviceCreate a password policyDelete a password policyRename or move a password policySet tags on a password policyRemove tags from a password policyCreate an account in the organizationDrop an accountRestore a dropped accountCreate a Snowpipe pipeDelete a pipeRefresh a pipe to load staged filesSet tags on a pipeRemove tags from a pipeCreate a notification integrationDelete a notification integrationSet tags on a notification integrationRemove tags from a notification integrationCreate an API integrationCreate or update an API integrationDelete an API integrationSet tags on an API integrationRemove tags from an API integrationCreate a sequenceDrop a sequenceClone a sequenceRename or move a sequenceCreate a dynamic tableDrop a dynamic tableClone a dynamic tableRestore a dropped dynamic tablePause refreshes on a dynamic tableResume refreshes on a dynamic tableManually refresh a dynamic tablePause automatic reclustering of a dynamic tableResume automatic reclustering of a dynamic tableSwap a dynamic table with anotherAttach tags to a dynamic tableRemove tags from a dynamic tableCreate a secretDelete a secretCreate an image repositoryDelete an image repositoryAttach tags to an image repositoryRemove tags from an image repositoryCreate a new tableCreate a table from a query (legacy endpoint)Create a table from a SELECT query resultCreate a table from staged file templates (legacy)Create a table from templates in staged filesCreate or alter a table with a full definitionDrop a tableClone a table, optionally at a point in timeCreate an empty copy of a table (legacy)Create an empty table with the same structureRestore a dropped tableSuspend automatic reclustering (legacy)Suspend automatic reclustering on a tableResume automatic reclustering (legacy)Resume automatic reclustering on a tableSwap two tables (legacy endpoint)Swap a table with another tableSet tags on a tableRemove tags from a tableCreate a functionDelete a functionExecute a functionSet tags on a functionRemove tags from a functionCreate or replace a Streamlit appDelete a Streamlit appRestore a deleted Streamlit appRename or move a Streamlit appAdd a live version to a Streamlit appCommit a Streamlit's live version to GitAdd a Streamlit version from a stageAdd a Streamlit version from a Git referenceAbort a Streamlit's live versionPull latest Git changes into a StreamlitPush a Streamlit's commits to GitSet tags on a Streamlit appRemove tags from a Streamlit appExecute a Spark Connect query planGet or update Spark session configurationUpload artifacts to a Spark sessionInterrupt running Spark executionsRelease a reattachable Spark executionPush a Spark response from a sproc processorDelete a Cortex Search serviceCreate a Cortex Search serviceSuspend indexing or serving on a search serviceResume indexing or serving on a search serviceSend feedback on a search resultCreate an artifact repositoryCreate or update an artifact repositoryDelete an artifact repositoryRename or move an artifact repositoryCreate a catalog integrationDelete a catalog integrationSet tags on a catalog integrationRemove tags from a catalog integrationCreate a network policyDelete a network policySet tags on a network policyRemove tags from a network policyCreate a network ruleDelete a network ruleCreate a schemaClone a schemaRestore a dropped schemaCreate or alter a schema with a full definitionDrop a schemaSet tags on a schemaRemove tags from a schemaCreate an alertDelete an alertClone an alert into a schemaRun an alert nowSet tags on an alertRemove tags from an alertCreate a managed reader accountDelete a managed reader accountCreate a new databaseCreate a database from a data shareCreate a database from a share (legacy endpoint)Clone an existing databaseCreate or update a database definitionDrop a databaseRestore a dropped databaseEnable replication of a database to accountsDisable replication of a primary databaseRefresh a secondary database from its primaryAllow accounts to fail over a databaseDisable failover for a primary databasePromote a replica database to primaryAttach tags to a databaseRemove tags from a databaseCreate a Snowflake-managed Iceberg tableCreate a managed Iceberg table from a queryRegister an Iceberg table from AWS GlueCreate an Iceberg table from Delta filesCreate an Iceberg table from metadata filesRegister an Iceberg table from a REST catalogDrop an Iceberg tableResume automatic reclustering on an Iceberg tableSuspend automatic reclustering on an Iceberg tableRefresh an externally catalogued Iceberg tableConvert an external Iceberg table to Snowflake-managedRestore a dropped Iceberg tableClone a managed Iceberg tableCreate an empty Iceberg table like anotherSet tags on an Iceberg tableRemove tags from an Iceberg tableCreate an internal or external stageDelete a stageGet a presigned URL for a staged fileCreate a change-tracking streamDelete a streamClone a stream into a schemaSet tags on a streamRemove tags from a streamList the tasks in a schemaDescribe a single taskList the tasks that depend on a taskGet running or upcoming graph runs (legacy)Get running and upcoming task graph runsGet completed graph runs (legacy)Get completed task graph runsGet the tags assigned to a taskList views in a schemaDescribe a viewGet the tags assigned to a viewAsk Cortex Analyst a data questionSuggest verified queries for a semantic modelGenerate or improve a semantic model quicklyPick relevant tables for semantic model generationSuggest filters, facts and metrics for a modelList agentic optimization runs for a modelCheck an agentic optimization run's statusExchange a Cortex Analyst OAuth tokenList stored procedures in a schemaGet the definition of a stored procedureShow the tags assigned to a stored procedureList notebooks in a schemaDescribe a single notebookGet the tags assigned to a notebookCheck a statement's status and fetch resultsList external volumesGet an external volumeList event tables in a schemaGet the details of an event tableShow the tags assigned to an event tableList tag definitions in a schemaGet the definition of a tagList user-defined functions in a schemaDescribe a user-defined functionGet the tags assigned to a user-defined functionList container services in a schemaGet the details of a serviceRead a service container's logsCheck a service's statusList a service's containersList a service's instancesList a service's service rolesShow who holds a service roleShow privileges granted to a service roleList a service's endpointsList password policies in a schemaDescribe a password policyGet the tags assigned to a password policyCheck an async request's status or fetch its resultList accounts in the organizationList Snowpipe pipes in a schemaGet a pipe's definitionGet tag assignments for a pipeList notification integrationsGet a notification integrationGet tag assignments for a notification integrationList API integrationsGet an API integrationGet tag assignments for an API integrationList sequences in a schemaGet the details of a sequenceList dynamic tables in a schemaGet the details of a dynamic tableShow the tags assigned to a dynamic tableList secrets in a schemaGet the details of a secretList image repositories in a schemaGet the details of an image repositoryList images stored in a repositoryShow the tags assigned to an image repositoryList the tables in a schemaDescribe a single tableGet the tags assigned to a tableList user functions in a schemaDescribe a functionGet tag assignments for a functionList Streamlit apps in a schemaGet details of a Streamlit appGet tag assignments for a Streamlit appAnalyze a Spark query plan for metadataCheck status of session artifactsReattach to a Spark executionPull the next Spark request for a sproc processorGet the details of a Cortex Search serviceList Cortex Search services in a schemaRun a search query against a Cortex Search serviceGet autocomplete suggestions from a search serviceList artifact repositories in a schemaGet an artifact repositoryList catalog integrationsGet a catalog integrationGet tag assignments for a catalog integrationList network policiesDescribe a network policyGet the tags assigned to a network policyList network rules in a schemaDescribe a network ruleList schemas in a databaseDescribe a single schemaGet the tags assigned to a schemaList alerts in a schemaDescribe a single alertGet the tags assigned to an alertList managed reader accountsList the databases I can accessGet the details of a databaseShow the tags assigned to a databaseList Iceberg tables in a schemaShowing 400 of 408. Search above to find the rest.