$original values thru Snowflake Bulk Load
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 ...
Forum Discussion
Hello arvindnsn,
My assumption here is that you want to pass the $last_execution_datetime from the first Mapper.
To achieve that you can use a Copy Snap and a Join Snap that will wait for the Bulk Load to finish and then you can use the $last_execution_datetime field.
Please refer to the photo below:
and the Join Snap configuration:
Please let me know if this helps you.
Regards,
Aleksandar.
Aleksandar_A In the solution, you provided above, If the Bulk Load failed, I don't want the JOIN-WAIT snap to bring the $Original values in its output. The only time i need the $Original values are if the Bulk load is successful.
Yes, if the Bulk Load fails then you will have no output documents from the Join Snap.
