Consider the following COPY command, which loads CSV-formatted data into a Snowflake table from an internal stage by using a data-transformation query.
This command produces the following error:
SQL compilation error: invalid parameter 'validation_mode'
Assuming the syntax is correct, what causes this error?
A The VALIDATION_MODE parameter supports COPY statements that load data from external stages only. B The VALIDATION_MODE parameter does not support COPY statements with CSV file formats. C The VALIDATION_MODE parameter does not support COPY statements that transform data during a load. D The value return_all_errors of the option VALIDATION_MODE is causing a compilation error. Show Answer Answer Explanation VALIDATION_MODE is unsupported when COPY INTO <table> transforms data during the load. Selecting specific staged-file columns and mapping them to the target columns is a transformation, so specifying VALIDATION_MODE = RETURN_ALL_ERRORS causes the error. Snowflake COPY INTO <table> documentation
Learn more 
Community Discussion