DML Commands (by Category)

This topic provides links to all the DML (data manipulation language) commands, grouped by category.

In this Topic:

General DML

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: