What should be used to show the status of partial data loads and loading errors?
What should be used to show the status of partial data loads and loading errors?
The COPY_HISTORY function should be used to show the status of partial data loads and loading errors. This table function provides details about the status of data loading operations, indicating whether they are in progress, completed successfully, failed, partially loaded, or skipped.
https://docs.snowflake.com/en/sql-reference/functions/copy_history#output
Status: Load in progress, Loaded, Load failed, Partially loaded, or Load skipped.
https://docs.snowflake.com/en/user-guide/data-load-bulk-ts
A https://docs.snowflake.com/en/sql-reference/functions/copy_history#:~:text=%2C%20Table%20Functions-,COPY_HISTORY,-This%20table%20function And ChatGPT and Gemini give different answers!!!