Redshift COPY throws error but 'stl_load_errors' system table does not provide details

Question

When I attempt to copy a CSV from S3 into a new table in Redshift (which normally works for other tables) I get this error

ERROR: Load into table 'table_name' failed. Check 'stl_load_errors' system table for details.

But, when I run the standard query to investigate stl_load_errors

SELECT errors.tbl, info.table_id::integer, info.table_id, *
FROM stl_load_errors errors
INNER JOIN svv_table_info info
  ON errors.tbl = info.table_id

I don't see any results related to this COPY. I see errors from previous failed COPY commands, but none related to the most recent one that I am interested in.

Please make sure that you are querying stl_load_errors table with same user you are performing COPY command. You can also try to avoid using ssv_table_info table in query or change INNER to LEFT join. — Edgars T.
This was it. Feel free to post as a full answer so I can accept. — XaxD

Edgars T. Edgars T. · Accepted Answer · 2020-08-26T19:36:50

Please make sure that you are querying stl_load_errors table with same user you are performing COPY command. You can also try to avoid using ssv_table_info table in query or change INNER to LEFT join.

Redshift COPY throws error but 'stl_load_errors' system table does not provide details

1 Answers