What step does Snowflake recommend when loading data from a stage?
Use PURGE when using the COPY INTO command.
This is a voting comment (?) , you can switch to a simple comment.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
You can sign-up or login (it's free).
Use REMOVE when using the COPY INTO
Use the LOAD HISTORY function to view the status of loaded files.
Use the COPY HISTORY function to update the status of loaded files.
Snowflake recommends using the LOAD HISTORY function to view the status of loaded files. This function is essential in verifying that the files have been loaded correctly and for detecting any errors that may have occurred during the loading process.
Correct Answer: C. Use the LOAD HISTORY function to view the status of loaded files. Snowflake recommends using the COPY INTO <table> ... command to load data from a stage into a table. After the data is loaded, the LOAD HISTORY function (which can be accessed via the INFORMATION_SCHEMA.LOAD_HISTORY view or by querying the COPY_HISTORY table function) is used to view the status of loaded files. This helps to ensure that files are loaded correctly and to check for any errors during the load process.