How to pass values to a child snap
I am a newbie to Snaplogic. I am developing a pipeline to copy data from Oracle tables to Snowflake using Snaplogic. I have created a parent pipeline and used “Pipeline Execute” to pass values to th...
Forum Discussion
Hi Taylor.
Thanks very much for replying. I made the change as you suggested but the output view in the child mapper doesn’t show the data as expected, even though it validates “green”. Is that expected or I am mistaken?
Hi. Unfortunately our UI doesn’t support a way to preview the output of snaps in a child pipeline when executed from the parent pipeline, so what you’re doing here is just executing the child by itself, correct? When you do that, the values of the pipeline parameters that the Mapper is referencing aren’t coming from the parent pipeline; they are just the default values of the pipeline parameters:
Can you clarify in what way they are different?
A document should not be modified once it has been written to the output view. Making a copy of the document avoids issues. Change the loop to create a new wrapper Map
for item in sourceTables: wrapper = java.util.HashMap(in_doc) wrapper['query'] = "update iods_staging.{} set record_inserted = true;".format(item) self.output.write(wrapper)Hi Akidave,
Thanks you so much for your solution. However, I would really appreciate if you could explain me more why we should not modify the document once it has been written to the output view.
Thanks again.
Aditya
Hi Dmiller,
Please find below output from script snap and mapper output. Mapper output has two update statements same which is incorrect, it has to be same like script.
Script Snap:
“query”: “update iods_staging.stg_sf_account_dim_institution set record_inserted = true;”
“query”: “update iods_staging.stg_sf_accountdistict_dim_institution set record_inserted = true;”
“query”: “update iods_staging.stg_sf_recordtype_dim_institution set record_inserted = true;”Mapper Output:
“query”
“update iods_staging.stg_sf_account_dim_institution set record_inserted = true;”
“update iods_staging.stg_sf_recordtype_dim_institution set record_inserted = true;”
“update iods_staging.stg_sf_recordtype_dim_institution set record_inserted = true;”Thanks
AdityaIs there a reason you need the Mapper after the Script Snap? Do you plan to modify other information?
If so and there are items like query that should not be modified, then select the Pass through option and don’t specify them in the mapping table.
