Skip to content

Instantly share code, notes, and snippets.

@ctrlaltdylan

ctrlaltdylan/redshift_error_log.sql

Created January 15, 2016 19:36
Show Gist options
  • Save ctrlaltdylan/e66174e6d5c2d880447d to your computer and use it in GitHub Desktop.
Save ctrlaltdylan/e66174e6d5c2d880447d to your computer and use it in GitHub Desktop.
Download ZIP
redshift_error_log.sql
Raw
redshift_error_log.sql
select le.starttime, d.query, d.line_number, d.colname, d.value,
le.raw_line, le.err_reason
from stl_loaderror_detail d, stl_load_errors le
where d.query = le.query
order by le.starttime desc
limit 100
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment