COPY command failures prevent data loading into Redshift

Redshift COPY command can fail to load certain rows from S3 into tables due to data type mismatches, constraint violations, or format errors. Failed rows are logged but don't fail the entire COPY operation, potentially causing silent data loss.

After each COPY operation, run monitoring task SendCopyErrorsToDatadog to query Redshift system tables (STL_LOAD_ERRORS) for failed rows. Alert the data team when errors exceed threshold so they can investigate root cause and fix upstream data quality issues.