06-18-2020 06:29 AM
Hi,
I am trying to create a CSV file by querying data from snowflake. I have a parent pipeline which is passing output file name & path as parameter to my child pipeline through pipeline execute.
When I am validating the child pipeline, everything is working normal but when I am running the parent, I am getting below error on the child pipeline at CSV Formatter step.
“Snap errors: {ruuid=58b7a2f5ba6d563aff5d73d9_8faf50a9-40dc-441e-9003-454d2c650b2d, reason=Input document should be a flattened map data, but found: LinkedHashMap, label=CSV Formatter, resolution=Please make sure the input document a flattened map data., failure=Cannot format CSV data}”.
Below is the parent pipeline.
Child Pipeline
Please let me know if you need any further information and as always thanks for your help in advance.
Solved! Go to Solution.
06-18-2020 09:25 AM
Hi,
Given that I can’t see the state of the ‘Pass through’ property in the Mapper3 Snap, I’d try and unselect the checkbox if it is selected. That will ensure that if there are any other fields received on the Mapper Snap’s input, they won’t be forwarded to the output.
BR,
Dimitri
06-18-2020 11:07 AM
Hi,
I just realized looking at the Settings in a Snowflake Execute Snap, that perhaps if you uncheck the “Pass Through” checkbox in the Snowflake Execute Snap, it might save you from adding the Mapper before the CSV Formatter Snap.
BR,
Dimitri