Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

loading STL_LOAD_ERRORS data in a redshift table

Hi Experts,

I am new to matillion and trying to capture the detail of of STL_LOAD_ERRORS table which is shown in the "task" tab whenever Orchestration job fails . Is there any method by which i can load the details in a redshift table?





2 Community Answers

Matillion Agent  

David Lipowitz —

Hi Nitesh,

Thanks for writing in. You can extract and save data from STL_LOAD_ERRORS into another table in Redshift using a transformation job.

Dictionary tables aren’t accessible from our Table Input component, so you will have to use a SQL component. Inside there you can specify a query written against the STL_LOAD_ERRORS table, and then connect that to (say) a Rewrite Table component to create a new table based on the SQL you’ve written.

I hope that helps and please let us know if you have any more questions.

Best Regards,
Dave


Nitesh Mehrotra —

Thanks a lot David for your valuable comments, it was of great help .

Post Your Community Answer

To add an answer please login