Assuming the syntax is correct, what is the cause of this error?

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?
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.

View Answer

Answer: A