I am trying to find the most efficient way in Snowflake to split a table of arrays into a table with all the elements into individual rows.
So a table having the rows
<code>row 1: ["abc", "def", "ghi"]
row 2: ["jkl"]
row 3: ["mno", "pqr"]
</code>
<code>row 1: ["abc", "def", "ghi"]
row 2: ["jkl"]
row 3: ["mno", "pqr"]
</code>
row 1: ["abc", "def", "ghi"]
row 2: ["jkl"]
row 3: ["mno", "pqr"]
Should return (individual rows)
<code>"abc"
"def"
"ghi"
"jkl"
"mno"
"pqr"
</code>
<code>"abc"
"def"
"ghi"
"jkl"
"mno"
"pqr"
</code>
"abc"
"def"
"ghi"
"jkl"
"mno"
"pqr"
Is there any method to do this without casting to strings and performing string manipulation?