title: Flatten and reconstruct JSON Snowflake
body: <p>I am still learning Snowflake, any help would be really appreciated.</p>
  <p>I have a column, let's call it 'result'.</p>
  <pre><code>{
    &quot;catalog&quot;: [
      {
        &quot;img_href&quot;: &quot;https://schumacher-webassets.s3.amazonaws.com/Web%20Catalog-600/179361.jpg&quot;,
        &quot;name&quot;: &quot;ADITI HAND BLOCKED PRINT&quot;,
        &quot;price&quot;: 16
      },
      {
        &quot;img_href&quot;: &quot;https://schumacher-webassets.s3.amazonaws.com/Web%20Catalog-600/179330.jpg&quot;,
        &quot;name&quot;: &quot;TORBAY HAND BLOCKED PRINT&quot;,
        &quot;price&quot;: 17
      },
      {
        &quot;img_href&quot;: &quot;https://schumacher-webassets.s3.amazonaws.com/Web%20Catalog-600/179362.jpg&quot;,
        &quot;name&quot;: &quot;ADITI HAND BLOCKED PRINT&quot;,
        &quot;price&quot;: 18
      }
    ],
    &quot;datetime&quot;: 161878993658
    &quot;catalog_id&quot;: 1
  }
  </code></pre>
  <p>I would like to flatten it and reconstruct as below</p>
  <pre><code>[
    {
      &quot;datetime&quot;: 161878993658,
      &quot;url&quot;: &quot;https://schumacher-webassets.s3.amazonaws.com/Web%20Catalog-600/179361.jpg&quot;
    },
    {
      &quot;datetime&quot;: 161878993658,
      &quot;url&quot;: &quot;https://schumacher-webassets.s3.amazonaws.com/Web%20Catalog-600/179330.jpg&quot;
    },
    {
      &quot;datetime&quot;: 161878993658,
      &quot;url&quot;: &quot;https://schumacher-webassets.s3.amazonaws.com/Web%20Catalog-600/179362.jpg&quot;
    },
  ]
  </code></pre>