This topic provides links to all the DML (data manipulation language) commands, grouped by category.
In this Topic:
Commands for inserting, deleting, updating, and merging data in Snowflake tables:
Queries and Transactions¶
Snowflake supports the ANSI-standard SELECT command for performing queries.
For transactions, Snowflake supports the following standard commands:
Data Loading / Unloading DML¶
Commands for bulk copying data into and out of Snowflake tables:
- See also:
- VALIDATE (table function)
File Staging Commands (for Data Loading / Unloading)¶
These commands do not perform any actual DML, but are used to stage and manage files stored in Snowflake locations (named internal stages, table stages, and user stages), for the purpose of loading and unloading data: