Is there a way to convert a Matillion trn job into plain SQL? so we could see the job like a stored proc

Matillion ETL
1

is there a way to convert a Matillion trn job into plain SQL? so we could see the job like a stored proc

2

Hi @steve.inglis​

If the trn job has an output table, in the SQL tab of the output table properties, there is a check box on the bottom left called 'Expand References' and that provides the full sql for the trn job.

Moreover, it would be useful to know if there is a wider ask here. Are you interested in using less of the product, or are there any pain points you're trying to address by going down this route? Moving to a stored-procedure would mean:

  • you would lose the ability to easily test/troubleshoot the job logic
  • our updates may include improved SQL being emitted in a later release which you may miss out on

Hope this helps, Steve!

Thanks,

Chika

3

Thank you, my intension is to be able to track full data lineage - I was hoping getting the the sql would give us the oppountity to do this easier

4

Hi Steve, Just checking if you'd seen the Matillion Metadata API can provide lineage information: https://documentation.matillion.com/docs/9907241#lineage-log-api-endpoints

5

Hi @Phil_BMatillionSalesEngineer​ — thanks for jumping in here and recommending a doc!

6

Thanks - I've just seen a short video on Matillion to Collibra connection. This is very interesting. I'd love to know more about this

7

There's a page here on the setup (and possibly the same video you already saw 😊 ): https://documentation.matillion.com/docs/collibra-integration

8

Thank you