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
David Lipowitz —
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.