SQL DML Commands

Question 1

COPY INTO<location></location>

Answer 1

Unloads data from a table (or query) into one or more files in one of the following locations.

Question 2

COPY INTO<table>

Answer 2

Loads data from staged files to an existing table.

Question 3

DELETE

Answer 3

Remove rows from a table.

Question 4

GET

Answer 4

Downloads data files from one of the following Snowflake stages to a local directory/folder on a client machine.

Question 5

INSERT

Answer 5

Updates a table by inserting one or more rows into the table.

Question 6

INSERT (multi-table)

Answer 6

Updates multiple tables by inserting one or more rows with column values (from a query) into the tables.

Question 7

LIST

Answer 7

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.

Question 8

MERGE

Answer 8

Inserts, updates, and deletes values in a table based on values in a second table or a subquery.

Question 9

PUT

Answer 9

Uploads (i.e. stages) data files from a local directory/folder on a client machine to one of the following Snowflake stages.

Question 10

REMOVE

Answer 10

Removes files from either an external (external cloud storage) or internal (i.e. Snowflake) stage.

Question 11

TRUNCATE TABLE

Answer 11

Removes all rows from a table but leaves the table intact (including all privileges and constraints on the table).

Question 12

UPDATE

Answer 12

Updates specified rows in the target table with new values.