This website uses cookies to ensure you get the best experience.
Learn more.
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
- 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.
- Delete the target table immediately before preserving any diagnostics.
- Rename the source files without inspecting their contents or the target columns.
- Set a very high MAXERROR and treat the load as complete without reviewing omitted rows.
Comments — 0
Sign in to comment