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 |
Category |
---|---|---|
A |
||
Modifies the metadata of an account-level or database object, or the parameters for a session. |
||
Modifies parameters for your account. |
||
Modifies the properties of an existing API integration. |
||
Modifies the properties for an existing database, including the following. |
||
Modifies the properties of an existing external function. |
DDL for User-Defined Functions, External Functions, and Stored Procedures |
|
Modifies the properties, columns, or constraints for an existing external table. |
||
Modifies the properties for an existing file format object. |
||
Modifies the properties for an existing UDF (user-defined function). |
DDL for User-Defined Functions, External Functions, and Stored Procedures |
|
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 network policy. |
||
Modifies the properties for an existing notification integration. |
||
Modifies a limited set of properties for an existing pipe object. |
||
Modifies the properties for an existing stored procedure. |
DDL for User-Defined Functions, External Functions, and Stored Procedures |
|
Modifies the properties and triggers for an existing resource monitor. |
||
Modifies the properties for an existing role. |
||
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 for an existing security integration. |
||
Modifies the properties for an existing sequence. |
||
Sets parameters that change the behavior for the current session. |
||
Modifies the properties for an existing share. |
||
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, 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 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. |
(uncategorized) |
|
Adds a comment or overwrites an existing comment for an existing object. |
||
Commits an open transaction in the current session. |
||
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 API integration object in the account, or replaces an existing API integration. |
||
Creates a copy of an existing object in the system. |
Database, Schema, & Share DDL , Table, View, & Sequence DDL , Data Loading / Unloading DDL |
|
Creates a new database in the system. |
||
Creates a new external function. |
DDL for User-Defined Functions, External Functions, and Stored Procedures |
|
Creates a new external table in the current/specified schema or replaces an existing external table. |
||
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). |
DDL for User-Defined Functions, External Functions, and Stored Procedures |
|
Creates a new integration in the system or replaces an existing integration. |
||
Creates a new managed account. |
||
Creates a new Column-level Security 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 network policy. |
||
Creates a new notification integration in the account or replaces an existing integration. |
||
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 stored procedure. |
DDL for User-Defined Functions, External Functions, and Stored Procedures |
|
Creates a new resource monitor. |
||
Create a new role or replace an existing role in the system. |
||
Creates a new schema in the current database. |
||
Creates a new 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, empty share. |
||
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 table in the current/specified schema or replaces an existing table. |
||
This topic describes how to create constraints by specifying a |
||
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 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 data from a table using an optional WHERE clause and/or additional tables. |
||
Describes the details for the specified object. |
||
Describes the VALUE column and virtual columns in an external table. |
||
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). |
DDL for User-Defined Functions, External Functions, and Stored Procedures |
|
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 pipe, as well as the default values of the properties. |
||
Describes the specified stored procedure, including the stored procedure’s signature (i.e. arguments), return value, language, and body (i.e. definition). |
DDL for User-Defined Functions, External Functions, and Stored Procedures |
|
Describes the columns in the result of a query you executed (within 24 hours of when you executed the query). |
||
Describes a sequence, including the sequence’s interval. |
||
Describes the data objects that are included in a share. |
||
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 either the columns in a table or the current values, as well as the default values, for the stage properties for a table. |
||
Describes the columns in a task. |
||
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). |
||
Removes the specified object from the system. |
||
Removes a database from the system. |
||
Removes an external table from the current/specified schema. |
||
Removes the specified file format from the current/specified schema. |
||
Removes the specified user-defined function (UDF) from the current/specified schema. |
DDL for User-Defined Functions, External Functions, and Stored Procedures |
|
Removes an integration from the current/specified schema. |
||
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. |
DDL for User-Defined Functions, External Functions, and Stored Procedures |
|
Removes the specified network policy from the system. |
||
Removes the specified pipe from the current/specified schema. |
||
Removes the specified stored procedure from the current/specified schema. |
DDL for User-Defined Functions, External Functions, and Stored Procedures |
|
Removes the specified resource monitor from the system. |
||
Removes the specified role from the system. |
||
Removes a schema from the current/specified database. |
||
Removes a sequence from the current/specified schema. |
||
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 the specified named internal or external stage from the current/specified schema. |
||
Removes a stream 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 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 |
||
Returns the logical execution plan for the specified SQL statement. |
(uncategorized) |
|
G |
||
Downloads data files from one of the following Snowflake stages to a local directory/folder on a client machine. |
||
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. |
||
Grants access privileges for databases and other supported database objects (schemas, tables, and views) to a share. |
||
Assigns a role to a user or another 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 (i.e. stages) data files from a local directory/folder on a client machine to one of the following Snowflake stages. |
||
R |
||
Removes files that have been staged (i.e. uploaded from a local file system or unloaded from a table) in one of the following Snowflake internal stages. |
||
Removes one or more privileges on a securable object from a 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. |
||
Rolls back an open transaction in the current session. |
||
S |
||
SELECT can be used in both a statement and a clause within a SELECT statement. |
||
Initializes the value of a session variable to the result of a SQL expression. |
||
Lists the existing objects for the specified object type. |
||
Lists the columns in the tables or views for which you have access privileges. |
||
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 the active delegated authorizations for which you have access privileges. |
||
Lists all the external functions created for your account. |
DDL for User-Defined Functions, External Functions, and Stored Procedures |
|
Lists the external tables for which you have access privileges. |
||
Lists the file formats for which you have access privileges. |
||
Lists all the native (i.e. system-defined/built-in) scalar functions provided by Snowflake, as well as any user-defined functions (UDFs) or external functions that have been created for your account. |
||
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 granted to roles, users, and shares. |
||
Lists the integrations for which you have access privileges. |
||
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 all network policies defined in the system. |
||
Lists the tables and views for which you have access privileges. |
||
Lists all the accounts in your organization. |
||
Lists all the account, session, and object parameters that can be set, as well as the current and default values for each parameter. |
||
Lists the pipes for which you have access privileges. |
||
Lists the stored procedures that you have privileges to access. |
DDL for User-Defined Functions, External Functions, and Stored Procedures |
|
Lists all the regions in which accounts can be created. |
||
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 (i.e. all databases for which replication has been enabled) in your organization 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 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 all the sequences for which you have access privileges. |
||
Lists all shares available in the system. |
||
Lists all the stages 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 tasks for which you have access privileges. |
||
List all running transactions. |
||
Lists all user-defined functions (UDFs) for which you have access privileges. |
DDL for User-Defined Functions, External Functions, and Stored Procedures |
|
Lists all users in the system. |
||
Lists all variables defined in the current session. |
||
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 most recent version of a dropped database. |
||
Restore the most recent version of a dropped schema. |
||
Restores the most recent version of a dropped table. |
||
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 role for the session. |
||
Specifies the active/current schema for the session. |
||
Specifies the active/current warehouse for the session. |