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
Laura Malins —
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.
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.