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

Export stl_loaderrors to variable

Hi. We are using slack to deliver status messages from matillion. We have a source that can be somewhat unrealiable and we get a loaderror from redshift sometimes. In order to speed up troubleshooting it would be very helpful to deliver the message from the stl_loaderrors table to slack. Is it possible to export that message to a variable?

1 Community Answers

Matillion Agent  

Ian Funnell —

Hi Johan,

I don’t think you could ever export all the stl_loaderrors information to a single variable, because there can be more than one error per load.

However you could do as follows:

Best regards,
Ian

Post Your Community Answer

To add an answer please login