In Our use case we have many expressions in calculator component which are common to different Jobs ,How do a common calculator component which can be shared by different jobs?

Matillion ETL
1

In Our use case we have many expressions in calculator component which are common to different Jobs ,How do a common calculator component which can be shared by different jobs?

2

Hi ramesh! Just to make sure I understand correctly: are you looking for a suggestion for a calculator component that can be shared by different jobs? Or how to implement one you already have? I'm happy to look into this for you but want to make sure I get the correct information for you.

 

Thank you!

3

Thanks for response @MariaCommunityManager​

Yes am looking for a suggestion for a calculator component that can be shared by different jobs.

4

Hi ramesh,

 

I think that's not possible within Matillion. I started to work with Snowflake UDFs to use the same business logic in several places. You can define the UDF in Snowflake (or keep the code in a Matillion Orchestration Job with a SQL component). You can then call the UDF from the calculator component in your Transformation Job.

 

Br,

Michael

5

Thanks @Michael​ this helps me .