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