Answer-first summary for fast verification
Answer: Use the LOAD HISTORY function to view the status of loaded files., Use the COPY HISTORY function to update the status of loaded files.
Both LOAD_HISTORY view and COPY_HISTORY table function can show which files were loaded, when, and if there were any errors. These are the recommended ways to verify loads. Options A and B deal with file removal, not load verification.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which step does Snowflake recommend performing when loading data from a stage?
A
Use PURGE when using the COPY INTO [table] command.
B
Use REMOVE when using the COPY INTO [table] command.
C
Use the LOAD HISTORY function to view the status of loaded files.
D
Use the COPY HISTORY function to update the status of loaded files.
