title: Summing values from a JSON array in Snowflake
body: <p>I have a source data which contains the following type of a JSON array:</p>
  
  <pre><code>[
    [
      "source 1",
      250    
    ],
    [
      "other source",
      58
    ],
    [
      "more stuff",
      42
    ],
    ...
  ]
  </code></pre>
  
  <p>There can be 1..N pairs of strings and values like this. How can I sum all the values together from this JSON?</p>