How can I Iterate & extract GRID variables from ALL orchestrations?

Matillion ETL
1

He Everyone,

 

I'm trying to find a way where I can extract all Grid Variables (from all Jobs) and load them into a Snowflake table for reference purposes.

 

  • Has anyone been able to do this? Or something similar?
  • Would it be possible to do this through Matillion API somehow?
  • Could these values just be web scraped with some script?
2

How are you generating values for grid variables ? or its static added?

3

In my use case the grid variables are hard coded with manual updates as needed. But we use this particular grid variable in 100+ orchestrations within a project & Each orchestration has a different set of grid values.

 

This is a real pain. Because these hard coded grid variables happen to be extremely important and we are having issues frequently because we don't have all the values in in place.

 

Any work arounds, ideas, or solutions to this would be helpful?