SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ18

VerifiedData Ingestion and Data Preparation

Consider the following COPY command, which loads CSV-formatted data into a Snowflake table from an internal stage by using a data-transformation query.

Question Image

This command produces the following error:

SQL compilation error: invalid parameter 'validation_mode'

Assuming the syntax is correct, what causes this error?

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

No comments yet. Be the first to start the discussion!