{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"65eefac7e5a9b00e2e046181","instance_id":"bc4c515c-a61a-4059-826b-753ea92fb451","instance_version":6,"link_map":{"link101":{"dst_id":"e9258c4b-905d-456e-8459-8e40ab3ab15f","dst_view_id":"input101","src_id":"2ea42440-9bbe-4c26-884b-c8ff78761f00","src_view_id":"output0","isGoto":false}},"link_serial":102,"property_map":{"info":{"label":{"value":"SQL Server Select Example"},"author":{"value":"sreddi@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":{"2ea42440-9bbe-4c26-884b-c8ff78761f00_input0":{"view_type":{"value":"document"},"label":{"value":"Mapper - input0"}}},"output":{"e9258c4b-905d-456e-8459-8e40ab3ab15f_outputRows":{"view_type":{"value":"document"},"label":{"value":"SQL Server - Select - rows"}}}},"render_map":{"scale_ratio":1,"pan_x_num":0,"pan_y_num":0,"default_snaplex":"652527decbdaf1adccada754","detail_map":{"2ea42440-9bbe-4c26-884b-c8ff78761f00":{"grid_x_int":3,"grid_y_int":1,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0},"e9258c4b-905d-456e-8459-8e40ab3ab15f":{"grid_x_int":4,"grid_y_int":1,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0,"input":{},"output":{},"error":{}}}},"snap_map":{"2ea42440-9bbe-4c26-884b-c8ff78761f00":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-PR25347","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"2ea42440-9bbe-4c26-884b-c8ff78761f00_5","instance_id":"2ea42440-9bbe-4c26-884b-c8ff78761f00","instance_version":5,"property_map":{"info":{"label":{"value":"Mapper"},"notes":{}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"sqlStatement":{"value":null,"expression":false},"queryType":{"value":"Auto","expression":false},"autoCommit":{"value":"Use account setting"},"maxRetryProp":{"value":0,"expression":false},"execution_mode":{"value":"Validate & Execute"},"transformations":{"value":{"mappingRoot":{"value":"$"},"mappingTable":{"value":[{"expression":{"value":"Amit","expression":false},"targetPath":{"value":"$Emp_Name"}}]}}},"retryIntervalProp":{"value":1,"expression":false},"passThrough":{"value":false},"nullSafeAccess":{"value":false},"ignoreEmptyResult":{"value":false}},"view_serial":100},"class_build_tag":"PR25347"},"e9258c4b-905d-456e-8459-8e40ab3ab15f":{"class_fqid":"com-snaplogic-snaps-sqlserver-select_3-develop6729","class_id":"com-snaplogic-snaps-sqlserver-select","class_version":3,"instance_fqid":"e9258c4b-905d-456e-8459-8e40ab3ab15f_1","instance_id":"e9258c4b-905d-456e-8459-8e40ab3ab15f","instance_version":1,"property_map":{"info":{"label":{"value":"SQL Server - Select"},"notes":{}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"label":{"value":"dg_SQL Server diagnostic account","label":"dg_SQL Server diagnostic account","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-sqlserverdatabaseaccount"},"ref_id":{"value":"68022e4f-6a22-4d6f-b2da-a81d2bc66846","expression":false}}}},"settings":{"sqlStatement":{"value":null,"expression":false},"queryType":{"value":"Auto","expression":false},"queryHints":{"value":null,"expression":false},"orderBy":{"value":[]},"autoCommit":{"value":"False"},"maxRetryProp":{"expression":false,"value":0},"execution_mode":{"value":"Validate & Execute"},"matchDataTypes":{"value":false},"schemaName":{"expression":false,"value":"\"dbo\""},"limitOffset":{"expression":false,"value":null},"retryIntervalProp":{"expression":false,"value":1},"limitRows":{"expression":false,"value":"1"},"passThrough":{"value":false},"unique_identifier_column_option":{"value":"Convert to lower case (default)"},"whereClause":{"expression":false,"value":"\"Emp_Name\" = $Emp_Name"},"ignoreEmptyResult":{"value":false},"tableName":{"expression":false,"value":"\"dbo\".\"Employee_Demo\""},"fetchOutputFieldsInSchema":{"value":false},"outputFields":{"value":[]},"stagingMode":{"value":"In memory"},"rowversion":{"value":false}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"outputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}},"input":{"input101":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"develop6729"}},"path_id":"/QA/shared_assets/database","path_snode":"642b236bcda1f58412cf4672","target_runtime":"standard"}