{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"643fc7c171708a024ccb06d6","instance_id":"18b6c6ba-c961-43f6-94e2-c82f3a165ee1","instance_version":2,"link_map":{"link101":{"dst_id":"1a7c353a-9071-4439-b7cc-60a4a801f3a9","dst_view_id":"inputRows","src_id":"68e447a4-ad41-4e2c-a148-ed3911938e70","src_view_id":"outputRows","isGoto":false},"link103":{"dst_id":"c8045bfa-b9ec-4c55-a827-c13a552cc95b","dst_view_id":"input1","src_id":"1613cdd8-58e5-415c-82cc-4393eba3e985","src_view_id":"output102","isGoto":false},"link104":{"dst_id":"68e447a4-ad41-4e2c-a148-ed3911938e70","dst_view_id":"input102","src_id":"c8045bfa-b9ec-4c55-a827-c13a552cc95b","src_view_id":"output0","isGoto":false},"link105":{"dst_id":"c8045bfa-b9ec-4c55-a827-c13a552cc95b","dst_view_id":"input0","src_id":"1613cdd8-58e5-415c-82cc-4393eba3e985","src_view_id":"error0","isGoto":false}},"link_serial":106,"property_map":{"info":{"label":{"value":"C12340229_SQLServer_Delete_50K_Batch_500"},"author":{"value":"snap-qa+snap2@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":{"1613cdd8-58e5-415c-82cc-4393eba3e985_input101":{"label":{"value":"SQL Server - Delete - input0"},"view_type":{"value":"document"}}},"output":{"1a7c353a-9071-4439-b7cc-60a4a801f3a9_output101":{"label":{"value":"SQL Server - Insert - output0"},"view_type":{"value":"document"}}}},"render_map":{"scale_ratio":1,"pan_x_num":0,"pan_y_num":0,"default_snaplex":"62336f97b1e7242b088c4441","detail_map":{"68e447a4-ad41-4e2c-a148-ed3911938e70":{"grid_x_int":4,"grid_y_int":1,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0,"input":{},"output":{},"error":{}},"1a7c353a-9071-4439-b7cc-60a4a801f3a9":{"grid_x_int":5,"grid_y_int":1,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0,"input":{},"output":{},"error":{}},"1613cdd8-58e5-415c-82cc-4393eba3e985":{"grid_x_int":2,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0,"error":{"error0":{"rot_int":0,"dx_int":0,"dy_int":-1}},"input":{},"output":{}},"c8045bfa-b9ec-4c55-a827-c13a552cc95b":{"grid_x_int":3,"grid_y_int":1,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0,"output":{},"input":{"input1":{"rot_int":0,"dx_int":0,"dy_int":1}},"error":{}}}},"snap_map":{"68e447a4-ad41-4e2c-a148-ed3911938e70":{"class_fqid":"com-snaplogic-snaps-sqlserver-select_3-develop19872","class_id":"com-snaplogic-snaps-sqlserver-select","class_version":3,"instance_fqid":"68e447a4-ad41-4e2c-a148-ed3911938e70_1","instance_id":"68e447a4-ad41-4e2c-a148-ed3911938e70","instance_version":1,"property_map":{"info":{"label":{"value":"SQL Server - Select"},"notes":{}},"output":{"outputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"queryHints":{"value":null,"expression":false},"orderBy":{"value":[]},"autoCommit":{"value":"False"},"maxRetryProp":{"value":0,"expression":false},"execution_mode":{"value":"Validate & Execute"},"matchDataTypes":{"value":false},"schemaName":{"value":null,"expression":false},"limitOffset":{"value":null,"expression":false},"retryIntervalProp":{"value":1,"expression":false},"limitRows":{"value":"50000","expression":false},"passThrough":{"value":true},"unique_identifier_column_option":{"value":"Convert to lower case (default)"},"whereClause":{"value":null,"expression":false},"ignoreEmptyResult":{"value":false},"tableName":{"value":"\"dbo\".\"all_data_types_dump4\"","expression":false},"fetchOutputFieldsInSchema":{"value":false},"outputFields":{"value":[]},"stagingMode":{"value":"On disk"},"rowversion":{"value":false}},"account":{"account_ref":{"value":{"label":{"value":"Dg_Sqlserver_Perf_RDS","label":"Dg_Sqlserver_Perf_RDS","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-sqlserverdatabaseaccount"},"ref_id":{"value":"4b93d6fa-203a-4258-abb4-9fa71520396e","expression":false}},"expression":false}},"view_serial":102,"input":{"input102":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"develop19872"},"1a7c353a-9071-4439-b7cc-60a4a801f3a9":{"class_fqid":"com-snaplogic-snaps-sqlserver-insert_1-develop20128","class_id":"com-snaplogic-snaps-sqlserver-insert","class_version":1,"instance_fqid":"1a7c353a-9071-4439-b7cc-60a4a801f3a9_1","instance_id":"1a7c353a-9071-4439-b7cc-60a4a801f3a9","instance_version":1,"property_map":{"info":{"label":{"value":"SQL Server - Insert"},"notes":{}},"input":{"inputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"},"executable_during_suggest":{"value":false},"createTable":{"value":true},"maxRetryProp":{"value":0,"expression":false},"retryIntervalProp":{"value":1,"expression":false},"enableIdentityInsert":{"value":false},"schemaName":{"value":null,"expression":false},"tableName":{"value":"dbo.SNPQA6099_Insert_50k","expression":false}},"account":{"account_ref":{"value":{"label":{"value":"Dg_SqlServer_Perf_RDS_Batch500","label":"Dg_SqlServer_Perf_RDS_Batch500","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-sqlserverdatabaseaccount"},"ref_id":{"value":"42605856-cb47-494f-a283-70423521f5c7","expression":false}}}},"view_serial":101,"output":{"output101":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"develop20128"},"1613cdd8-58e5-415c-82cc-4393eba3e985":{"class_fqid":"com-snaplogic-snaps-sqlserver-delete_1-develop20128","class_id":"com-snaplogic-snaps-sqlserver-delete","class_version":1,"instance_fqid":"1613cdd8-58e5-415c-82cc-4393eba3e985_1","instance_id":"1613cdd8-58e5-415c-82cc-4393eba3e985","instance_version":1,"property_map":{"info":{"label":{"value":"SQL Server - Delete"},"notes":{}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"continue"}},"settings":{"execution_mode":{"value":"Validate & Execute"},"executable_during_suggest":{"value":false},"maxRetryProp":{"value":0,"expression":false},"retryIntervalProp":{"value":1,"expression":false},"schemaName":{"value":null,"expression":false},"tableName":{"value":"dbo.SNPQA6099_Insert_50k","expression":false},"deleteCondition":{"value":null,"expression":false}},"account":{"account_ref":{"value":{"label":{"value":"Dg_SqlServer_Perf_RDS_Batch500","label":"Dg_SqlServer_Perf_RDS_Batch500","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-sqlserverdatabaseaccount"},"ref_id":{"value":"42605856-cb47-494f-a283-70423521f5c7","expression":false}}}},"view_serial":102,"input":{"input101":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"output":{"output102":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"develop20128"},"c8045bfa-b9ec-4c55-a827-c13a552cc95b":{"class_fqid":"com-snaplogic-snaps-flow-union_2-develop20155","class_id":"com-snaplogic-snaps-flow-union","class_version":2,"instance_fqid":"c8045bfa-b9ec-4c55-a827-c13a552cc95b_1","instance_id":"c8045bfa-b9ec-4c55-a827-c13a552cc95b","instance_version":1,"property_map":{"info":{"label":{"value":"Union"}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}},"input1":{"view_type":{"value":"document"},"label":{"value":"input1"}}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"}},"view_serial":100},"class_build_tag":"develop20155"}},"path_id":"/Perf_DB/projects/Diagnostic_Performance_Tests","path_snode":"63ede2b46f9264018b6f888e","target_runtime":"standard"}