Getting Job Inventory information for a Project

Matillion ETL
1

Is there a way that I can readily fetch all the information related to Job inventory of a project built on Matillion in terms of:

  1. Project Name
  2. Job Name
  3. Input and Output tables
  4. Job Dependencies - Other scripts and jobs
  5. Scheduling information
  6. Config Information

 

 

2

Hi @nidhi.sarin1618205673347​ ,

Yes this can be done fairly easily. The tougher part will be getting it into a format that is going to acceptable. You don't mention what format you would want the output in but it's fairly straight forward to grab this information from the Matillion API in JSON format. I would add a link to the documentation that would get you there but it seems that there is something not working in Matillion's documentation site at the moment.

Long story short you will need to export the Project Group. That will give you a JSON export of all the information you are looking for. I will say that I have spent a lot of time in the area but I have never tried to tie out dependencies.

If you are just looking for a method of generating documentation for the items you listed, you should be able to right click on any orchestration and generate documentation which should have all the items you mentioned. I hope this helps. Thanks for posting and let us know if you need more info.