{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"5f19912c0755b70b780eadf4","instance_id":"ae35e3f2-2043-4c07-a9c1-8b3453b02e68","instance_version":2,"link_map":{},"link_serial":100,"property_map":{"info":{"notes":{"value":null},"author":{"value":"avedam@snaplogic.com"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"label":{"value":"PostgreSQL_Execute_JOIN_Command_Pipeline"}},"input":{"0df27664-f75d-407f-83f1-38beb77a4b32_input101":{"view_type":{"value":"document"},"label":{"value":"PostgreSQL - Execute - input0"}}},"settings":{"imports":{"value":[]},"error_pipeline":{"expression":false,"value":null},"error_param_table":{"value":[]},"param_table":{"value":[]},"suspendable":{"value":false}},"error":{"error_behavior":{"value":"none"}},"output":{"0df27664-f75d-407f-83f1-38beb77a4b32_output102":{"view_type":{"value":"document"},"label":{"value":"PostgreSQL - Execute - output0"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"5e5fa5a99e044616a48ecb62","scale_ratio":1,"detail_map":{"0df27664-f75d-407f-83f1-38beb77a4b32":{"grid_x_int":2,"index":null,"recommendation_id":null,"source":"","grid_y_int":1,"rot_tail_int":0,"rot_int":0}},"pan_y_num":0},"snap_map":{"0df27664-f75d-407f-83f1-38beb77a4b32":{"class_fqid":"com-snaplogic-snaps-postgres-execute_1-postgres3360","class_id":"com-snaplogic-snaps-postgres-execute","class_version":1,"instance_fqid":"0df27664-f75d-407f-83f1-38beb77a4b32_2","instance_id":"0df27664-f75d-407f-83f1-38beb77a4b32","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"PostgreSQL - Execute"}},"view_serial":102,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"postgresql server"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-postgresdatabaseaccount"},"ref_id":{"expression":false,"value":"f85816fd-8d3f-47c7-80cd-8ecda52110b0"}}}},"settings":{"autoCommit":{"value":"Use account setting"},"execution_mode":{"value":"Validate & Execute"},"maxRetryProp":{"expression":false,"value":0},"passThrough":{"value":false},"executable_during_suggest":{"value":true},"sqlStatement":{"expression":false,"value":"select * from snapteam1.AVemployees e\nleft outer join snapteam1.AVempsalary av on e.employee_id = av.employee_id"},"ignoreEmptyResult":{"value":false},"retryIntervalProp":{"expression":false,"value":1}},"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":"postgres3360"}},"path_id":"/QA/qa_diagnostic_space/db_diagnostic","path_snode":"5d03372348bd89001d8f7065","target_runtime":"standard"}