{"class_fqid":"com-snaplogic-pipeline_8","snode_id":"59a5434d95526e0a210a75e5","instance_id":"3477f863-d237-49a4-aa34-339f70998300","instance_version":24,"link_map":{"link106":{"src_view_id":"output102","dst_view_id":"input0","src_id":"99d40e31-f2ae-44eb-b2e8-36b134f99e85","dst_id":"7f47c98f-e284-4c85-a87c-872cca70846c","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":107,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Redshift Lookup_Advanced Use Case"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"author":{"value":"atayi@snaplogic.com"}},"input":{},"settings":{"param_table":{"value":[]},"imports":{"value":[]}},"error":{"error_behavior":{"value":"none"}},"output":{"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":{"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}}},"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}}},"7f47c98f-e284-4c85-a87c-872cca70846c":{"grid_x_int":4,"rot_int":0,"grid_y_int":1,"rot_tail_int":0}},"pan_y_num":0},"snap_map":{"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_2","instance_id":"8e3c59ba-f44e-49d3-bc44-9232c00e9759","instance_version":2,"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\""},"ignoreEmptyResult":{"value":false},"outputFields":{"value":[]},"whereClause":{"expression":false,"value":null},"schemaName":{"expression":false,"value":"\"TECTONIC\""},"limitOffset":{"expression":false,"value":null}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"outputRows":{"label":{"value":"rows"},"view_type":{"value":"document"}},"output101":{"view_type":{"value":"document"},"label":{"value":"output1"}}}},"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_3","instance_id":"99d40e31-f2ae-44eb-b2e8-36b134f99e85","instance_version":3,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Redshift - Insert"}},"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":{"schemaName":{"expression":false,"value":"\"snappod\""},"createTable":{"value":true},"tableName":{"expression":false,"value":"\"snappod\".\"colours_rslktest\""},"executable_during_suggest":{"value":true}},"output":{"output102":{"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"}},"input101":{"view_type":{"value":"document"},"label":{"value":"input1"}}}},"class_build_tag":"c430"},"7f47c98f-e284-4c85-a87c-872cca70846c":{"class_fqid":"com-snaplogic-snaps-redshift-lookup_3-c430","class_id":"com-snaplogic-snaps-redshift-lookup","class_version":3,"instance_fqid":"7f47c98f-e284-4c85-a87c-872cca70846c_8","instance_id":"7f47c98f-e284-4c85-a87c-872cca70846c","instance_version":8,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Redshift - Lookup"}},"view_serial":100,"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":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"lookupConditions":{"value":[{"column":{"expression":false,"value":"color"},"value":{"expression":false,"value":"black"}}]},"passThrough":{"value":true},"schemaName":{"expression":false,"value":"\"snappod\""},"outputFields":{"value":[]},"tableName":{"expression":false,"value":"\"snappod\".\"colours_rslktest\""}},"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":"c430"}},"path_id":"/QA/projects/Aparna Tayi","path_snode":"57dfe69295526e323448ebe3"}