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

Validate Matillion jobs programmatically

Hi,

We would like to validate (build) our Matillion jobs in our QA environment every night to ensure they are still valide after the last changes in the database(s).
Example: we created a Matillion job last month that uses columns C1 and C2 in table T1. Yesterday we dropped column C2 in table T1 and commited the change in our Version Control System. It got deployed automatically to our QA environment. But nobody remembered to update the Matillion job. The goal is to be notified during the night that the Matillion job needs to be reviewed before we promote the change in the database to PROD.

I didn't find a way to validate Matillion jobs through the API. Is there any way we can automate this process?

Thanks in advance.
Regards,
Tiago Silva

3 Community Answers

Matillion Agent  

Laura Malins —

Hi Tiago

You’re correct unfortunately there is no way currently to validate a job using the API. You’re only option is to run the job if you need to test if the columns exist or, as you know, you can validate through the user interface.

I’ll raise your request with our development team.

Thanks
Laura


Tiago Silva —

Hi,
Once you have raised it with the development team, can you please let us know if this is a feature you consider to include in Matillion? And if so, when it is planned to be released?

Regards,
Tiago Silva


Matillion Agent  

Laura Malins —

Hi Tiago

Apologies when I answered this I didn’t realise we had a call scheduled! Yes of course I’ll keep you updated. I’ve raised the ticket now and the first step is for it to be evaluated and reviewed to see how it fits into our product roadmap.

Thanks
Laura

Post Your Community Answer

To add an answer please login