Skip to content

Instantly share code, notes, and snippets.

@kerbelp

kerbelp/redshift_stl_load_errors_columns_count.sql

Created September 10, 2016 14:19
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kerbelp/96dc2acedeb9b06a31f5a1e856f0188f to your computer and use it in GitHub Desktop.
Save kerbelp/96dc2acedeb9b06a31f5a1e856f0188f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
redshift_stl_load_errors_columns_count.sql
SELECT TRUNC(starttime) AS day,
colname,
err_reason,
COUNT(*) AS amount
FROM stl_load_errors
WHERE starttime >sysdate -1
GROUP BY day,
colname,
err_reason
ORDER BY day,
amount DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment