title: flatten snowflake arrays into rows
body: <p>I have a snowflake table with 3 arrays (contained in one table row):</p>
  <p>order array:</p>
  <pre><code>[
    1466369,
    1466369,
    1466369,
    1466369,
    1466369,
    1466369,
    1466369
  ]
  </code></pre>
  <p>part array</p>
  <pre><code>[
    17083,
    40052,
    173810,
    71874,
    104769,
    121607,
    47652
  ]
  </code></pre>
  <p>price array:</p>
  <pre><code>[
    9000.72,
    9920.5,
    11302.86,
    18458.7,
    26606.4,
    27686.2,
    36791.95
  ]
  </code></pre>
  <p>How can i convert the arrays into rows, so that each row is composed of 3 columns, so that the <strong>first</strong> row is comprised of 3 columns, made up of the first cell from each array,  and <strong>second</strong> row is comprised of the 3 columns - from the second cell  from each array , etc..... so that the conversion result will be 7 table rows (matching the 7 cells in each array).</p>
  <p>the <strong>flatten</strong> keyword to break array cells into rows, eludes me.</p>