Question

A data engineer runs a bulk COPY INTO command to load 500 CSV files into a table. The load completed, but the engineer suspects some rows were rejected due to data type mismatches. They want to retrieve the specific rows that failed during that most recent load so they can investigate the raw values. Which approach should they use?

Accepted Answer

Query the VALIDATE table function referencing the target table and the COPY job's query ID to return the rejected rows and error details

Answer

Re-run the COPY INTO command with VALIDATION_MODE = 'RETURN_ERRORS' to reload and capture the failed rows

Answer

Query the COPY_HISTORY table function, which returns each individual rejected row with its column values

Answer

Set ON_ERROR = SKIP_FILE and re-run the COPY INTO to output the error rows to a separate error stage