T-SQL has a couple of functions that can parse JSON data, but none of them are applicable to Azure SQL Data Warehouse.
I have data in JSON format in a VARCHAR column that looks like:
{'Purpose': 'Purpose 1', 'Activity': 'This activity'}
I could extract the 'Purpose' field in SQL Server by using the JSON_VALUE
function:
SELECT JSON_VALUE('{'Purpose': 'Purpose 1', 'Activity': 'This activity'}', '$.Purpose');
But this is not supported in SQL Data Warehouse. Is there a way to do this in SQL Data Warehouse?
https://docs.microsoft.com/en-us/sql/t-sql/functions/json-functions-transact-sql