{"class_fqid":"com-snaplogic-pipeline_8","snode_id":"5976f18a95526e640bfc8b69","instance_id":"041c5c7f-d5ea-4c63-8435-61210c388f24","instance_version":24,"link_map":{"link106":{"src_view_id":"output101","dst_view_id":"input0","src_id":"cdd652a0-71d2-49f4-bb13-84fe9ab82b82","dst_id":"3614d352-664a-4be4-8715-03c12027e850","isGoto":false},"link107":{"src_view_id":"output101","dst_view_id":"input101","src_id":"bbc62bb1-e5a8-4df7-8a31-1356ff736888","dst_id":"7aafedd2-375c-4079-aa6b-076650ef1049","isGoto":false},"link105":{"src_view_id":"output0","dst_view_id":"input102","src_id":"3614d352-664a-4be4-8715-03c12027e850","dst_id":"23c6f982-1e13-41bb-ae73-8b0ed7cb87b8","isGoto":false},"link103":{"src_view_id":"outputRows","dst_view_id":"inputRows","src_id":"7aafedd2-375c-4079-aa6b-076650ef1049","dst_id":"cdd652a0-71d2-49f4-bb13-84fe9ab82b82","isGoto":false}},"link_serial":108,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Azure SQL Stored Procedure - Advanced Usecase"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"author":{"value":"vspridhvi@snaplogic.com"}},"input":{},"settings":{"param_table":{"value":[]},"imports":{"value":[]}},"error":{"error_behavior":{"value":"none"}},"output":{"23c6f982-1e13-41bb-ae73-8b0ed7cb87b8_output0":{"view_type":{"value":"document"},"label":{"value":"Azure SQL - Stored Procedure - Output Parameter OutputView"}},"23c6f982-1e13-41bb-ae73-8b0ed7cb87b8_output1":{"view_type":{"value":"document"},"label":{"value":"Azure SQL - Stored Procedure - Result Set Output View"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"5710216095526e484d534a97","scale_ratio":1,"detail_map":{"bbc62bb1-e5a8-4df7-8a31-1356ff736888":{"grid_x_int":2,"rot_int":0,"grid_y_int":1,"rot_tail_int":0},"cdd652a0-71d2-49f4-bb13-84fe9ab82b82":{"grid_x_int":4,"rot_int":0,"grid_y_int":1,"rot_tail_int":0},"23c6f982-1e13-41bb-ae73-8b0ed7cb87b8":{"grid_x_int":6,"rot_int":0,"grid_y_int":1,"rot_tail_int":0,"output":{"output1":{"dx_int":0,"rot_int":0,"dy_int":1}}},"3614d352-664a-4be4-8715-03c12027e850":{"grid_x_int":5,"rot_int":0,"grid_y_int":1,"rot_tail_int":0},"7aafedd2-375c-4079-aa6b-076650ef1049":{"grid_x_int":3,"rot_int":0,"grid_y_int":1,"rot_tail_int":0}},"pan_y_num":0},"snap_map":{"bbc62bb1-e5a8-4df7-8a31-1356ff736888":{"class_fqid":"com-snaplogic-snaps-azuresql-execute_1-azuresql3318","class_id":"com-snaplogic-snaps-azuresql-execute","class_version":1,"instance_fqid":"bbc62bb1-e5a8-4df7-8a31-1356ff736888_6","instance_id":"bbc62bb1-e5a8-4df7-8a31-1356ff736888","instance_version":6,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Azure SQL - Execute"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"Azure Sql Db"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-azuresqldatabaseaccount"},"ref_id":{"expression":false,"value":"ef675418-5be6-400d-98f4-e917371c1746"}}}},"settings":{"autoCommit":{"value":"Use account setting"},"passThrough":{"value":true},"ignoreEmptyResult":{"value":false},"executable_during_suggest":{"value":true},"sqlStatement":{"expression":false,"value":"truncate table employee_sp"}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output101":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"azuresql3318"},"cdd652a0-71d2-49f4-bb13-84fe9ab82b82":{"class_fqid":"com-snaplogic-snaps-azuresql-azuresqlbulkload_1-azuresql3304","class_id":"com-snaplogic-snaps-azuresql-azuresqlbulkload","class_version":1,"instance_fqid":"cdd652a0-71d2-49f4-bb13-84fe9ab82b82_6","instance_id":"cdd652a0-71d2-49f4-bb13-84fe9ab82b82","instance_version":6,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Azure SQL - Bulk Load"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"Azure SQL Active directory account"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-azuresqlactivedirectoryaccount"},"ref_id":{"expression":false,"value":"6778fe77-6347-4568-8cf8-e254ac501d74"}}}},"settings":{"batchSize":{"expression":false,"value":10000},"bulkCopyTimeout":{"expression":false,"value":60},"tableName":{"expression":false,"value":"employee_sp"},"executable_during_suggest":{"value":true},"createTable":{"value":true},"advancedProperties":{"value":[]},"schemaName":{"expression":false,"value":"dbo"}},"output":{"output101":{"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"}}}},"class_build_tag":"azuresql3304"},"23c6f982-1e13-41bb-ae73-8b0ed7cb87b8":{"class_fqid":"com-snaplogic-snaps-azuresql-storedprocedure_1-azuresql3318","class_id":"com-snaplogic-snaps-azuresql-storedprocedure","class_version":1,"instance_fqid":"23c6f982-1e13-41bb-ae73-8b0ed7cb87b8_6","instance_id":"23c6f982-1e13-41bb-ae73-8b0ed7cb87b8","instance_version":6,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Azure SQL - Stored Procedure"}},"view_serial":102,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"ef675418-5be6-400d-98f4-e917371c1746"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-azuresqldatabaseaccount"},"label":{"expression":false,"value":"Azure Sql Db"}}}},"settings":{"parameterValues":{"value":[{"parameterValue":{"expression":true,"value":"$sal"}}]},"passThrough":{"value":false},"schemaName":{"expression":false,"value":null},"storedProcedureName":{"expression":false,"value":"Emp_Select_SP"},"executable_during_suggest":{"value":true}},"output":{"output0":{"label":{"value":"Output Parameter OutputView"},"view_type":{"value":"document"}},"output1":{"label":{"value":"Result Set Output View"},"view_type":{"value":"document"}}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"input":{"input102":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"azuresql3318"},"7aafedd2-375c-4079-aa6b-076650ef1049":{"class_fqid":"com-snaplogic-snaps-sqlserver-select_3-ALL3303","class_id":"com-snaplogic-snaps-sqlserver-select","class_version":3,"instance_fqid":"7aafedd2-375c-4079-aa6b-076650ef1049_3","instance_id":"7aafedd2-375c-4079-aa6b-076650ef1049","instance_version":3,"property_map":{"info":{"notes":{"value":null},"label":{"value":"SQL Server - Select"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"SQL Server diagnostic account"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-sqlserverdatabaseaccount"},"ref_id":{"expression":false,"value":"5d05983f-330d-48c2-8c41-21a887d80d29"}}}},"input":{"input101":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"autoCommit":{"value":"Use account setting"},"orderBy":{"value":[]},"limitRows":{"expression":false,"value":null},"passThrough":{"value":true},"tableName":{"expression":false,"value":"\"dbo\".\"employee\""},"ignoreEmptyResult":{"value":false},"outputFields":{"value":[]},"whereClause":{"expression":false,"value":null},"schemaName":{"expression":false,"value":null},"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":"ALL3303"},"3614d352-664a-4be4-8715-03c12027e850":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-ALL3303","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"3614d352-664a-4be4-8715-03c12027e850_2","instance_id":"3614d352-664a-4be4-8715-03c12027e850","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Mapper"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"transformations":{"value":{"mappingTable":{"value":[{"targetPath":{"value":"$sal"},"expression":{"expression":true,"value":"50000"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"ALL3303"}},"path_id":"/QA/projects/diagnostic","path_snode":"540e8026ec77034feacff4eb"}