{"class_fqid":"com-snaplogic-pipeline_8","snode_id":"5a01840795526e7751d5c4ed","instance_id":"fa4931fc-7db3-403d-8926-c954b9ecfb8b","instance_version":29,"link_map":{"link102":{"src_view_id":"output101","dst_view_id":"inputRows","src_id":"385151c7-6b13-44b5-83ff-da49ba40c806","dst_id":"99072674-a00e-44c0-ae7e-2bc52599257e","isGoto":false},"link100":{"src_view_id":"output0","dst_view_id":"inputRows","src_id":"dd37fa9e-69e6-437f-9a2d-0123dfea5680","dst_id":"385151c7-6b13-44b5-83ff-da49ba40c806","isGoto":false},"link101":{"src_view_id":"output0","dst_view_id":"input0","src_id":"ffa18b94-f700-4428-a80e-91b4e25e32cc","dst_id":"dd37fa9e-69e6-437f-9a2d-0123dfea5680","isGoto":false}},"link_serial":107,"property_map":{"info":{"notes":{"value":null},"author":{"value":"tchunduri@snaplogic.com"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"label":{"value":"usecase-redshift"}},"input":{},"settings":{"imports":{"value":[]},"error_param_table":{"value":[]},"error_pipeline":{"expression":false,"value":null},"param_table":{"value":[]}},"error":{"error_behavior":{"value":"none"},"99072674-a00e-44c0-ae7e-2bc52599257e_error0":{"label":{"value":"Redshift - Bulk Load - error0"},"view_type":{"value":"document"}}},"output":{"99072674-a00e-44c0-ae7e-2bc52599257e_output101":{"view_type":{"value":"document"},"label":{"value":"Redshift - Bulk Load - output0"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"5570a15795526e3fc5fa7d1e","scale_ratio":1,"detail_map":{"ffa18b94-f700-4428-a80e-91b4e25e32cc":{"grid_x_int":4,"rot_int":0,"grid_y_int":2,"rot_tail_int":0},"dd37fa9e-69e6-437f-9a2d-0123dfea5680":{"grid_x_int":5,"grid_y_int":2,"rot_tail_int":0,"output":{},"input":{},"rot_int":0},"385151c7-6b13-44b5-83ff-da49ba40c806":{"grid_x_int":6,"rot_int":0,"grid_y_int":2,"rot_tail_int":0},"99072674-a00e-44c0-ae7e-2bc52599257e":{"grid_x_int":7,"rot_int":0,"grid_y_int":2,"rot_tail_int":0,"error":{"error0":{"dx_int":0,"rot_int":0,"dy_int":-1}}}},"pan_y_num":0},"snap_map":{"ffa18b94-f700-4428-a80e-91b4e25e32cc":{"class_fqid":"com-snaplogic-snaps-binary-simpleread_1-snapsrc900","class_id":"com-snaplogic-snaps-binary-simpleread","class_version":1,"instance_fqid":"ffa18b94-f700-4428-a80e-91b4e25e32cc_1","instance_id":"ffa18b94-f700-4428-a80e-91b4e25e32cc","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"File Reader"}},"view_serial":100,"account":{"account_ref":{"expression":false,"value":{}}},"settings":{"executeDuringPreview":{"value":true},"preventURLEncoding":{"value":false},"filePath":{"expression":false,"value":"persons data.csv"}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"binary"}}}},"class_build_tag":"snapsrc900"},"dd37fa9e-69e6-437f-9a2d-0123dfea5680":{"class_fqid":"com-snaplogic-snaps-transform-csvparser_3-snapsrc900","class_id":"com-snaplogic-snaps-transform-csvparser","class_version":3,"instance_fqid":"dd37fa9e-69e6-437f-9a2d-0123dfea5680_1","instance_id":"dd37fa9e-69e6-437f-9a2d-0123dfea5680","instance_version":1,"property_map":{"info":{"label":{"value":"CSV Parser"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"binary"},"label":{"value":"input0"}}},"settings":{"escapeChar":{"value":"\\"},"quoteCharacter":{"value":"\""},"containsHeader":{"value":true},"charset":{"value":"Auto BOM detect"},"skipLines":{"value":0},"delimiter":{"value":","},"errorPolicy":{"value":"Both"},"validateHeaders":{"value":false},"ignoreEmptyData":{"value":true}},"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":"snapsrc900"},"385151c7-6b13-44b5-83ff-da49ba40c806":{"class_fqid":"com-snaplogic-snaps-mysql-insert_2-snapsrc900","class_id":"com-snaplogic-snaps-mysql-insert","class_version":2,"instance_fqid":"385151c7-6b13-44b5-83ff-da49ba40c806_8","instance_id":"385151c7-6b13-44b5-83ff-da49ba40c806","instance_version":8,"property_map":{"info":{"notes":{"value":null},"label":{"value":"MySQL - Insert"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"f880a738-ca1d-419f-a6a0-6893390667bb"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-mysqldatabaseaccount"},"label":{"expression":false,"value":"my sql dev-test.clouddev.snaplogic.com"}}}},"settings":{"duplicates":{"value":"Fail"},"schemaName":{"expression":false,"value":"`salesmysql`"},"createTable":{"value":true},"tableName":{"expression":false,"value":"`salesmysql`.`usecase`"},"executable_during_suggest":{"value":true}},"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":"snapsrc900"},"99072674-a00e-44c0-ae7e-2bc52599257e":{"class_fqid":"com-snaplogic-snaps-redshift-bulkload_1-snapsrc900","class_id":"com-snaplogic-snaps-redshift-bulkload","class_version":1,"instance_fqid":"99072674-a00e-44c0-ae7e-2bc52599257e_6","instance_id":"99072674-a00e-44c0-ae7e-2bc52599257e","instance_version":6,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Redshift - Bulk Load"}},"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"}}}},"input":{"inputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}},"settings":{"maxError":{"value":100},"disableCompression":{"value":false},"truncateColumns":{"value":true},"truncate":{"value":false},"createTable":{"value":true},"invalidChars":{"value":true},"tableName":{"expression":false,"value":"\"public\".\"usecase\""},"executable_during_suggest":{"value":true},"vacuumType":{"value":"NONE"},"loadEmptyStrings":{"value":false},"parallelism":{"value":1},"ServerSideEncryption":{"value":false},"additionalOptions":{"value":null},"schemaName":{"expression":false,"value":"\"public\""},"updateStats":{"value":false},"IAM_Role":{"value":false},"vacuumThreshold":{"value":null}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"continue"}},"output":{"output101":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"snapsrc900"}},"path_id":"/QA/shared","path_snode":"5566505895526e3fc7775b03"}