{"_dirty_type":"upd","class_fqid":"com-snaplogic-pipeline_8","snode_id":"597a111895526e640ad5d1a0","instance_id":"22eb4b5d-e9d2-449b-b21f-91de39c304b0","instance_version":3,"link_map":{"link106":{"src_view_id":"output101","dst_view_id":"input0","src_id":"8192c06f-f8b6-4c3b-aee4-7419617c125b","dst_id":"5c967205-98b4-4c77-804c-f739edf5d6f5","isGoto":false},"link107":{"src_view_id":"outputRows","dst_view_id":"inputRows","src_id":"256dc1ac-fef6-4993-8805-db059ea4ecc1","dst_id":"8192c06f-f8b6-4c3b-aee4-7419617c125b","isGoto":false},"link108":{"src_view_id":"output101","dst_view_id":"input101","src_id":"bf246093-de4b-4d9e-b58d-20c240765145","dst_id":"256dc1ac-fef6-4993-8805-db059ea4ecc1","isGoto":false,"_dirty_type":"upd"},"link100":{"src_view_id":"output101","dst_view_id":"input102","src_id":"83e97184-75d5-4426-90e5-a2ca3f207a87","dst_id":"56c1903c-4101-44f6-a64b-fc23ecc7b0ee","isGoto":false},"link101":{"src_view_id":"output0","dst_view_id":"input0","src_id":"5c967205-98b4-4c77-804c-f739edf5d6f5","dst_id":"83e97184-75d5-4426-90e5-a2ca3f207a87","isGoto":false}},"link_serial":109,"property_map":{"info":{"notes":{"value":null},"author":{"value":"atayi@snaplogic.com"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"label":{"value":"Azure SQL update copy sql server table to Azure and update colomns"}},"input":{"bf246093-de4b-4d9e-b58d-20c240765145_input102":{"label":{"value":"Azure SQL - Execute - input0"},"view_type":{"value":"document"}}},"settings":{"param_table":{"value":[]},"imports":{"value":[]}},"error":{"error_behavior":{"value":"none"}},"output":{"56c1903c-4101-44f6-a64b-fc23ecc7b0ee_output101":{"view_type":{"value":"document"},"label":{"value":"Azure SQL - Execute - output0"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"5710216095526e484d534a97","scale_ratio":1,"detail_map":{"56c1903c-4101-44f6-a64b-fc23ecc7b0ee":{"grid_x_int":6,"error":{},"grid_y_int":2,"rot_tail_int":0,"input":{},"output":{},"rot_int":0},"256dc1ac-fef6-4993-8805-db059ea4ecc1":{"grid_x_int":2,"error":{},"grid_y_int":2,"rot_tail_int":0,"input":{},"output":{},"rot_int":0},"83e97184-75d5-4426-90e5-a2ca3f207a87":{"grid_x_int":5,"error":{},"grid_y_int":2,"rot_tail_int":0,"input":{},"output":{},"rot_int":0},"8192c06f-f8b6-4c3b-aee4-7419617c125b":{"grid_x_int":3,"error":{},"grid_y_int":2,"rot_tail_int":0,"input":{},"output":{},"rot_int":0},"5c967205-98b4-4c77-804c-f739edf5d6f5":{"grid_x_int":4,"error":{},"grid_y_int":2,"rot_tail_int":0,"input":{},"output":{},"rot_int":0},"bf246093-de4b-4d9e-b58d-20c240765145":{"grid_x_int":1,"error":{},"grid_y_int":2,"rot_tail_int":0,"input":{},"output":{},"rot_int":0}},"pan_y_num":0},"snap_map":{"56c1903c-4101-44f6-a64b-fc23ecc7b0ee":{"class_fqid":"com-snaplogic-snaps-azuresql-execute_1-c397","class_id":"com-snaplogic-snaps-azuresql-execute","class_version":1,"instance_fqid":"56c1903c-4101-44f6-a64b-fc23ecc7b0ee_2","instance_id":"56c1903c-4101-44f6-a64b-fc23ecc7b0ee","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Azure SQL - Execute"}},"view_serial":102,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"46cb5a63-66bb-4cd2-9e70-c63708abd863"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-azuresqldatabaseaccount"},"label":{"expression":false,"value":"AzureSQL_Diag"}}}},"settings":{"passThrough":{"value":false},"ignoreEmptyResult":{"value":false},"sqlStatement":{"expression":false,"value":"select count(*)from dbo.sqlavemployees where employee_id =100"},"executable_during_suggest":{"value":true},"advancedSnapProperties":{"value":[]}},"output":{"output101":{"label":{"value":"output0"},"view_type":{"value":"document"}}},"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":"c397"},"256dc1ac-fef6-4993-8805-db059ea4ecc1":{"class_fqid":"com-snaplogic-snaps-sqlserver-select_3-c405","class_id":"com-snaplogic-snaps-sqlserver-select","class_version":3,"instance_fqid":"256dc1ac-fef6-4993-8805-db059ea4ecc1_1","instance_id":"256dc1ac-fef6-4993-8805-db059ea4ecc1","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"SQL Server - Select"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"d15d6c96-5225-4c3a-bf76-48f363a0215a"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-sqlserverdatabaseaccount"},"label":{"expression":false,"value":"sql server prasanna schema - not for diagnostics"}}}},"input":{"input101":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"orderBy":{"value":[]},"autoCommit":{"value":"False"},"limitRows":{"expression":false,"value":null},"passThrough":{"value":true},"tableName":{"expression":false,"value":"\"dbo\".\"avemployees\""},"ignoreEmptyResult":{"value":false},"outputFields":{"value":[]},"whereClause":{"expression":false,"value":null},"schemaName":{"expression":false,"value":"\"dbo\""},"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":"c405"},"83e97184-75d5-4426-90e5-a2ca3f207a87":{"class_fqid":"com-snaplogic-snaps-azuresql-update_1-c397","class_id":"com-snaplogic-snaps-azuresql-update","class_version":1,"instance_fqid":"83e97184-75d5-4426-90e5-a2ca3f207a87_2","instance_id":"83e97184-75d5-4426-90e5-a2ca3f207a87","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Azure SQL - Update"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"46cb5a63-66bb-4cd2-9e70-c63708abd863"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-azuresqldatabaseaccount"},"label":{"expression":false,"value":"AzureSQL_Diag"}}}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"updateCondition":{"expression":false,"value":"employee_id =17"},"schemaName":{"expression":false,"value":"\"dbo\""},"tableName":{"expression":false,"value":"\"dbo\".\"sqlavemployees\""},"executable_during_suggest":{"value":true}},"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":"c397"},"8192c06f-f8b6-4c3b-aee4-7419617c125b":{"class_fqid":"com-snaplogic-snaps-azuresql-azuresqlbulkload_1-c405","class_id":"com-snaplogic-snaps-azuresql-azuresqlbulkload","class_version":1,"instance_fqid":"8192c06f-f8b6-4c3b-aee4-7419617c125b_2","instance_id":"8192c06f-f8b6-4c3b-aee4-7419617c125b","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Azure SQL - Bulk Load"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"46cb5a63-66bb-4cd2-9e70-c63708abd863"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-azuresqldatabaseaccount"},"label":{"expression":false,"value":"AzureSQL_Diag"}}}},"settings":{"batchSize":{"expression":false,"value":10000},"bulkCopyTimeout":{"expression":false,"value":60},"tableName":{"expression":false,"value":"\"dbo\".\"sqlavemployees\""},"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":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"input":{"inputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}}},"class_build_tag":"c405"},"5c967205-98b4-4c77-804c-f739edf5d6f5":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-c405","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"5c967205-98b4-4c77-804c-f739edf5d6f5_1","instance_id":"5c967205-98b4-4c77-804c-f739edf5d6f5","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Mapper"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"transformations":{"value":{"mappingTable":{"value":[{"expression":{"expression":false,"value":"100"},"targetPath":{"value":"$employee_id"}}]},"mappingRoot":{"value":"$"}}}},"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":"c405"},"bf246093-de4b-4d9e-b58d-20c240765145":{"class_fqid":"com-snaplogic-snaps-azuresql-execute_1-c397","class_id":"com-snaplogic-snaps-azuresql-execute","class_version":1,"instance_fqid":"bf246093-de4b-4d9e-b58d-20c240765145_2","instance_id":"bf246093-de4b-4d9e-b58d-20c240765145","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Azure SQL - Execute"}},"view_serial":102,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"46cb5a63-66bb-4cd2-9e70-c63708abd863"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-azuresqldatabaseaccount"},"label":{"expression":false,"value":"AzureSQL_Diag"}}}},"input":{"input102":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"autoCommit":{"value":"Use account setting"},"passThrough":{"value":false},"executable_during_suggest":{"value":true},"sqlStatement":{"expression":false,"value":"drop table if exists dbo.sqlavemployees"},"advancedSnapProperties":{"value":[]},"ignoreEmptyResult":{"value":false}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output101":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"c397"}},"path_id":"/QA/projects/Aparna Tayi","path_snode":"57dfe69295526e323448ebe3"}