Which command do you run to remove files from stage?

Which command do you run to remove files from stage?
A . REMOVE
B. DELETE
C. PURGE
D. CLEAN

View Answer

Answer: A

Explanation:

REMOVE

Removes files that have been staged (i.e. uploaded from a local file system or unloaded from a table) in

one of the following Snowflake internal stages:

Named internal stage.

Stage for a specified table.

Stage for the current user.

Note that using the command to remove files from an external stage might work but is not officially supported.

REMOVE can be abbreviated to RM. https://docs.snowflake.com/en/sql-reference/sql/remove.html#remove