{"class_fqid":"com-snaplogic-pipeline_8","snode_id":"596cb71c95526e640ad4b369","instance_id":"505fe0f4-7a7d-49a8-806c-b8e8eb8c3f42","instance_version":5,"link_map":{"link104":{"src_view_id":"output0","dst_view_id":"input0","src_id":"f3a25a26-d105-41f6-8185-4b5686d72a47","dst_id":"e2d2b24c-2c95-4894-a396-d490326a6c0b","isGoto":false},"link102":{"src_view_id":"error0","dst_view_id":"input0","src_id":"3247bfe9-4456-423a-a129-7f3d7f19b791","dst_id":"96a49b08-0973-4d15-a940-53e6c682c130","isGoto":false},"link103":{"src_view_id":"output0","dst_view_id":"input0","src_id":"96a49b08-0973-4d15-a940-53e6c682c130","dst_id":"7281eb49-fc8d-4a2b-9126-e7f62a3f9fd0","isGoto":false},"link100":{"src_view_id":"outputRows","dst_view_id":"inputRows","src_id":"765ebe28-55be-4007-a0b0-938865e8f081","dst_id":"3247bfe9-4456-423a-a129-7f3d7f19b791","isGoto":false},"link101":{"src_view_id":"output101","dst_view_id":"input0","src_id":"3247bfe9-4456-423a-a129-7f3d7f19b791","dst_id":"f3a25a26-d105-41f6-8185-4b5686d72a47","isGoto":false}},"link_serial":105,"property_map":{"info":{"notes":{"value":null},"author":{"value":"atayi@snaplogic.com"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"label":{"value":"Azure SQL Bulk load performance input snap oracle"}},"input":{},"settings":{"param_table":{"value":[]},"imports":{"value":[]}},"error":{"error_behavior":{"value":"none"}},"output":{"52f745d5-fe71-487a-b3e6-16c5c922b2b4_output101":{"label":{"value":"Azure SQL - Execute - output0"},"view_type":{"value":"document"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"5710216095526e484d534a97","scale_ratio":1,"detail_map":{"f3a25a26-d105-41f6-8185-4b5686d72a47":{"grid_x_int":5,"error":{},"grid_y_int":2,"rot_tail_int":0,"input":{},"output":{},"rot_int":0},"96a49b08-0973-4d15-a940-53e6c682c130":{"grid_x_int":5,"error":{},"grid_y_int":1,"rot_tail_int":0,"input":{},"output":{},"rot_int":0},"52f745d5-fe71-487a-b3e6-16c5c922b2b4":{"grid_x_int":5,"error":{},"grid_y_int":3,"rot_tail_int":0,"input":{},"output":{},"rot_int":0},"765ebe28-55be-4007-a0b0-938865e8f081":{"grid_x_int":3,"rot_int":0,"grid_y_int":2,"rot_tail_int":0},"e2d2b24c-2c95-4894-a396-d490326a6c0b":{"grid_x_int":6,"error":{},"grid_y_int":2,"rot_tail_int":0,"input":{},"output":{},"rot_int":0},"7281eb49-fc8d-4a2b-9126-e7f62a3f9fd0":{"grid_x_int":6,"error":{},"grid_y_int":1,"rot_tail_int":0,"input":{},"output":{},"rot_int":0},"3247bfe9-4456-423a-a129-7f3d7f19b791":{"grid_x_int":4,"rot_int":0,"grid_y_int":2,"rot_tail_int":0,"error":{"error0":{"dx_int":0,"rot_int":0,"dy_int":-1}}}},"pan_y_num":0},"snap_map":{"f3a25a26-d105-41f6-8185-4b5686d72a47":{"class_fqid":"com-snaplogic-snaps-transform-jsonformatter_2-snapsrc797","class_id":"com-snaplogic-snaps-transform-jsonformatter","class_version":2,"instance_fqid":"f3a25a26-d105-41f6-8185-4b5686d72a47_1","instance_id":"f3a25a26-d105-41f6-8185-4b5686d72a47","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":"snapsrc797"},"96a49b08-0973-4d15-a940-53e6c682c130":{"class_fqid":"com-snaplogic-snaps-transform-jsonformatter_2-snapsrc797","class_id":"com-snaplogic-snaps-transform-jsonformatter","class_version":2,"instance_fqid":"96a49b08-0973-4d15-a940-53e6c682c130_1","instance_id":"96a49b08-0973-4d15-a940-53e6c682c130","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":"snapsrc797"},"52f745d5-fe71-487a-b3e6-16c5c922b2b4":{"class_fqid":"com-snaplogic-snaps-azuresql-execute_1-azuresql3257","class_id":"com-snaplogic-snaps-azuresql-execute","class_version":1,"instance_fqid":"52f745d5-fe71-487a-b3e6-16c5c922b2b4_2","instance_id":"52f745d5-fe71-487a-b3e6-16c5c922b2b4","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Azure SQL - Execute"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"ff6e1436-4d63-409e-9f66-d9d4508cfaa0"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-azuresqldatabaseaccount"},"label":{"expression":false,"value":"Azure Sql BulkLoad-NEW Snap test"}}}},"settings":{"advancedSnapProperties":{"value":[]},"passThrough":{"value":true},"ignoreEmptyResult":{"value":false},"executable_during_suggest":{"value":true},"sqlStatement":{"expression":false,"value":"select count(*) from \"dbo\".\"adobedata\""}},"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":"azuresql3257"},"765ebe28-55be-4007-a0b0-938865e8f081":{"class_fqid":"com-snaplogic-snaps-oracle-select_3-oracle3256","class_id":"com-snaplogic-snaps-oracle-select","class_version":3,"instance_fqid":"765ebe28-55be-4007-a0b0-938865e8f081_3","instance_id":"765ebe28-55be-4007-a0b0-938865e8f081","instance_version":3,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Oracle - Select"}},"view_serial":100,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"Oracle-prasanna - Not for diagnostics"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-oraclethindatabaseaccount"},"ref_id":{"expression":false,"value":"e2e6fffa-7f3d-44da-b40d-8bdb8b4af4a5"}}}},"settings":{"orderBy":{"value":[]},"limitRows":{"expression":false,"value":"1000000"},"passThrough":{"value":true},"tableName":{"expression":false,"value":"\"TECTONIC\".\"ADOBEPRASANNA_NEW11245\""},"outputFields":{"value":[]},"whereClause":{"expression":false,"value":null},"limitOffset":{"expression":false,"value":null},"advancedSnapProperties":{"value":[]},"schemaName":{"expression":false,"value":"\"TECTONIC\""},"ignoreEmptyResult":{"value":false}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"outputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}}},"class_build_tag":"oracle3256"},"e2d2b24c-2c95-4894-a396-d490326a6c0b":{"class_fqid":"com-snaplogic-snaps-binary-write_3-snapsrc797","class_id":"com-snaplogic-snaps-binary-write","class_version":3,"instance_fqid":"e2d2b24c-2c95-4894-a396-d490326a6c0b_1","instance_id":"e2d2b24c-2c95-4894-a396-d490326a6c0b","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"File Writer1"}},"view_serial":100,"account":{},"settings":{"createDir":{"value":false},"writeHeader":{"value":false},"executable_during_suggest":{"value":true},"filename":{"expression":false,"value":"s3:///patan/teja/azuresqloutput.out"},"writeEmptyFile":{"value":false},"UserPermissionsKey":{"value":[]},"validate":{"value":false},"fileAction":{"value":"OVERWRITE"}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"input":{"input0":{"view_type":{"value":"binary"},"label":{"value":"input0"}}}},"class_build_tag":"snapsrc797"},"7281eb49-fc8d-4a2b-9126-e7f62a3f9fd0":{"class_fqid":"com-snaplogic-snaps-binary-write_3-snapsrc797","class_id":"com-snaplogic-snaps-binary-write","class_version":3,"instance_fqid":"7281eb49-fc8d-4a2b-9126-e7f62a3f9fd0_1","instance_id":"7281eb49-fc8d-4a2b-9126-e7f62a3f9fd0","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"File Writer"}},"view_serial":100,"account":{},"settings":{"createDir":{"value":false},"writeHeader":{"value":false},"executable_during_suggest":{"value":true},"filename":{"expression":false,"value":"s3:///patan/teja/azuresqlbulkloaderr.out"},"writeEmptyFile":{"value":false},"UserPermissionsKey":{"value":[]},"validate":{"value":false},"fileAction":{"value":"OVERWRITE"}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"binary"}}}},"class_build_tag":"snapsrc797"},"3247bfe9-4456-423a-a129-7f3d7f19b791":{"class_fqid":"com-snaplogic-snaps-azuresql-azuresqlbulkload_1-azuresql3257","class_id":"com-snaplogic-snaps-azuresql-azuresqlbulkload","class_version":1,"instance_fqid":"3247bfe9-4456-423a-a129-7f3d7f19b791_3","instance_id":"3247bfe9-4456-423a-a129-7f3d7f19b791","instance_version":3,"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":"ff6e1436-4d63-409e-9f66-d9d4508cfaa0"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-azuresqldatabaseaccount"},"label":{"expression":false,"value":"Azure Sql BulkLoad-NEW Snap test"}}}},"input":{"inputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}},"settings":{"batchSize":{"expression":false,"value":10000},"bulkCopyTimeout":{"expression":false,"value":60},"tableName":{"expression":false,"value":"\"dbo\".\"adobedata\""},"executable_during_suggest":{"value":true},"createTable":{"value":true},"advancedProperties":{"value":[]},"schemaName":{"expression":false,"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":"azuresql3257"}},"path_id":"/QA/projects/Aparna Tayi","path_snode":"57dfe69295526e323448ebe3"}