{"_dirty_type":"upd","class_fqid":"com-snaplogic-pipeline_8","snode_id":"59a5434d95526e0a210a75e5","instance_id":"3477f863-d237-49a4-aa34-339f70998300","instance_version":16,"link_map":{"link104":{"src_view_id":"output102","dst_view_id":"input101","src_id":"99d40e31-f2ae-44eb-b2e8-36b134f99e85","dst_id":"a207e797-9d1e-4cf1-a741-f07efdcd1eef","isGoto":false},"link100":{"src_view_id":"outputRows","dst_view_id":"inputRows","src_id":"8e3c59ba-f44e-49d3-bc44-9232c00e9759","dst_id":"99d40e31-f2ae-44eb-b2e8-36b134f99e85","isGoto":false},"link101":{"src_view_id":"output101","dst_view_id":"input101","src_id":"8e3c59ba-f44e-49d3-bc44-9232c00e9759","dst_id":"99d40e31-f2ae-44eb-b2e8-36b134f99e85","isGoto":false}},"link_serial":105,"property_map":{"info":{"notes":{"value":null},"label":{"value":"RedshiftInsert Adv Use case"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"author":{"value":"atayi@snaplogic.com"}},"input":{"7f47c98f-e284-4c85-a87c-872cca70846c_input0":{"label":{"value":"Redshift - Lookup - input0"},"view_type":{"value":"document"}}},"settings":{"param_table":{"value":[]},"imports":{"value":[]}},"error":{"error_behavior":{"value":"none"}},"output":{"a207e797-9d1e-4cf1-a741-f07efdcd1eef_output102":{"label":{"value":"Redshift - Execute - output0"},"view_type":{"value":"document"}},"7f47c98f-e284-4c85-a87c-872cca70846c_output0":{"label":{"value":"Redshift - Lookup - output0"},"view_type":{"value":"document"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"5710216095526e484d534a97","scale_ratio":1,"detail_map":{"99d40e31-f2ae-44eb-b2e8-36b134f99e85":{"grid_x_int":3,"rot_int":0,"grid_y_int":1,"rot_tail_int":0,"input":{"input101":{"dx_int":0,"rot_int":0,"dy_int":1}}},"8e3c59ba-f44e-49d3-bc44-9232c00e9759":{"grid_x_int":2,"rot_int":0,"grid_y_int":1,"rot_tail_int":0,"output":{"output101":{"dx_int":0,"rot_int":0,"dy_int":1}}},"a207e797-9d1e-4cf1-a741-f07efdcd1eef":{"grid_x_int":4,"rot_int":0,"grid_y_int":1,"rot_tail_int":0}},"pan_y_num":0},"snap_map":{"a207e797-9d1e-4cf1-a741-f07efdcd1eef":{"class_fqid":"com-snaplogic-snaps-redshift-execute_1-c430","class_id":"com-snaplogic-snaps-redshift-execute","class_version":1,"instance_fqid":"a207e797-9d1e-4cf1-a741-f07efdcd1eef_3","instance_id":"a207e797-9d1e-4cf1-a741-f07efdcd1eef","instance_version":3,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Redshift - Execute"}},"view_serial":102,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"b1aa6b7a-b67b-4357-9caa-3a3e71787bfb"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-redshiftdatabaseaccount"},"label":{"expression":false,"value":"Syeds RedShift account"}}}},"settings":{"autoCommit":{"value":"Use account setting"},"passThrough":{"value":true},"ignoreEmptyResult":{"value":false},"executable_during_suggest":{"value":true},"sqlStatement":{"expression":false,"value":"select * from \"snappod\".\"Colours_New\""}},"output":{"output102":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"input":{"input101":{"view_type":{"value":"document"},"label":{"value":"input0"}}}},"class_build_tag":"c430"},"8e3c59ba-f44e-49d3-bc44-9232c00e9759":{"class_fqid":"com-snaplogic-snaps-oracle-select_3-c430","class_id":"com-snaplogic-snaps-oracle-select","class_version":3,"instance_fqid":"8e3c59ba-f44e-49d3-bc44-9232c00e9759_1","instance_id":"8e3c59ba-f44e-49d3-bc44-9232c00e9759","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Oracle - Select"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"Oracle test_db"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-oraclethindatabaseaccount"},"ref_id":{"expression":false,"value":"aee8618e-8ccd-40b7-9acc-5baf8214bc5f"}}}},"settings":{"autoCommit":{"value":"False"},"orderBy":{"value":[]},"limitRows":{"expression":false,"value":null},"passThrough":{"value":true},"tableName":{"expression":false,"value":"\"TECTONIC\".\"COLORS_NEW\""},"outputFields":{"value":[]},"whereClause":{"expression":false,"value":null},"limitOffset":{"expression":false,"value":null},"schemaName":{"expression":false,"value":"\"TECTONIC\""},"ignoreEmptyResult":{"value":false}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"outputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}},"output101":{"label":{"value":"output1"},"view_type":{"value":"document"}}}},"class_build_tag":"c430"},"99d40e31-f2ae-44eb-b2e8-36b134f99e85":{"class_fqid":"com-snaplogic-snaps-redshift-insert_1-c430","class_id":"com-snaplogic-snaps-redshift-insert","class_version":1,"instance_fqid":"99d40e31-f2ae-44eb-b2e8-36b134f99e85_2","instance_id":"99d40e31-f2ae-44eb-b2e8-36b134f99e85","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Redshift - Insert"}},"view_serial":102,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"Syeds RedShift account"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-redshiftdatabaseaccount"},"ref_id":{"expression":false,"value":"b1aa6b7a-b67b-4357-9caa-3a3e71787bfb"}}}},"input":{"inputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}},"input101":{"label":{"value":"input1"},"view_type":{"value":"document"}}},"settings":{"schemaName":{"expression":false,"value":"\"snappod\""},"createTable":{"value":true},"tableName":{"expression":false,"value":"Colours_New"},"executable_during_suggest":{"value":true}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output102":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"c430"}},"path_id":"/QA/projects/Aparna Tayi","path_snode":"57dfe69295526e323448ebe3"}