{"class_fqid":"com-snaplogic-pipeline_8","snode_id":"5928b34ecc370d56a7988ccd","instance_id":"88d27ca4-2b3e-487c-aa73-3198f3975a96","instance_version":71,"link_map":{"link114":{"src_view_id":"output0","dst_view_id":"inputRows","src_id":"16d89d83-5d22-44a9-a3dd-49d63259a4e6","dst_id":"fb2ed620-0a07-41d0-ac1a-f6b050a8e6a8","isGoto":false}},"link_serial":115,"property_map":{"info":{"notes":{"value":null},"author":{"value":"admin@snaplogic.com"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"label":{"value":"Azure SQL Bulk Load data types"}},"input":{},"settings":{"param_table":{"value":[{"capture":{"value":false},"key":{"value":"_true"},"value":{"value":"true"}}]},"imports":{"value":[]}},"error":{"error_behavior":{"value":"none"},"fb2ed620-0a07-41d0-ac1a-f6b050a8e6a8_error0":{"label":{"value":"Azure SQL - Bulk Load - error0"},"view_type":{"value":"document"}}},"output":{"fb2ed620-0a07-41d0-ac1a-f6b050a8e6a8_output101":{"view_type":{"value":"document"},"label":{"value":"Azure SQL - Bulk Load - output0"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"5633a3b4cc370d2a9e1ed9dc","scale_ratio":1,"detail_map":{"16d89d83-5d22-44a9-a3dd-49d63259a4e6":{"grid_x_int":2,"rot_int":0,"grid_y_int":2,"rot_tail_int":0},"fb2ed620-0a07-41d0-ac1a-f6b050a8e6a8":{"grid_x_int":3,"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":{"16d89d83-5d22-44a9-a3dd-49d63259a4e6":{"class_fqid":"com-snaplogic-snaps-transform-jsongenerator_2-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-jsongenerator","class_version":2,"instance_fqid":"16d89d83-5d22-44a9-a3dd-49d63259a4e6_44","instance_id":"16d89d83-5d22-44a9-a3dd-49d63259a4e6","instance_version":44,"property_map":{"info":{"notes":{"value":null},"label":{"value":"JSON Generator"}},"view_serial":100,"settings":{"editable_content":{"value":"## Enter your JSON-encoded data in this space.  Note that this text is\n## treated as an Apache Velocity template, so you can substitute values\n## from input documents or the pipeline parameters.  See the following\n## URL for more information about Velocity:\n##   https://velocity.apache.org/engine/devel/user-guide.html\n[\n    {\n        \"datetime01\": \"2015-12-24 11:03:23\",\n        \"date01\": \"2017-11-30\",\n        \"time01\": \"09:12:34\",\n        \"real01\" : 0.45873,\n        \"float01\" : 01089.354,\n        \"binary01\": \"4243\",\n        \"varbinary01\": \"4261\",\n        \"text01\": \"abcABC\",\n        \"ntext01\": \"xyzXYZ\",\n        \"char01\": \"abc\"\n    },\n    {\n        \"datetime01\": \"2015-12-23 10:03:23\",\n        \"date01\": \"2017-10-31\",\n        \"time01\": \"09:12:12\",\n        \"real01\" : 530.573,\n        \"float01\" : 5409.3,\n        \"binary01\": \"4342\",\n        \"varbinary01\": \"6261\",\n        \"text01\": \"123abcABC\",\n        \"ntext01\": \"xyzXYZ123\",\n        \"char01\": \"ABC\"\n    },\n    {\n        \"datetime01\": \"2016-12-23 10:03:23\",\n        \"date01\": \"2017-10-31\",\n        \"time01\": \"09:12:14\",\n        \"real01\" : 530.573,\n        \"float01\" : 5409.3,\n        \"binary01\": \"4344\",\n        \"varbinary01\": \"6261\",\n        \"text01\": \"123abcABC\",\n        \"ntext01\": \"xyzXYZ777\",\n        \"char01\": \"DEF\"\n    },\n    {\n        \"datetime01\": \"2015-12-23 10:03:23\",\n        \"date01\": \"2017-10-31\",\n        \"time01\": \"09:12:12\",\n        \"real01\" : 530.573,\n        \"float01\" : 5409.3,\n        \"binary01\": \"4342\",\n        \"varbinary01\": \"6261\",\n        \"text01\": \"123abcABC\",\n        \"ntext01\": \"xyzXYZ123\",\n        \"char01\": \"ABC\"\n    },\n    {\n        \"datetime01\": \"2015-12-23 10:03:23\",\n        \"date01\": \"2017-10-31\",\n        \"time01\": \"09:12:12\",\n        \"real01\" : 530.573,\n        \"float01\" : 5409.3,\n        \"binary01\": \"4342\",\n        \"varbinary01\": \"6261\",\n        \"text01\": \"123abcABC\",\n        \"ntext01\": \"xyzXYZ333\",\n        \"char01\": \"ABCDEF\"\n    }\n]\n\n\n## Tips:\n##  * The sample data above will generate a single empty document, uncomment\n##    the line in the middle to include the sample fields.  Adding more\n##    objects to the root array will cause the snap to generate more\n##    than one document.\n##  * Pipeline parameters can be referenced by prefixing the parameter\n##    name with an underscore, like so:\n##      ${_pipelineParamName}\n##  * If you add an input view to the snap, this template will be\n##    evaluated for each input document.\n##  * Fields in the input documents can be referenced by prefixing them\n##    with a dollar-sign ($), like so:\n##      $parent.child[0].value\n##  * Any referenced document values and pipeline parameters will\n##    automatically be JSON-encoded when they are inserted into the final\n##    JSON document.  You should not have to worry about escaping values\n##    yourself.\n##  * If you are having troubles getting a template to produce valid JSON,\n##    you can add an error view to the snap to get a document that\n##    contains the output of the template evaluation."},"arrayElementsAsDocuments":{"value":true}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}}},"class_build_tag":"SNAPSHOT"},"fb2ed620-0a07-41d0-ac1a-f6b050a8e6a8":{"class_fqid":"com-snaplogic-snaps-azuresql-azuresqlbulkload_1-SNAPSHOT","class_id":"com-snaplogic-snaps-azuresql-azuresqlbulkload","class_version":1,"instance_fqid":"fb2ed620-0a07-41d0-ac1a-f6b050a8e6a8_10","instance_id":"fb2ed620-0a07-41d0-ac1a-f6b050a8e6a8","instance_version":10,"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":"Microsoft SQL Server 2017 with CTP 1.1"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-azuresqldatabaseaccount"},"ref_id":{"expression":false,"value":"0b403438-10a4-4c9b-a2ba-bf4452292518"}}}},"settings":{"batchSize":{"value":2},"bulkCopyTimeout":{"value":60},"tableName":{"expression":false,"value":"\"dbo\".\"datatypetest\""},"executable_during_suggest":{"value":true},"createTable":{"value":false},"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":"continue"}},"input":{"inputRows":{"label":{"value":"rows"},"view_type":{"value":"document"}}}},"class_build_tag":"SNAPSHOT"}},"path_id":"/snaplogic/shared","path_snode":"52ab4929cc370d673d75d96e"}