User Defined Function -

Matillion ETL
1

Hi,

 

I have frequently used calculation (like exchange rate calculation) I plan to use it in multiple jobs. I am able to create it under Snowflake (or any backend) and call it from user defined function.

But is there any feature of Matillion which can help us to do that way I don't have to change in database rather and logic will be maintained in tool of Matillion?

 

Thank you in advance.

2

Will the Calculator component do what you need? https://documentation.matillion.com/docs/1991925

3

I use the "SQL Script" component in an Orchestration Job to hold the complete definition of my UDF. The SQL script cotains the "CREATE OR REPLACE FUNCTION ..." code wich - on execution - recreates the actual UDF in the database. That way, all "code" artifacts are maintained in Matillion (and thus also in our git repository).