Which validation option is the only one that supports the COPY INTO
Which validation option is the only one that supports the COPY INTO
The only validation option that supports the COPY INTO <location> command is RETURN_ROWS. This validation mode is used exclusively for the unloading process into a stage, which is what the COPY INTO <location> command is designed to do.
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table https://docs.snowflake.com/en/sql-reference/sql/copy-into-location Loading: COPY INTO (table) VALIDATION_MODE = RETURN_N_ROWS, RETURN_ERRORS, RETURN_ALL_ERRORS Unloading COPY INTO (location) VALIDATION_MODE = RETURN_ROWS
The question is not phrased well, not specific enough, they should also add that they're asking about unloading into a stage.
A. https://docs.snowflake.com/en/sql-reference/sql/copy-into-location