How can a Snowflake user validate data that is unloaded using the COPY INTO
How can a Snowflake user validate data that is unloaded using the COPY INTO
To validate data that is unloaded using the COPY INTO <location> command in Snowflake, the user should use the VALIDATION_MODE = RETURN_ROWS statement. This option allows the verification of the data by specifying that the COPY command should only return the rows that failed to unload, which helps in identifying and fixing any issues with the data.
D is correct Use the VALIDATION_MODE = RETURN_ROWS statement. https://docs.snowflake.com/en/sql-reference/sql/copy-into-location#optional-parameters
D correct - https://community.snowflake.com/s/article/Best-Practices-for-Data-Unloading