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

Job metrics

Is it possible to export some of the metrics availablee in the task hierarchy into JSON or an external table? Specifically the job steps, runtimes and insert/update counts.

1 Community Answers

Matillion Agent  

Dan D'Orazio —

Hi Michael -

You can accomplish some of this, at run-time, by using Component Exports(https://snowflakesupport.matillion.com/customer/portal/articles/2908982?b_id=16164), assigning them to environment or job variables, and then using those variables as you wish.

We have a blog series that may assist with this pattern as well, specifically this section may be of interest (https://www.matillion.com/blog/error-handling-alerting-audit-tables/)

Depending on your use-case, you may be able to retrieve this information by querying the Matillion API as well, but this would be after-the-fact.

Here is a basic map of the v1 API (https://snowflakesupport.matillion.com/customer/portal/articles/2920263). You can get the full list of endpoints by assessing the response from a GET request sent to http(s)://your-Matillion-host:port/rest/v1

Best -
Dan

Post Your Community Answer

To add an answer please login