cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

How to capture Error records in Redshift Bulk load

rsharma2
New Contributor II

I have a requirement to load around ~300k records to a Redshift table.I have used Redshift Bulk snap for this purpose with the error count setting to 20000.I have an error pipeline called in this main pipeline. After executing this pipeline I was hoping the error pipeline to capture these error records(~6000) and load them to my error custom error table which is in Redshift. However I noticed these error records are not captured by the error pipeline or the error view. These error records can however be retrieved from Redshift standard table called โ€˜stl_load_errorsโ€™.I want to know a way so that I can have these error records captured in my custom error table or in the error view of the pipeline.

0 REPLIES 0