{"_dirty_type":"upd","class_fqid":"com-snaplogic-pipeline_8","snode_id":"598387a51ed73c1b79e4e9e9","instance_id":"08076a8f-b90e-42ac-8aab-34b298bd095c","instance_version":2,"link_map":{"link111":{"src_view_id":"output0","dst_view_id":"input0","src_id":"8591557a-06ab-4c9f-9895-1dd24a1dc519","dst_id":"ac6ae83c-b8c0-4bc6-acf1-a5bc0b60a97c","isGoto":false},"link107":{"src_view_id":"output0","dst_view_id":"input0","src_id":"ac6ae83c-b8c0-4bc6-acf1-a5bc0b60a97c","dst_id":"3df462d0-6cea-472a-a114-cc99f21e5cf6","isGoto":false},"link113":{"src_view_id":"output0","dst_view_id":"inputRows","src_id":"3df462d0-6cea-472a-a114-cc99f21e5cf6","dst_id":"931b0401-a8c6-4cd1-9438-70aac0994983","isGoto":false}},"link_serial":114,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Azure-extract-advanced-usecase"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"author":{"value":"dmiller@snaplogic.com"}},"input":{},"settings":{"param_table":{"value":[]},"imports":{"value":[]}},"error":{"931b0401-a8c6-4cd1-9438-70aac0994983_error0":{"label":{"value":"Redshift - Bulk Load - error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"none"},"8591557a-06ab-4c9f-9895-1dd24a1dc519_error0":{"label":{"value":"Bulk Extract - error0"},"view_type":{"value":"document"}}},"output":{"931b0401-a8c6-4cd1-9438-70aac0994983_output101":{"view_type":{"value":"document"},"label":{"value":"Redshift - Bulk Load - output0"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"55772b8495526e3fc62ac7ea","scale_ratio":1,"detail_map":{"8591557a-06ab-4c9f-9895-1dd24a1dc519":{"grid_x_int":1,"output":{},"grid_y_int":2,"rot_tail_int":0,"error":{"error0":{"dx_int":0,"rot_int":0,"dy_int":-1}},"input":{},"rot_int":0},"ac6ae83c-b8c0-4bc6-acf1-a5bc0b60a97c":{"grid_x_int":2,"error":{},"grid_y_int":2,"rot_tail_int":0,"input":{},"output":{},"rot_int":0},"3df462d0-6cea-472a-a114-cc99f21e5cf6":{"grid_x_int":3,"error":{},"grid_y_int":2,"rot_tail_int":0,"input":{},"output":{},"rot_int":0},"931b0401-a8c6-4cd1-9438-70aac0994983":{"grid_x_int":4,"output":{},"grid_y_int":2,"rot_tail_int":0,"error":{"error0":{"dx_int":0,"rot_int":0,"dy_int":-1}},"input":{},"rot_int":0}},"pan_y_num":0},"snap_map":{"8591557a-06ab-4c9f-9895-1dd24a1dc519":{"class_fqid":"com-snaplogic-snaps-azuresql-azuresqlbulkextract_1-12","class_id":"com-snaplogic-snaps-azuresql-azuresqlbulkextract","class_version":1,"instance_fqid":"8591557a-06ab-4c9f-9895-1dd24a1dc519_1","instance_id":"8591557a-06ab-4c9f-9895-1dd24a1dc519","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Bulk Extract"}},"view_serial":102,"account":{},"settings":{"maxError":{"value":10},"orderBy":{"value":[]},"limitRows":{"expression":false,"value":null},"ouput dir":{"value":"sample"},"passThrough":{"value":true},"KeyBcpPath":{"value":null},"tableName":{"expression":false,"value":"\"dbo\".\"ADOBEDATA1MILLION\""},"ouput file":{"value":"dimple.log"},"outputFields":{"value":[]},"whereClause":{"expression":false,"value":null},"limitOffset":{"expression":false,"value":null},"schemaName":{"expression":false,"value":"\"dbo\""},"ignoreEmptyResult":{"value":false}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"continue"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"12"},"ac6ae83c-b8c0-4bc6-acf1-a5bc0b60a97c":{"class_fqid":"com-snaplogic-snaps-transform-jsonformatter_2-transform3103","class_id":"com-snaplogic-snaps-transform-jsonformatter","class_version":2,"instance_fqid":"ac6ae83c-b8c0-4bc6-acf1-a5bc0b60a97c_1","instance_id":"ac6ae83c-b8c0-4bc6-acf1-a5bc0b60a97c","instance_version":1,"property_map":{"info":{"label":{"value":"JSON Formatter"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"jsonLines":{"value":false},"ignoreEmptyStream":{"value":false},"formatSingleDocument":{"value":false},"prettyPrint":{"value":false}},"error":{"error0":{"view_type":{"value":"binary"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"binary"},"label":{"value":"output0"}}}},"class_build_tag":"transform3103"},"3df462d0-6cea-472a-a114-cc99f21e5cf6":{"class_fqid":"com-snaplogic-snaps-transform-jsonparser_1-transform3103","class_id":"com-snaplogic-snaps-transform-jsonparser","class_version":1,"instance_fqid":"3df462d0-6cea-472a-a114-cc99f21e5cf6_1","instance_id":"3df462d0-6cea-472a-a114-cc99f21e5cf6","instance_version":1,"property_map":{"info":{"label":{"value":"JSON Parser"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"binary"}}},"settings":{"allowNonStandardJson":{"value":true},"arrayElementsAsDocuments":{"value":true},"jsonFilterPath":{"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":"transform3103"},"931b0401-a8c6-4cd1-9438-70aac0994983":{"class_fqid":"com-snaplogic-snaps-redshift-bulkload_1-rs8","class_id":"com-snaplogic-snaps-redshift-bulkload","class_version":1,"instance_fqid":"931b0401-a8c6-4cd1-9438-70aac0994983_1","instance_id":"931b0401-a8c6-4cd1-9438-70aac0994983","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Redshift - Bulk Load"}},"view_serial":101,"account":{},"input":{"inputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}},"settings":{"maxError":{"value":100},"disableCompression":{"value":false},"truncateColumns":{"value":true},"truncate":{"value":false},"createTable":{"value":true},"invalidChars":{"value":true},"tableName":{"expression":false,"value":"\"prasanna\".\"azureextractdemo\""},"executable_during_suggest":{"value":true},"vacuumType":{"value":"NONE"},"loadEmptyStrings":{"value":false},"parallelism":{"value":1},"ServerSideEncryption":{"value":false},"additionalOptions":{"value":null},"schemaName":{"expression":false,"value":"\"prasanna\""},"updateStats":{"value":false},"IAM_Role":{"value":false},"vacuumThreshold":{"value":null}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"continue"}},"output":{"output101":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"rs8"}},"path_id":"/snaplogic/Doc Patterns/Azure SQL Examples","path_snode":"598111c515071c20d4493523"}