Add support of JSON format
Please add support of JSON data format like just happened for SQL Server 2016 and Azure SQL Database with JSONVALUE, JSONQUERY, etc.
The support for new JSON TSQL functions are already available in the Azure Data Warehouse.
Gabriel Flores commented
FYI - this is in preview now.
Please enable JSON + Polybase for data ingest
Saul G commented
Seems like this should be an available feature since everything in Azure is JSON. When using Data Factory or other tools to ETL this would add much value
Fabio Furia commented
Please just enable FOR JSON (and FOR XML) feature in Azure SQL Data Warehouse, porting from Standard SQL Server.
Jason Horner commented
while JSON shouldn't be a part of the dimensional model it can definitely come into the DW as part of an ELT process. I would like to use JSON to store custom logging information about my stored procedure ELT process within Azure DW. it would be nice if there was some type of way to use either polybase or a linked server directly to call a sproc or update a table on Azure SQL DB
Willem Mobach commented
This would be of great help to easily export analysis results out of SQL DWH