01-10-2024 01:01 PM
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
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
01-29-2024 08:31 AM
Yes, if the Bulk Load fails then you will have no output documents from the Join Snap.