A COPY on the main provisioned Redshift cluster fails after a supplier changes a field format. Operations needs the offending source file, row, and parsing details before deciding on a correction. Which first step is most appropriate?

Published
  1. Inspect the applicable load-error system records, such as STL_LOAD_ERRORS for this supported execution context, and compare them with the source and target schema.
  2. Delete the target table immediately before preserving any diagnostics.
  3. Rename the source files without inspecting their contents or the target columns.
  4. Set a very high MAXERROR and treat the load as complete without reviewing omitted rows.

Comments — 0