kerbelp · September 10, 2016 14:19
diff --git a/redshift_stl_load_errors_columns_count.sql b/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;
	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;