title: Snowflake Get every key/value from a column that has a list of nested dictionaries
body: <p>I have a column named monthly_stats (VARCHAR type) with the  below list of dictionaries:</p>
  <pre><code>    [{&quot;id&quot;: 123, &quot;quantity_booked&quot;: &quot;12&quot;, &quot;budget_booked&quot;: &quot;112&quot;, &quot;budget_booked_loc&quot;: &quot;36.428571&quot;}, 
          {&quot;id&quot;: 1288119, &quot;quantity_booked&quot;: &quot;1703.3&quot;, &quot;budget_booked&quot;: &quot;58.694684&quot;,
       &quot;budget_booked_loc&quot;: &quot;43.434066&quot;}, {&quot;id&quot;: 233, &quot;quantity_booked&quot;: &quot;1648.35&quot;,
   &quot;budget_booked&quot;: &quot;56.801307&quot;, &quot;budget_booked_loc&quot;: &quot;42.032967&quot;}]
  </code></pre>
  <p>I've tried this query:</p>
  <pre><code> with org_table as (             
      select
      parse_json(monthly_stats) as m
      from my_table
  ) 
      select
      m[0]:id::integer as monthly_budgets_id,
      from org_table);
  </code></pre>
  <p>but this only selects  the first id in the list of dictionaries. how do I get every id in the each dictionary?</p>