{"class_fqid":"com-snaplogic-pipeline_8","snode_id":"5abb469264765400214d0bf8","instance_id":"15a75dcc-74ae-4b16-aae9-9064aad965ee","instance_version":68,"link_map":{"link113":{"src_view_id":"output0","dst_view_id":"inputRows","src_id":"915ad211-f631-4c89-84bd-867878bc5df3","dst_id":"55c02f53-a117-4021-964d-863c2ad11642","isGoto":false},"link112":{"src_view_id":"output0","dst_view_id":"input0","src_id":"573d222c-a94a-45d0-afc8-ca228b6f544f","dst_id":"915ad211-f631-4c89-84bd-867878bc5df3","isGoto":false},"link115":{"src_view_id":"output0","dst_view_id":"input0","src_id":"391a3a97-12e7-499c-b2cf-2236fe343d57","dst_id":"7a0385ad-be28-4e00-b4cf-7aaba9e1cfd2","isGoto":false},"link114":{"src_view_id":"output101","dst_view_id":"input0","src_id":"55c02f53-a117-4021-964d-863c2ad11642","dst_id":"391a3a97-12e7-499c-b2cf-2236fe343d57","isGoto":false},"link108":{"src_view_id":"output0","dst_view_id":"input0","src_id":"2a361e47-0697-4d50-af72-bbc99a32daaa","dst_id":"573d222c-a94a-45d0-afc8-ca228b6f544f","isGoto":false},"link107":{"src_view_id":"output101","dst_view_id":"input0","src_id":"e6f8c611-cbfd-403d-bfb6-c346de68ab4b","dst_id":"2a361e47-0697-4d50-af72-bbc99a32daaa","isGoto":false}},"link_serial":116,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Redshift Unload - Example"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"author":{"value":"miqbal@snaplogic.com"}},"input":{},"settings":{"imports":{"value":[]},"error_param_table":{"value":[]},"param_table":{"value":[]},"error_pipeline":{"expression":false,"value":null}},"error":{"error_behavior":{"value":"none"}},"output":{}},"render_map":{"pan_x_num":0,"default_snaplex":"55772b8495526e3fc62ac7ea","scale_ratio":1,"detail_map":{"7a0385ad-be28-4e00-b4cf-7aaba9e1cfd2":{"grid_x_int":7,"rot_int":0,"grid_y_int":1,"rot_tail_int":0},"2a361e47-0697-4d50-af72-bbc99a32daaa":{"grid_x_int":2,"rot_int":0,"grid_y_int":1,"rot_tail_int":0},"915ad211-f631-4c89-84bd-867878bc5df3":{"grid_x_int":4,"rot_int":0,"grid_y_int":1,"rot_tail_int":0},"55c02f53-a117-4021-964d-863c2ad11642":{"grid_x_int":5,"rot_int":0,"grid_y_int":1,"rot_tail_int":0},"e6f8c611-cbfd-403d-bfb6-c346de68ab4b":{"grid_x_int":1,"rot_int":0,"grid_y_int":1,"rot_tail_int":0},"391a3a97-12e7-499c-b2cf-2236fe343d57":{"grid_x_int":6,"grid_y_int":1,"rot_tail_int":0,"output":{},"input":{},"rot_int":0},"573d222c-a94a-45d0-afc8-ca228b6f544f":{"grid_x_int":3,"rot_int":0,"grid_y_int":1,"rot_tail_int":0}},"pan_y_num":0},"snap_map":{"7a0385ad-be28-4e00-b4cf-7aaba9e1cfd2":{"class_fqid":"com-snaplogic-snaps-binary-write_3-MULTIPLE4946","class_id":"com-snaplogic-snaps-binary-write","class_version":3,"instance_fqid":"7a0385ad-be28-4e00-b4cf-7aaba9e1cfd2_2","instance_id":"7a0385ad-be28-4e00-b4cf-7aaba9e1cfd2","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"File Writer"}},"view_serial":100,"account":{"account_ref":{"expression":false,"value":{}}},"settings":{"createDir":{"value":false},"retries":{"value":0},"flushIntervalKb":{"value":-1},"writeHeader":{"value":false},"executable_during_suggest":{"value":false},"filename":{"expression":false,"value":"test.json"},"writeEmptyFile":{"value":false},"UserPermissionsKey":{"value":[]},"validate":{"value":false},"fileAction":{"value":"OVERWRITE"}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"input":{"input0":{"view_type":{"value":"binary"},"label":{"value":"input0"}}}},"class_build_tag":"MULTIPLE4946"},"2a361e47-0697-4d50-af72-bbc99a32daaa":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-transform4938","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"2a361e47-0697-4d50-af72-bbc99a32daaa_5","instance_id":"2a361e47-0697-4d50-af72-bbc99a32daaa","instance_version":5,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Extract URLs"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"transformations":{"value":{"mappingTable":{"value":[{"expression":{"expression":true,"value":"jsonPath($, \"$entries[*]\")"},"targetPath":{"value":"$filename"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"transform4938"},"915ad211-f631-4c89-84bd-867878bc5df3":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-transform4938","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"915ad211-f631-4c89-84bd-867878bc5df3_6","instance_id":"915ad211-f631-4c89-84bd-867878bc5df3","instance_version":6,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Strip s3://"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"transformations":{"value":{"mappingTable":{"value":[{"expression":{"expression":true,"value":"$url.substring(6)"},"targetPath":{"value":"$filename"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"transform4938"},"55c02f53-a117-4021-964d-863c2ad11642":{"class_fqid":"com-snaplogic-snaps-redshift-s3upsert_2-MULTIPLE4935","class_id":"com-snaplogic-snaps-redshift-s3upsert","class_version":2,"instance_fqid":"55c02f53-a117-4021-964d-863c2ad11642_3","instance_id":"55c02f53-a117-4021-964d-863c2ad11642","instance_version":3,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Redshift - S3 Upsert"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"2c323b49-cfd2-4a66-9969-ee0c21a0abd4"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-redshiftdatabaseaccount"},"label":{"expression":false,"value":"Redshift_Account_QA"}}}},"settings":{"encryptType":{"value":"None"},"maxError":{"value":100},"truncateColumns":{"value":false},"truncate":{"value":true},"loadEmptyStrings":{"value":false},"delimiter":{"value":"|"},"tableName":{"expression":false,"value":"\"snappod\".\"redshift_perf_test1_bgiles\""},"fileType":{"value":"CSV"},"invalidChars":{"value":true},"compressionFormat":{"value":"Uncompressed"},"executable_during_suggest":{"value":false},"kmsKey":{"expression":false,"value":null},"vacuumType":{"value":"NONE"},"ignoreHeader":{"value":0},"iamRole":{"value":false},"columnList":{"value":[{"columns":{"expression":false,"value":"id"}},{"columns":{"expression":false,"value":"named_account_c"}}]},"additionalOptions":{"value":null},"schemaName":{"expression":false,"value":"\"snappod\""},"updateStats":{"value":false},"s3FileList":{"value":[{"s3File":{"expression":true,"value":"$filename"}}]},"vacuumThreshold":{"value":null}},"output":{"output101":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"input":{"inputRows":{"label":{"value":"rows"},"view_type":{"value":"document"}}}},"class_build_tag":"MULTIPLE4935"},"e6f8c611-cbfd-403d-bfb6-c346de68ab4b":{"class_fqid":"com-snaplogic-snaps-redshift-unload_2-MULTIPLE4935","class_id":"com-snaplogic-snaps-redshift-unload","class_version":2,"instance_fqid":"e6f8c611-cbfd-403d-bfb6-c346de68ab4b_5","instance_id":"e6f8c611-cbfd-403d-bfb6-c346de68ab4b","instance_version":5,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Redshift - Unload"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"2c323b49-cfd2-4a66-9969-ee0c21a0abd4"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-redshiftdatabaseaccount"},"label":{"expression":false,"value":"Redshift_Account_QA"}}}},"settings":{"encryptType":{"value":"Client-Side Master Key"},"nullAs":{"expression":false,"value":"\\N"},"masterSymmetricKey":{"value":"*********"},"allowOverwrite":{"value":true},"delimiter":{"expression":false,"value":"|"},"addQuotes":{"value":false},"s3FilePrefix":{"expression":false,"value":"upload_doc_example_"},"fixedWidth":{"expression":false,"value":null},"kmsKey":{"value":null},"iamRole":{"value":false},"escape":{"value":true},"gzip":{"value":false},"manifest":{"value":false},"parallel":{"value":true},"selectQuery":{"expression":false,"value":"SELECT * FROM \"snappod\".\"redshift_perf_test1\""}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output101":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"MULTIPLE4935"},"391a3a97-12e7-499c-b2cf-2236fe343d57":{"class_fqid":"com-snaplogic-snaps-transform-jsonformatter_2-MULTIPLE4951","class_id":"com-snaplogic-snaps-transform-jsonformatter","class_version":2,"instance_fqid":"391a3a97-12e7-499c-b2cf-2236fe343d57_1","instance_id":"391a3a97-12e7-499c-b2cf-2236fe343d57","instance_version":1,"property_map":{"info":{"label":{"value":"JSON Formatter"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"prettyPrint":{"value":false},"contentPath":{"value":"$"},"jsonLines":{"value":false},"ignoreEmptyStream":{"value":false},"header":{"value":[{"expression":{"expression":true,"value":""}}]},"formatSingleDocument":{"value":false}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"binary"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"binary"}}}},"class_build_tag":"MULTIPLE4951"},"573d222c-a94a-45d0-afc8-ca228b6f544f":{"class_fqid":"com-snaplogic-snaps-transform-jsonsplitter_1-transform4938","class_id":"com-snaplogic-snaps-transform-jsonsplitter","class_version":1,"instance_fqid":"573d222c-a94a-45d0-afc8-ca228b6f544f_4","instance_id":"573d222c-a94a-45d0-afc8-ca228b6f544f","instance_version":4,"property_map":{"info":{"notes":{"value":null},"label":{"value":"JSON Splitter"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"nullSafeAccess":{"value":false},"includeParents":{"value":false},"includePaths":{"value":[]},"path":{"value":"$filename[*]"}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"transform4938"}},"path_id":"/QA/projects/Iqbal Syed","path_snode":"59cb753095526e0bf2f6f129"}