Skip to content

Instantly share code, notes, and snippets.

@kerbelp

kerbelp/redshift_stl_load_errors_column_files.sql

Last active September 10, 2016 14:32
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 kerbelp/eda884a9322ac6e010665f0ad7972e2b to your computer and use it in GitHub Desktop.
Save kerbelp/eda884a9322ac6e010665f0ad7972e2b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
redshift_stl_load_errors_column_files.sql
SELECT TRUNC(starttime) AS day,
colname,
err_reason,
filename,
line_number
FROM stl_load_errors
WHERE colname = 'err'
GROUP BY day,
colname,
err_reason,
filename,
line_number
ORDER BY day;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment