title: Iterating through JSON object item values in Redshift
body: <p>We have a json object as one of our columns in the database. I can reach the values one by one with json_extract_path_text, but I could not figure out a way to iterate through all values to summarize all value (value1, value2, value1, value2, value3) items.</p>
  
  <pre><code>select  json_extract_path_text('{"test_0":{"value1":6050,"value2":3000},"test_1":{"value1":6000,"value2":200,"value3":50}}','test_0', 'value1')
  
  </code></pre>