cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

$original values thru Snowflake Bulk Load

arvindnsn
Contributor

Below is the snaplogic process to load data from Redshift to Snowflake. The Map execution mapper has a output variable named "$last_execution_datetime". The data is sourced from Redshift Select Snap and Snowflake Bulk load is used to load the data. The output of the Snowflake Bulk Load snap does not bring the $original values that would include the "$last_execution_datetime" from the mapper as shown in the below pictures.

Is there a way to get the $original values from the output of the Snowflake Bulk Load 

 

arvindnsn_0-1704919876818.png

arvindnsn_3-1704920179790.png

arvindnsn_4-1704920252374.png

As the above picture shows, there is no $original being carried from the previous mapper even though I have "Pass through" checked.

Is there a way to achieve the above mentioned use case.

Thanks

Aravind N

 

5 REPLIES 5

Yes, if the Bulk Load fails then you will have no output documents from the Join Snap.