Question

How to pass runtime value to transformer in Snowflake Destination

  • 23 August 2023
  • 0 replies
  • 18 views

Hi,

I’m trying to merge table data if data is not matched. I have multiple tables, so need to create dynamic pipeline which will take input as Table_Name and Primary Key columns to  Merge Configuration. But in runtime, Snowflake not reading values and create table as parameter name.

Transformer Pipeline:

Raw Data (which actual table in Oracle DB)

Snowflake:

 

But Pipeline running, it creates new table as TABLE_NAME, instead of merging on EMP table

 


0 replies

Be the first to reply!

Reply