What will be recommended approach for deletion?

You want to automatically delete the files from stage after a successful load using the COPY INTO command.

What will be recommended approach for deletion?
A . Set PURGE=TRUE in the COPY INTO command
B. Set REMOVE=TRUE in the COPY INTO Command
C. No need to do anything, snowflake does it automatically

View Answer

Answer: A

Explanation:

https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html#purging-files-after-loading Load files from a table’s stage into the table and purge files after loading. By default, COPY does not purge loaded files from the location. To purge the files after loading:

Set PURGE=TRUE for the table to specify that all files successfully loaded into the table are purged after loading:

alter table mytable set stage_copy_options = (purge = true); copy into mytable;

You can also override any of the copy options directly in the COPY command:

copy into mytable purge = true;