How do you validate the data that is unloaded using COPY INTO command

How do you validate the data that is unloaded using COPY INTO command
A . After unloading, load the data into a relational table and validate the rows
B . Load the data into a CSV file to validate the rows
C . Use validation_mode=’RETURN_ROWS’; with COPY command

View Answer

Answer: C

Explanation:

Validating Data to be Unloaded (from a Query)

Execute COPY in validation mode to return the result of a query and view the data that will be unloaded from the orderstiny table if COPY is executed in normal mode: copy into @my_stage

from (select * from orderstiny limit 5)

validation_mode=’RETURN_ROWS’;

https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html#validating-data-to-be-unloaded-f rom-a-query