Provide File Format to read and load JSON and XML data from Storage
Able to read the JSON and XML file as part of external system OR provide functionality like Extractor in Data Lake analytics so we can write our own Extractor to read respective data format.
Create External File Format JSONFile
Format_Type = JSON
What will be the syntax to create external JSON file format..?
Bushra Anjum commented
Try the following ":
Here you can see following features :
=>Read JSON data from any REST API Web Service using methods such as GET/POST.
=>Read JSON data from single or multiple JSON files (use of wildcard allowed. e.g. c:\data\*.json)
=>Support for Path expression to extract data from any level (e.g. Extract Orders nested under Customer Node).
=>Support for passing custom headers to API Web service
=>REST API Paging support to loop through multiple requests (see)
=>Parse source JSON String/Documents into multiple columns/rows.
=>Ability to de-normalize nested JSON data into flat structure
=>Create simple or nested JSON documents inside DataFlow Task using simple drag and drop approach
=>Ability to create nested JSON from Multiple datasets
=>Ability to create single JSON document for all input records or create one document for each input row from ROOT dataset
=>Export multiple tables/views to JSON files (e.g. Sales% or do SalesJan|SalesFeb)
=>Export SQL query output to JSON file
=>Inbuilt Layout Editor for creating complex JSON with nested structure (Document Array, Value Array, Nested attributes
=>Automatically Split exported JSON data into multiple files by Size or Number of records
=>Automatically Split exported JSON data into multiple files by Split By Column (e.g. SplitBy=Country will create new file for each country)
=>Support for SQL Server 2005, 2008, 2012, 2014, 2016 and 2017 (32 bit / 64 bit)
+1 for Stream Analytics format. And, via Polybase. I.e.,Add JSON External File Format - https://msdn.microsoft.com/en-us/library/dn935026.aspx
Mike Smith (OFFICE) commented
Also please support per-line json objects, without an enclosing array, as written by Stream Analytics.