Skip to content

Instantly share code, notes, and snippets.

@bruno-uy

bruno-uy/redshift_copy_error_message.sql

Created March 15, 2024 13:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bruno-uy/be0ab08924826c1bca5c5de3f7ce0516 to your computer and use it in GitHub Desktop.
Save bruno-uy/be0ab08924826c1bca5c5de3f7ce0516 to your computer and use it in GitHub Desktop.
Download ZIP
Full message for Redshift COPY error when copying from parquet files
Raw
redshift_copy_error_message.sql
select s3l.message, s3l.*, sle.*
from stl_load_errors sle
left join svl_s3log s3l
on sle.query = s3l.query
order by sle.starttime desc
limit 10;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment