{"class_fqid":"com-snaplogic-pipeline_8","snode_id":"584e7b8d95526e3f8c688d17","instance_id":"23fae688-1e3a-43c8-b7d0-07dbe311ba4d","instance_version":22,"link_map":{"link105":{"src_view_id":"output101","dst_view_id":"input101","src_id":"be8bcd61-5142-4c04-8505-5c73127f7ef6","dst_id":"642726b0-6f1c-465a-bbff-516e1e6e3e3c","isGoto":false},"link100":{"src_view_id":"output0","dst_view_id":"input102","src_id":"bf09c3a9-24eb-480c-8efd-867d0e93e7cb","dst_id":"be8bcd61-5142-4c04-8505-5c73127f7ef6","isGoto":false}},"link_serial":106,"property_map":{"info":{"notes":{"value":null},"label":{"value":"RedShift_Multi_Execute_Input_Parameter_Test"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"author":{"value":"vspridhvi@snaplogic.com"}},"input":{},"settings":{"param_table":{"value":[{"capture":{"value":false},"key":{"value":"empid"},"value":{"value":"111"}},{"capture":{"value":false},"key":{"value":"ename"},"value":{"value":"sunil"}},{"capture":{"value":false},"key":{"value":"salary"},"value":{"value":"99000"}}]}},"error":{"error_behavior":{"value":"none"}},"output":{"642726b0-6f1c-465a-bbff-516e1e6e3e3c_outputRows":{"view_type":{"value":"document"},"label":{"value":"Redshift - Select - rows"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"56bc58e395526e6072bd3bef","scale_ratio":1,"detail_map":{"be8bcd61-5142-4c04-8505-5c73127f7ef6":{"grid_x_int":3,"rot_int":0,"grid_y_int":2,"rot_tail_int":0},"bf09c3a9-24eb-480c-8efd-867d0e93e7cb":{"grid_x_int":2,"rot_int":0,"grid_y_int":2,"rot_tail_int":0},"642726b0-6f1c-465a-bbff-516e1e6e3e3c":{"grid_x_int":4,"rot_int":0,"grid_y_int":2,"rot_tail_int":0}},"pan_y_num":0},"snap_map":{"be8bcd61-5142-4c04-8505-5c73127f7ef6":{"class_fqid":"com-snaplogic-snaps-redshift-multiexecute_1-redshift2220","class_id":"com-snaplogic-snaps-redshift-multiexecute","class_version":1,"instance_fqid":"be8bcd61-5142-4c04-8505-5c73127f7ef6_9","instance_id":"be8bcd61-5142-4c04-8505-5c73127f7ef6","instance_version":9,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Redshift - Multi Execute"}},"view_serial":102,"account":{"account_ref":{"value":{"label":{"value":"RS - prasanna"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-redshiftdatabaseaccount"},"ref_id":{"value":"c3b71755-bb2a-4c2d-86b5-0bde531b93df"}}}},"settings":{"multiExecuteTable":{"value":[{"sqlStatement":{"expression":false,"value":"truncate table emp_rs;"}},{"sqlStatement":{"expression":true,"value":"\"insert into emp_rs (empid,ename,salary)\nvalues (\"+$empid+\",'\"+$ename+\"',\"+$salary+\")\""}},{"sqlStatement":{"expression":true,"value":"\"insert into emp_rs (empid,ename,salary)\nvalues (\"+_empid+\",'\"+_ename+\"',\"+_salary+\")\""}},{"sqlStatement":{"expression":true,"value":"\"insert into \"+$table+\" (empid,ename,\"+$loc+\")\nvalues (\"+$empid+\",'\"+$ename+\"',\"+$locid+\")\""}},{"sqlStatement":{"expression":false,"value":"insert into emp_rs (empid,ename,salary,deptid,locid)\nvalues (100,'sudheer',80000,1,1)"}}]},"executable_during_suggest":{"value":true}},"output":{"output101":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"input":{"input102":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"redshift2220"},"bf09c3a9-24eb-480c-8efd-867d0e93e7cb":{"class_fqid":"com-snaplogic-snaps-transform-jsongenerator_2-ALL2181","class_id":"com-snaplogic-snaps-transform-jsongenerator","class_version":2,"instance_fqid":"bf09c3a9-24eb-480c-8efd-867d0e93e7cb_2","instance_id":"bf09c3a9-24eb-480c-8efd-867d0e93e7cb","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"JSON Generator"}},"view_serial":100,"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}},"settings":{"editable_content":{"value":"## Enter your JSON-encoded data in this space.  Note that this text is\n## treated as an Apache Velocity template, so you can substitute values\n## from input documents or the pipeline parameters.  See the following\n## URL for more information about Velocity:\n##   https://velocity.apache.org/engine/devel/user-guide.html\n\n[\n    {\n       \"empid\" : 1, \"ename\" : 'harish', \"salary\" : 99900, \n       \"eid\" : 11, \"name\" : \"harish1\", \"sal\" : 99999,\n       \"table\" : \"emp_rs\", \"loc\" : \"locid\", \"locid\" : 5\n    }\n]\n\n\n## Tips:\n##  * The sample data above will generate a single empty document, uncomment\n##    the line in the middle to include the sample fields.  Adding more\n##    objects to the root array will cause the snap to generate more\n##    than one document.\n##  * Pipeline parameters can be referenced by prefixing the parameter\n##    name with an underscore, like so:\n##      ${_pipelineParamName}\n##  * If you add an input view to the snap, this template will be\n##    evaluated for each input document.\n##  * Fields in the input documents can be referenced by prefixing them\n##    with a dollar-sign ($), like so:\n##      $parent.child[0].value\n##  * Any referenced document values and pipeline parameters will\n##    automatically be JSON-encoded when they are inserted into the final\n##    JSON document.  You should not have to worry about escaping values\n##    yourself.\n##  * If you are having troubles getting a template to produce valid JSON,\n##    you can add an error view to the snap to get a document that\n##    contains the output of the template evaluation."},"arrayElementsAsDocuments":{"value":true}}},"class_build_tag":"ALL2181"},"642726b0-6f1c-465a-bbff-516e1e6e3e3c":{"class_fqid":"com-snaplogic-snaps-redshift-select_3-redshift2222","class_id":"com-snaplogic-snaps-redshift-select","class_version":3,"instance_fqid":"642726b0-6f1c-465a-bbff-516e1e6e3e3c_3","instance_id":"642726b0-6f1c-465a-bbff-516e1e6e3e3c","instance_version":3,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Redshift - Select"}},"view_serial":101,"account":{"account_ref":{"value":{"ref_id":{"value":"c3b71755-bb2a-4c2d-86b5-0bde531b93df"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-redshiftdatabaseaccount"},"label":{"value":"RS - prasanna"}}}},"input":{"input101":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"orderBy":{"value":[{"columns":{"expression":false,"value":"salary"}}]},"limitRows":{"expression":false,"value":null},"passThrough":{"value":true},"tableName":{"expression":false,"value":"\"public\".\"emp_rs\""},"ignoreEmptyResult":{"value":false},"outputFields":{"value":[]},"whereClause":{"expression":false,"value":null},"schemaName":{"expression":false,"value":"public"},"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"}}}},"class_build_tag":"redshift2222"}},"path_id":"/QA/projects/diagnostic","path_snode":"540e8026ec77034feacff4eb"}