Question

A data engineer is preparing to bulk load a large batch of CSV files from a named internal stage into a target table using COPY INTO. Before committing the load, they want to detect any data type mismatches or malformed rows without actually inserting any data into the table. Which approach should they use?

Accepted Answer

Run COPY INTO with the VALIDATION_MODE = 'RETURN_ERRORS' parameter to inspect errors without loading data

Answer

Run COPY INTO with ON_ERROR = 'CONTINUE' to load valid rows and skip the bad ones

Answer

Run COPY INTO with PURGE = TRUE to remove staged files after validation

Answer

Run COPY INTO with FORCE = TRUE to reprocess files and surface errors