Is it possible to get a list of all jobs that exist in Matillion (doesn't matter if they ever ran or are scheduled)? I think it's not possible to access via API.
What would also be really cool is if we could access the DB of Matillion to load job and schedule information. I think a lot of devs want to make this info more transparent to users of our DWH's or to be able to analyze it in our BI solutions. (Identifying jobs that are not scheduled, jobs that fastly increase in runtime, etc.)
Hi @Manuel ,
it is quite easy to connect to the PostgreSQL database that is used by your Matillion instance. Disclaimer: I think that direct DB access is not officially supported and you should know what you do on the database!
If you want to try things, create a new "Database Query" Component and connect to a PostgreSQL database on "jdbc:postgresql://127.0.0.1:5432/". The username is "postgres".
You can query the Information Schema to see all available tables, views, etc.
Good luck and let us know what you found out and how you will use the data.
Did you ever find a solution to this? From my computer, I want to be able to connect to the locally installed postgres DB that Matillion uses to run it's operations. There's a lot of useful operational data in that DB that I want to make accessible and provide more transparency.
Hi @MichaelBlack ,
we use the data from the local Postgres DB for our own Matillion monitoring and reporting. Please see my post above: We use the Database Query Component to pull all data from the local Postgres DB to our Snowflake instance. All further processing is done on Snowflake and does not conflict with the local operation of our Matillion Server instance.
I think a direct connection from your Computer requires a lot of tasks in firewall and network setup. In theory it should be possible but I see security risks.