Data Manipulation Language (DML) 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:
COPY INTO <table> (loading/importing data)
COPY INTO <location> (unloading/exporting data)
- 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: