Consider the following COPY command which is loading data with CSV format into a Snowflake table from an internal stage through a data transformation query.
This command results in the following error:
SQL compilation error: invalid parameter 'validation_mode'
Assuming the syntax is correct, what is the cause of this error?
The VALIDATION_MODE parameter does not support COPY statements that transform data during a load. Since the provided COPY command includes a data transformation by selecting specific columns from the CSV file, this is causing the compilation error. Therefore, the presence of VALIDATION_MODE in this context is not valid and is leading to the mentioned error.
"VALIDATION_MODE does not support COPY statements that transform data during a load. If the parameter is specified, the COPY statement returns an error."
Answer is C and is validated
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table#:~:text=Note-,VALIDATION_MODE,-does%20not%20support
Fabrisa Is ccrrect C
i would choose D validation mode is causing the compiling error
I would choose C... https://docs.snowflake.com/en/sql-reference/sql/copy-into-table#optional-parameters
Based on the link above it's the opposite so "D" is correct.