title: Parse JSON using Snowflake SQL
body: <p>I have a JSON object that's written in a weird way.    </p>
  
  <pre><code>&gt; {"custom": [ { "name": "addressIdNum", "valueNum": 12345678},  {
  &gt; "name": "cancelledDateAt", "valueAt": "2017-02-30T01:43:04.000Z" }] }
  </code></pre>
  
  <p>Not sure how to parse something like this. The keys are addressIdNum and cancelledDateAt and the values  are 12345678 and 2017-02-30T01:43:04.000Z respectively. </p>
  
  <p>How do I parse this using Snowflake SQL? </p>
  
  <p>Thanks for all your help!</p>
  
  <p>Best,
  Preet Rajdeo</p>