{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"695f66bbc3566b0bf7f6585d","instance_id":"365394b0-f1ba-4313-af99-c5ee8237b6fa","instance_version":45,"link_map":{"link101":{"dst_id":"1e233d9d-7e12-4ee1-aab5-b03a88c95cf5","dst_view_id":"input101","src_id":"5f208c9d-65a5-4487-9a87-f1ac6bfc0805","src_view_id":"output101","isGoto":false},"link102":{"dst_id":"5f208c9d-65a5-4487-9a87-f1ac6bfc0805","dst_view_id":"inputRows","src_id":"673654ed-4372-4deb-8505-2b3359ee0938","src_view_id":"output0","isGoto":false},"link103":{"dst_id":"673654ed-4372-4deb-8505-2b3359ee0938","dst_view_id":"input101","src_id":"42c6ce21-329c-4d42-9929-3568b341052e","src_view_id":"out","isGoto":false}},"link_serial":104,"property_map":{"info":{"label":{"value":"POstgreSQL_BulkUpsert_Example"},"author":{"value":"yrachabathuni@snaplogic.com"},"pipeline_doc_uri":{"value":null},"notes":{"value":null},"purpose":{"value":null}},"error":{"error_behavior":{"value":"none"}},"settings":{"suspendable":{"value":false},"error_pipeline":{"value":null,"expression":false},"error_param_table":{"value":[]},"param_table":{"value":[]},"imports":{"value":[]}},"input":{"42c6ce21-329c-4d42-9929-3568b341052e_in":{"view_type":{"value":"document"},"label":{"value":"PostgreSQL - Multi Execute - Input view"}}},"output":{"1e233d9d-7e12-4ee1-aab5-b03a88c95cf5_outputRows":{"view_type":{"value":"document"},"label":{"value":"PostgreSQL - Select - rows"}}}},"render_map":{"scale_ratio":1,"pan_x_num":0,"pan_y_num":0,"default_snaplex":"650d2c07bf87226317660e4f","detail_map":{"42c6ce21-329c-4d42-9929-3568b341052e":{"grid_x_int":2,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0},"5f208c9d-65a5-4487-9a87-f1ac6bfc0805":{"grid_x_int":4,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0},"1e233d9d-7e12-4ee1-aab5-b03a88c95cf5":{"grid_x_int":5,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0},"673654ed-4372-4deb-8505-2b3359ee0938":{"grid_x_int":3,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0}}},"snap_map":{"42c6ce21-329c-4d42-9929-3568b341052e":{"class_fqid":"com-snaplogic-snaps-postgres-multiexecute_1-PR33495","class_id":"com-snaplogic-snaps-postgres-multiexecute","class_version":1,"instance_fqid":"42c6ce21-329c-4d42-9929-3568b341052e_4","instance_id":"42c6ce21-329c-4d42-9929-3568b341052e","instance_version":4,"property_map":{"info":{"label":{"value":"PostgreSQL - Multi Execute"},"notes":{}},"input":{"in":{"view_type":{"value":"document"},"label":{"value":"Input view"}}},"output":{"out":{"view_type":{"value":"document"},"label":{"value":"Output view"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"},"executable_during_suggest":{"value":false},"sqlStatements":{"value":[{"sqlStatement":{"value":"DROP TABLE IF EXISTS target_table;\n","expression":false}},{"sqlStatement":{"value":"CREATE TABLE target_table (\n    id INT ,\n    name VARCHAR(100),\n    quantity INT,\n    price NUMERIC(10,2)\n);","expression":false}},{"sqlStatement":{"value":"INSERT INTO target_table (id, name, quantity, price) VALUES\n(1, 'Apple', 30, 1.10),\n(2, 'Banana', 80, 0.70),\n(5, 'Grapes', 60, 2.00);","expression":false}}]}},"account":{"account_ref":{"value":{"label":{"value":"postgresql_v13","label":"postgresql_v13","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-postgresdatabaseaccount"},"ref_id":{"value":"5d816013-0522-4ae7-847e-035ade732649","expression":false}}}},"view_serial":100},"class_build_tag":"PR33495"},"5f208c9d-65a5-4487-9a87-f1ac6bfc0805":{"class_fqid":"com-snaplogic-snaps-postgres-bulkupsert_1-PR33495","class_id":"com-snaplogic-snaps-postgres-bulkupsert","class_version":1,"instance_fqid":"5f208c9d-65a5-4487-9a87-f1ac6bfc0805_34","instance_id":"5f208c9d-65a5-4487-9a87-f1ac6bfc0805","instance_version":34,"property_map":{"info":{"label":{"value":"PostgreSQL - Bulk Upsert"},"notes":{}},"input":{"inputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"},"executable_during_suggest":{"value":false},"schemaName":{"value":"\"public\"","expression":false},"tableName":{"value":"\"public\".\"target_table\"","expression":false},"columnList":{"value":[{"columns":{"value":"id","expression":false}}]},"deleteProp":{"value":"t.id = 5 AND s.name = 'Grapes'","expression":false},"additionalOptionsProp":{"value":[]}},"account":{"account_ref":{"value":{"label":{"value":"postgresql_v13","label":"postgresql_v13","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-postgresdatabaseaccount"},"ref_id":{"value":"5d816013-0522-4ae7-847e-035ade732649","expression":false}}}},"view_serial":101,"output":{"output101":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"PR33495"},"1e233d9d-7e12-4ee1-aab5-b03a88c95cf5":{"class_fqid":"com-snaplogic-snaps-postgres-select_1-PR33495","class_id":"com-snaplogic-snaps-postgres-select","class_version":1,"instance_fqid":"1e233d9d-7e12-4ee1-aab5-b03a88c95cf5_2","instance_id":"1e233d9d-7e12-4ee1-aab5-b03a88c95cf5","instance_version":2,"property_map":{"info":{"label":{"value":"PostgreSQL - Select"},"notes":{}},"output":{"outputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"orderBy":{"value":[]},"autoCommit":{"value":"False"},"maxRetryProp":{"value":0,"expression":false},"execution_mode":{"value":"Validate & Execute"},"matchDataTypes":{"value":false},"schemaName":{"value":"\"public\"","expression":false},"limitOffset":{"value":null,"expression":false},"retryIntervalProp":{"value":1,"expression":false},"limitRows":{"value":null,"expression":false},"passThrough":{"value":false},"whereClause":{"value":null,"expression":false},"ignoreEmptyResult":{"value":false},"tableName":{"value":"\"public\".\"target_table\"","expression":false},"fetchOutputFieldsInSchema":{"value":false},"outputFields":{"value":[]},"stagingMode":{"value":"In memory"}},"account":{"account_ref":{"value":{"label":{"value":"postgresql_v13","label":"postgresql_v13","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-postgresdatabaseaccount"},"ref_id":{"value":"5d816013-0522-4ae7-847e-035ade732649","expression":false}}}},"view_serial":101,"input":{"input101":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"PR33495"},"673654ed-4372-4deb-8505-2b3359ee0938":{"class_fqid":"com-snaplogic-snaps-transform-csvgenerator_1-main33142","class_id":"com-snaplogic-snaps-transform-csvgenerator","class_version":1,"instance_fqid":"673654ed-4372-4deb-8505-2b3359ee0938_3","instance_id":"673654ed-4372-4deb-8505-2b3359ee0938","instance_version":3,"property_map":{"info":{"label":{"value":"CSV Generator"},"notes":{}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"},"editable_content":{"value":"id,name,quantity,price\n1,Apple,50,1.20\n2,Banana,100,0.80\n3,Orange,75,1.00\n4,Mango,20,2.50\n5,Grapes,60,2.00\n"}},"view_serial":101,"input":{"input101":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"main33142"}},"path_id":"/snap_automation/qa_diagnostic_space/db_diagnostic","path_snode":"60373e01db185afd23668f17"}