All commands (alphabetical)¶
This topic provides a list of all DDL and DML commands, as well as the SELECT command and other related commands, in alphabetical order.
Command Name |
Summary |
---|---|
A |
|
Modifies the metadata of an account-level or database object, or the parameters for a session. |
|
Modifies an account. |
|
Replaces the existing rules or comment of an aggregation policy. |
|
Modifies the properties of an existing alert and suspends or resumes an existing alert. |
|
Modifies the properties of an existing API integration. |
|
Modifies the properties of an installed |
|
Modifies the properties of an existing application package in the Native Apps Framework. |
|
Modifies the properties of an existing application package in the Native Apps Framework. |
|
Modifies the versioning of an existing application package in the Native Apps Framework. |
|
Modifies the properties for an existing application role. |
|
Modifies the properties of an authentication policy. |
|
Modifies the properties of an existing catalog integration. |
|
Modifies the properties of an existing compute pool. |
|
Modifies the properties for an existing connection. |
|
Modifies the properties of an existing Cortex Search service. |
|
Modifies the properties for an existing database. |
|
Modifies the properties for an existing database role. |
|
Modifies the properties of a dynamic table. |
|
Modifies the properties of an existing external access integration. |
|
Modifies the properties, columns, or constraints for an existing external table. |
|
Modifies the properties for an existing external volume. |
|
Modifies the properties for an existing failover group. |
|
Modifies the properties for an existing file format object. |
|
Modifies the properties of an existing user-defined or external function. |
|
Modifies the properties of an existing data metric function (DMF). |
|
Modifies the properties of an existing service function. |
|
Modifies the properties of an existing Git repository stage. |
|
Modifies properties such as clustering options and tags for an existing Apache Iceberg™ table. |
|
Modifies (evolves) a structured type column in a Snowflake-managed Apache Iceberg™ table. |
|
Converts an Apache Iceberg™ table that uses an external Iceberg catalog into a table that uses Snowflake as the catalog (a Snowflake-managed Iceberg table). |
|
Refreshes the metadata for an Apache Iceberg™ table that uses an external Iceberg catalog. |
|
Modifies the properties for an existing integration. |
|
Replaces the existing masking policy rules with new rules or a new comment and allows the renaming of a masking policy. |
|
Alters a materialized view in the current/specified schema. |
|
Modifies the properties for an existing model, including its name, tags, default version, or comment. |
|
Adds a new version to an existing model from an existing model version. |
|
Removes a version from the specified machine learning model. |
|
Modifies a version of a model, changing the version’s comment or metadata. |
|
Modifies the properties for an existing network policy. |
|
Modifies an existing network rule. |
|
Modifies the properties of an existing notebook. |
|
Modifies the properties for an existing notification integration. |
|
Modifies the properties for an existing notification integration for sending email messages. |
|
ALTER NOTIFICATION INTEGRATION (inbound from an Azure Event Grid topic) |
Modifies the properties for an existing notification integration for receiving messages from an Azure Event Grid topic. |
ALTER NOTIFICATION INTEGRATION (inbound from a Google Pub/Sub topic) |
Modifies the properties for an existing notification integration for receiving messages from a Google Pub/Sub topic. |
ALTER NOTIFICATION INTEGRATION (outbound to an Amazon SNS topic) |
Modifies the properties for an existing notification integration for sending a message to an Amazon SNS topic. |
ALTER NOTIFICATION INTEGRATION (outbound to an Azure Event Grid topic) |
Modifies the properties for an existing notification integration for sending a message to an Azure Event Grid topic. |
ALTER NOTIFICATION INTEGRATION (outbound to a Google Pub/Sub topic) |
Modifies the properties for an existing notification integration for sending a message to a Google Pub/Sub topic. |
Modifies the properties for an existing notification integration for a webhook. |
|
Modifies the properties of an existing organization account. |
|
Modifies the properties for an existing packages policy. |
|
Modifies the properties for an existing password policy. |
|
Modifies a limited set of properties for an existing pipe object. |
|
Modifies the properties of an existing privacy policy. |
|
Modifies the properties for an existing stored procedure. |
|
Replaces the existing projection policy rules with new rules or a new comment and allows the renaming of a projection policy. |
|
Modifies the properties for an existing replication group. |
|
Modifies the properties and triggers for an existing resource monitor. |
|
Modifies the properties for an existing custom role. |
|
Modifies the properties for an existing row access policy, including renaming the policy or replacing the policy rules. |
|
Modifies the properties for an existing schema, including renaming the schema or swapping it with another schema, and changing the Time Travel data retention period (if you are using Snowflake Enterprise Edition or higher). |
|
Modifies the properties of an existing secret. |
|
Modifies the properties for an existing security integration. |
|
Modifies the properties of an existing security integration created for External API Authentication. |
|
Modifies the properties of an existing security integration created for authenticating with AWS IAM. |
|
Modifies the properties of an existing security integration created for External OAuth. |
|
Modifies the properties of an existing security integration created for a Snowflake OAuth client. |
|
Modifies the properties of an existing SAML2 security integration. |
|
Modifies the properties of an existing SCIM security integration. |
|
Modifies the properties for an existing sequence. |
|
Modifies Snowpark Container Services service configuration, upgrades the code for the service, and allows you to suspend or resume a service. |
|
Sets parameters that change the behavior for the current session. |
|
Modifies the properties for an existing session policy. |
|
Modifies the properties for an existing share. |
|
Modifies the properties of an existing snapshot. |
|
Modifies the properties for an existing named internal or external stage. |
|
Modifies the properties for an existing storage integration. |
|
Modifies the properties, columns, or constraints for an existing stream. |
|
Modifies the properties of an existing Streamlit object. |
|
Modifies the properties, columns, or constraints for an existing table. |
|
This topic describes how to modify one or more column properties for a table using an |
|
Modifies the properties, columns, or constraints for an existing event table. |
|
Modifies the properties for an existing tag, including renaming the tag and setting a masking policy on a tag. |
|
Modifies the properties for an existing task. |
|
Modifies the properties and object/session parameters for an existing user in the system. |
|
Modifies the properties for an existing view. |
|
Suspends or resumes a virtual warehouse, or aborts all queries (and other SQL statements) for a warehouse. |
|
B |
|
Begins a transaction in the current session. |
|
C |
|
Calls a stored procedure. |
|
Creates and calls an anonymous procedure that is like a stored procedure but is not stored for later use. |
|
Adds a comment or overwrites an existing comment for an existing object. |
|
Commits an open transaction in the current session. |
|
Copies files from one stage to another. |
|
Unloads data from a table (or query) into one or more files in one of the following locations. |
|
Loads data from staged files to an existing table. |
|
Creates a new object of the specified type. |
|
Creates a new account in your organization. |
|
Creates a new aggregation policy in the current/specified schema or replaces an existing aggregation policy. |
|
Creates a new alert in the current schema. |
|
Creates a new API integration object in the account, or replaces an existing API integration. |
|
Creates a new application object using an application package or listing. |
|
Creates a new application package that contains the data content and application logic of an application using the Native Apps Framework. |
|
Creates a new application role or replaces an existing application role. |
|
Creates a new authentication policy in the current or specified schema or replaces an existing authentication policy. |
|
Creates a new catalog integration for Apache Iceberg™ tables in the account or replaces an existing catalog integration. |
|
Creates a new catalog integration in the account or replaces an existing catalog integration for Apache Iceberg™ tables that use AWS Glue as the catalog. |
|
Creates a new catalog integration in the account or replaces an existing catalog integration for the following sources. |
|
Creates a new catalog integration for Apache Iceberg™ tables that integrate with Polaris Catalog in the account or replaces an existing catalog integration. |
|
Creates a new catalog integration in the account or replaces an existing catalog integration for Apache Iceberg™ tables managed in a remote catalog that complies with the open source Apache Iceberg™ REST OpenAPI specification. |
|
Creates a copy of an existing object in the system. |
|
Creates a new compute pool in the current account. |
|
Creates a new connection in the account. |
|
Creates a new Cortex Search service or replaces an existing one. |
|
Creates a new data metric function (DMF) in the current or specified schema, or replaces an existing data metric function. |
|
Creates a new database in the system. |
|
Create a new database role or replace an existing database role in the system. |
|
Creates a dynamic table, based on a specified query. |
|
Creates an event table that captures events, including logged messages from functions and procedures. |
|
Creates an external access integration for access to external network locations from a UDF or procedure handler. |
|
Creates a new external function. |
|
Creates a new external table in the current/specified schema or replaces an existing external table. |
|
Creates a new external volume for Apache Iceberg™ tables in the account or replaces an existing external volume. |
|
Creates a new failover group of specified objects in the system. |
|
Creates a named file format that describes a set of staged data to access or load into Snowflake tables. |
|
Creates a new UDF (user-defined function). |
|
Creates a service function. |
|
Creates a Git repository stage in the schema or replaces an existing Git repository stage. |
|
Creates a new hybrid table in the current/specified schema or replaces an existing table. |
|
Creates or replaces an Apache Iceberg™ table in the current/specified schema. |
|
Creates or replaces an Apache Iceberg™ table in the current/specified schema using an Iceberg table that is registered in the AWS Glue Data Catalog. |
|
Creates or replaces an Apache Iceberg™ table in the current/specified schema using Delta table files in object storage (external cloud storage). |
|
Creates or replaces an Apache Iceberg™ table in the current/specified schema using Iceberg files in object storage (external cloud storage). |
|
Creates or replaces an Apache Iceberg™ table in the current/specified schema for an Iceberg REST catalog. |
|
Creates or replaces an Apache Iceberg™ table that uses Snowflake as the Iceberg catalog in the current/specified schema. |
|
Creates a new image repository in the current schema. |
|
Creates a new secondary index in an existing hybrid table and populates the index with data. |
|
Creates a new integration in the system or replaces an existing integration. |
|
Creates a new managed account. |
|
Creates a new masking policy in the current/specified schema or replaces an existing masking policy. |
|
Creates a new materialized view in the current/specified schema, based on a query of an existing table, and populates the view with data. |
|
Creates a new machine learning model in the current/specified schema or replaces an existing model. |
|
Creates a network policy or replaces an existing network policy. |
|
Creates a network rule or replaces an existing network rule. |
|
Creates a new Snowflake notebook or replaces an existing notebook. |
|
Creates a new notification integration in the account or replaces an existing integration. |
|
Creates a new notification integration in the account or replaces an existing integration for sending email messages. |
|
CREATE NOTIFICATION INTEGRATION (inbound from an Azure Event Grid topic) |
Creates a new notification integration in the account or replaces an existing integration for receiving messages from an Azure Event Grid topic. |
CREATE NOTIFICATION INTEGRATION (inbound from a Google Pub/Sub topic) |
Creates a new notification integration in the account or replaces an existing integration for receiving messages from a Google Pub/Sub topic. |
CREATE NOTIFICATION INTEGRATION (outbound to an Amazon SNS topic) |
Creates a new notification integration in the account or replaces an existing integration for sending a message to an Amazon SNS topic. |
CREATE NOTIFICATION INTEGRATION (outbound to an Azure Event Grid topic) |
Creates a new notification integration in the account or replaces an existing integration for sending a message to an Azure Event Grid topic. |
CREATE NOTIFICATION INTEGRATION (outbound to a Google Pub/Sub topic) |
Creates a new notification integration in the account or replaces an existing integration for sending a message to a Google Pub/Sub topic. |
Creates a new notification integration or replaces an existing integration for a webhook. |
|
Creates a new organization account. |
|
Creates a new packages policy or replaces an existing packages policy. |
|
Creates a new password policy or replaces an existing password policy. |
|
Creates a new pipe in the system for defining the COPY INTO <table> statement used by Snowpipe to load data from an ingestion queue into tables. |
|
Creates a new privacy policy or replaces an existing privacy policy. |
|
Creates a new stored procedure. |
|
Creates a new projection policy in the current/specified schema or replaces an existing projection policy. |
|
Creates a new replication group of specified objects in the system. |
|
Creates a new resource monitor. |
|
Create a new role or replace an existing role in the system. |
|
Creates a new row access policy in the current/specified schema or replaces an existing row access policy. |
|
Creates a new schema in the current database. |
|
Creates a new secret in the current or specified schema or replaces an existing secret. |
|
Creates a new security integration in the account or replaces an existing integration. |
|
Creates a new security integration for external API Authentication in the account or replaces an existing integration. |
|
Creates a new security integration for external authentication using Amazon Web Services (AWS) Identity and Access Management (IAM). |
|
Creates a new External OAuth security integration in the account or replaces an existing integration. |
|
Creates a new Snowflake OAuth security integration in the account or replaces an existing integration. |
|
Creates a new SAML2 security integration in the account or replaces an existing integration. |
|
Creates a new SCIM security integration in the account or replaces an existing integration. |
|
Creates a new sequence, which can be used for generating sequential, unique numbers. |
|
Creates a new Snowpark Container Services service in the current schema. |
|
Creates a new session policy or replaces an existing session policy. |
|
Creates a new, empty share. |
|
Creates or replaces a snapshot of a named volume from the specified service instance. |
|
Creates a new named internal or external stage to use for loading data from files into Snowflake tables and unloading data from tables into files. |
|
Creates a new storage integration in the account or replaces an existing integration. |
|
Creates a new stream in the current/specified schema or replaces an existing stream. |
|
Creates a new Streamlit application object in Snowflake or replaces an existing Streamlit application object in the same schema. |
|
Creates a new table in the current/specified schema, replaces an existing table, or alters an existing table. |
|
This topic describes how to create constraints by specifying a CONSTRAINT clause in a CREATE TABLE, CREATE HYBRID TABLE, or ALTER TABLE statement. |
|
Creates a new tag or replaces an existing tag in the system. |
|
Creates a new task in the current/specified schema or replaces an existing task. |
|
Creates a new user or replaces an existing user in the system. |
|
Creates a new versioned schema or modifies an existing versioned schema. |
|
Creates a new view in the current/specified schema, based on a query of one or more existing tables (or any other valid query expression). |
|
Creates a new virtual warehouse in the system. |
|
D |
|
Remove rows from a table. |
|
Describes the details for the specified object. |
|
Describes the details about an aggregation policy, including the creation date, name, and the SQL expression. |
|
Describes the properties of an alert. |
|
Displays information about an application object. |
|
Describes the properties of an authentication policy. |
|
Describes the properties of a catalog integration. |
|
Describes the properties of a compute pool. |
|
Describes the properties of a Cortex Search service. |
|
Describes the database. |
|
Describes the columns in a dynamic table. |
|
Describes the columns in an event table. |
|
Describes the VALUE column and virtual columns in an external table. |
|
Describes the properties of an external volume. |
|
Describes the properties and their current values for a file format, as well as the default values for each property. |
|
Describes the specified user-defined function (UDF) or external function, including the signature (i.e. arguments), return value, language, and body (i.e. definition). |
|
Describes the specified data metric function (DMF), including the signature (arguments), return value, language, and body (definition). |
|
Describes the specified service function, including the signature (arguments), return value, language, and body (path to the Snowpark Container Services service). |
|
Describes an existing Git repository stage. |
|
Describes either the columns in an Apache Iceberg™ table or the current values, as well as the default values, for the properties of an Iceberg table. |
|
Describes the properties of an integration. |
|
Describes the details about a masking policy, including the creation date, name, data type, and SQL expression. |
|
Describes the columns in a materialized view. |
|
Describes the properties specified for a network policy. |
|
Describes the properties specified for a network rule. |
|
Describes the properties of a notebook. |
|
Describes the details about a packages policy. |
|
Describes the details about a password policy. |
|
Describes the properties specified for a pipe, as well as the default values of the properties. |
|
Describes the properties of a privacy policy. |
|
Describes the specified stored procedure, including the stored procedure’s signature (i.e. arguments), return value, language, and body (i.e. definition). |
|
Describes the details about a projection policy, including the creation date, name, and the SQL expression. |
|
Describes the columns in the result of a query. |
|
Describes a row access policy, including the creation date, name, data type, and SQL expression. |
|
Describes the schema. |
|
Describes the search optimization configuration for a specified table and its columns. |
|
Describes the properties of a secret. |
|
Describes a sequence, including the sequence’s interval. |
|
Describes the properties of a Snowpark Container Services service (including job services). |
|
Describes the details about a session policy. |
|
Describes the data objects that are included in a share. |
|
Describes the properties of a snapshot. |
|
Describes the values specified for the properties in a stage (file format, copy, and location), as well as the default values for each property. |
|
Describes the columns in a stream. |
|
Describes the columns in a Streamlit object. |
|
Describes either the columns in a table or the set of stage properties for the table (current values and default values). |
|
Describes the columns in a task. |
|
Describes the transaction, including the start time and the state (running, committed, rolled back). |
|
Describes a user, including the current values for the user’s properties, as well as the default values. |
|
Describes the columns in a view (or table). |
|
Describes the warehouse. |
|
Removes the specified object from the system. |
|
Drops an account, which initiates the process of deleting the account. |
|
Removes an aggregation policy from the current/specified schema. |
|
Drops an existing alert. |
|
Removes an application from the system in the Native Apps Framework. |
|
Removes an application package from the system in the Native Apps Framework. |
|
Removes the specified application role from the system. |
|
Removes an authentication policy from the system. |
|
Removes a catalog integration from the account. |
|
Removes the specified compute pool from the account. |
|
Removes a connection from the account. |
|
Removes the specified Cortex Search service from the current schema. |
|
Removes a database from the system. |
|
Removes the specified database role from the system. |
|
Removes a dynamic table from the current/specified schema. |
|
Removes an external table from the current/specified schema. |
|
Removes an external volume from the account, but retains a version of the external volume so that it can be recovered using UNDROP EXTERNAL VOLUME. |
|
Removes a failover group from the account. |
|
Removes the specified file format from the current/specified schema. |
|
Removes the specified user-defined function (UDF) or external function from the current/specified schema. |
|
Removes the specified data metric function (DMF) from the current or specified schema. |
|
Removes the specified service function. |
|
Removes the specified Git repository stage from the current/specified schema. |
|
Removes an Apache Iceberg™ table from the current/specified schema, but retains a version of the Iceberg table so that it can be recovered using UNDROP ICEBERG TABLE. |
|
Removes the specified image repository from the current or specified schema. |
|
Drops a secondary index. |
|
Removes an integration from the account. |
|
Removes a managed account, including all objects created in the account, and immediately restricts access to the account. |
|
Removes a masking policy from the system. |
|
Removes the specified materialized view from the current/specified schema. |
|
Removes a machine learning model from the current/specified schema. |
|
Removes the specified network policy from the system. |
|
Removes the specified network rule from the system. |
|
Removes the specified notebook from the current/specified schema. |
|
Removes a packages policy from the system. |
|
Removes a password policy from the system. |
|
Removes the specified pipe from the current/specified schema. |
|
Removes the specified privacy policy from the current/specified schema. |
|
Removes the specified stored procedure from the current/specified schema. |
|
Removes a projection policy from the current/specified schema. |
|
Removes a replication group from the account. |
|
Removes the specified resource monitor from the system. |
|
Removes the specified role from the system. |
|
Removes a row access policy from the system. |
|
Removes a schema from the current/specified database. |
|
Removes a secret from the system. |
|
Removes a sequence from the current/specified schema. |
|
Removes the specified Snowpark Container Services service from the current or specified schema. |
|
Removes a session policy from the system. |
|
Removes the specified share from the system and immediately revokes access for all consumers (i.e. accounts who have created a database from the share). |
|
Removes a snapshot. |
|
Removes the specified named internal or external stage from the current/specified schema. |
|
Removes a stream from the current/specified schema. |
|
Removes the specified Streamlit object from the current/specified schema. |
|
Removes a table from the current/specified schema, but retains a version of the table so that it can be recovered using UNDROP TABLE. |
|
Removes a tag from the system. |
|
Removes a task from the current/specified schema. |
|
Removes the specified user from the system. |
|
Removes the specified view from the current/specified schema. |
|
Removes the specified virtual warehouse from the system. |
|
E |
|
Manually executes an alert independent of the schedule for the alert. |
|
Executes a string that contains a SQL statement or a Snowflake Scripting statement. |
|
EXECUTE IMMEDIATE FROM executes the SQL statements specified in a file in a stage. |
|
Executes a Snowpark Container Services service as a job. |
|
Executes all the cells in the live version of a notebook. |
|
Manually triggers an asynchronous single run of a task (either a standalone task or the root task in a task graph) independent of the schedule defined for the task. |
|
Returns the logical execution plan for the specified SQL statement. |
|
G |
|
Downloads data files from one of the following internal stage types to a local directory or folder on a client machine. |
|
Assigns an application role to an account role or another application role. |
|
Assigns a database role to an account role or another database role. |
|
Grants a database role to a share. |
|
Transfers ownership of an object or all objects of a specified type in a schema from one role to another role. |
|
Grants one or more access privileges on a securable object to a role or database role. |
|
Grants one or more access privileges on a securable object to an application. |
|
Grants one or more access privileges on a securable schema-level object to an application role. |
|
Grants access privileges for databases and other supported database objects (schemas, UDFs, tables, and views) to a share. |
|
Assigns a role to a user or another role. |
|
Assigns a service role to an account role, application role, or database role. |
|
I |
|
Updates a table by inserting one or more rows into the table. |
|
Updates multiple tables by inserting one or more rows with column values (from a query) into the tables. |
|
L |
|
Returns a list of files that have been staged (i.e. uploaded from a local file system or unloaded from a table) in one of the following Snowflake stages. |
|
M |
|
Inserts, updates, and deletes values in a table based on values in a second table or a subquery. |
|
P |
|
Uploads data files from a local file system to one of the following Snowflake stages. |
|
R |
|
Removes files from either an external (external cloud storage) or internal (i.e. Snowflake) stage. |
|
Revokes an application role from an account role or another application role. |
|
Revokes a database role from an account role or another database role. |
|
Revokes a database role from a share. |
|
Removes one or more privileges on a securable object from a role or database role. |
|
Revokes one or more access privileges on a securable object from an application. |
|
Revokes one or more access privileges on a securable schema-level object from an application role. |
|
Revokes access privileges for databases and other supported database objects (schemas, tables, and views) from a share. |
|
Removes a role from another role or a user. |
|
Revokes a service role from an account role, application role, or database role. |
|
Rolls back an open transaction in the current session. |
|
S |
|
SELECT can be used as either a statement or as a clause within other statements. |
|
Initializes the value of a session variable to the result of a SQL expression. |
|
Lists the existing objects for the specified object type. |
|
Lists all the accounts in your organization, excluding managed accounts. |
|
Lists information about existing aggregation policies, including the creation date, database and schema names, owner, and any available comments. |
|
Lists the alerts for which you have access privileges. |
|
Lists the application packages for which you have access privileges across your entire account in the Native Apps Framework. |
|
Lists the application roles in the specified app for which for which you have access privileges. |
|
Lists the application objects for which you have access privileges across your entire account in the |
|
Lists all authentication policies defined in the system. |
|
Lists the catalog integrations in your account. |
|
Lists the Snowpipe Streaming channels for which you have access privileges. |
|
Lists all available classes. |
|
Lists the columns in the tables or views for which you have access privileges. |
|
Lists the compute pools in your account for which you have access privileges. |
|
Lists the connections for which you have access privileges. |
|
Lists the Cortex Search services for which you have access privileges. |
|
Lists the data metric functions (DMFs) for which you have access privileges. |
|
Lists all the database roles in the specified database. |
|
Lists the databases for which you have access privileges across your entire account, including dropped databases that are still within the Time Travel retention period and, therefore, can be undropped. |
|
Lists databases in a failover group. |
|
Lists databases in a replication group. |
|
Lists the active delegated authorizations for which you have access privileges. |
|
Lists the dynamic tables for which you have access privileges. |
|
Lists the endpoints in a Snowpark Container Services service (or a job service). |
|
Lists the event tables for which you have access privileges, including dropped tables that are still within the Time Travel retention period and, therefore, can be undropped. |
|
Lists all the external functions created for your account. |
|
Lists the external tables for which you have access privileges. |
|
Lists the external volumes in your account for which you have access privileges. |
|
Lists the primary and secondary failover groups in your account, as well as the failover groups in other accounts that are associated with your account. |
|
Lists the file formats for which you have access privileges. |
|
Lists native, user-defined, and external functions. |
|
Lists functions defined in machine learning models. |
|
Lists the Git repository branches in the specified repository. |
|
Lists the Git repository stages that you have privileges to access. |
|
Lists the Git repository tags in the specified Git repository. |
|
Lists all the accounts in your organization that are enabled for replication and indicates the Snowflake Region in which each account is located. |
|
Lists all access control privileges that have been explicitly granted to roles, users, and shares. |
|
Lists the hybrid tables for which you have access privileges. |
|
Lists the Apache Iceberg™ tables for which you have access privileges. |
|
Lists the image repositories for which you have access privileges. |
|
Lists the images in an image repository. |
|
Lists all the indexes in your account for which you have access privileges. |
|
Lists the integrations in your account. |
|
Lists all running transactions that have locks on resources. |
|
Lists the managed accounts created for your account. |
|
Lists masking policy information, including the creation date, database and schema names, owner, and any available comments. |
|
Lists the materialized views that you have privileges to access. |
|
Lists the machine learning models that you have privileges to access. |
|
Lists all network policies defined in the system. |
|
Lists all network rules defined in the system. |
|
Lists the notebooks for which you have access privileges. |
|
Lists the tables and views for which you have access privileges. |
|
Lists the organization account of the organization. |
|
Lists packages policy information. |
|
Lists all the account, session, and object parameters that can be set, as well as the current and default values for each parameter. |
|
Lists password policy information, including the creation date, database and schema names, owner, and any available comments. |
|
Lists the pipes for which you have access privileges. |
|
Lists primary keys for one or more tables. |
|
Lists the privacy policies for which you have access privileges. |
|
Lists the privileges granted to an application. |
|
Lists the stored procedures that you have privileges to access. |
|
Lists projection policy information, including the creation date, database and schema names, owner, and any available comments. |
|
Lists the references defined for an application in the manifest file and the references the consumer has associated to the application. |
|
Lists all the regions in which accounts can be created. |
|
Lists the release directives defined for an application package in the Native Apps Framework. |
|
Lists all the accounts in your organization that are enabled for replication and indicates the region in which each account is located. |
|
Lists all the primary and secondary databases (that is to say, all the databases for which replication has been enabled) in your account and indicates the region in which each account is located. |
|
|
|
Lists all the resource monitors in your account for which you have access privileges. |
|
Lists all the roles which you can view across your entire account, including the system-defined roles and any custom roles that exist. |
|
Lists all the service roles associated with a service. |
|
Lists the row access policies for which you have access privileges. |
|
Lists the schemas for which you have access privileges, including dropped schemas that are still within the Time Travel retention period and, therefore, can be undropped. |
|
Lists the secrets for which you have rights to see. |
|
Lists all the sequences for which you have access privileges. |
|
Lists the containers in all instances of a service. |
|
Lists instances of a service. |
|
Lists the Snowpark Container Services services (including job services) for which you have access privileges. |
|
Lists session policy information, including the creation date, database and schema names, owner, and any available comments. |
|
Lists all shares available in the system. |
|
Lists shares in a failover group. |
|
Lists shares in a replication group. |
|
Lists the snapshots for which you have access privileges. |
|
Lists all the stages for which you have access privileges. |
|
Lists the Streamlit objects for which you have access privileges. |
|
Lists the streams for which you have access privileges. |
|
Lists the tables for which you have access privileges, including dropped tables that are still within the Time Travel retention period and, therefore, can be undropped. |
|
Lists the tag information. |
|
Lists the tasks for which you have access privileges. |
|
Lists the event definitions for the specified app. |
|
List all running transactions. |
|
Lists all user-defined functions (UDFs) for which you have access privileges. |
|
Lists all users in the system. |
|
Lists all variables defined in the current session. |
|
Lists the versions defined in the specified application package. |
|
Lists the versions in a machine learning model. |
|
Lists the views, including secure views, for which you have access privileges. |
|
Lists all the warehouses in your account for which you have access privileges. |
|
T |
|
Removes all rows from a materialized view, but leaves the view intact (including all privileges and constraints on the materialized view). |
|
Removes all rows from a table but leaves the table intact (including all privileges and constraints on the table). |
|
U |
|
Restores the specified object to the system. |
|
Restores a dropped account that has not yet been permanently deleted (a dropped account that is within its grace period). |
|
Restores the most recent version of a dropped database. |
|
Restores the most recent version of a dropped dynamic table. |
|
Restores the most recent version of a dropped external volume. |
|
Restores the most recent version of a dropped Apache Iceberg™ table. |
|
Restore the most recent version of a dropped schema. |
|
Restores the most recent version of a dropped table. |
|
Restores the most recent version of a tag to the system. |
|
Drops a session variable. |
|
Updates specified rows in the target table with new values. |
|
Specifies the role, warehouse, database, or schema to use for the current session. |
|
Specifies the active/current database for the session. |
|
Specifies the active/current primary role for the session. |
|
Specifies the active/current schema for the session. |
|
Specifies the active/current secondary roles for the session. |
|
Specifies the active/current warehouse for the session. |