DML (Data Manipulation Language) Commands

This topic provides links to all the DML commands, grouped by category.

General DML

Commands for inserting, deleting, updating, and merging data in Snowflake tables:

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: