title: How to select element from Varchar "JSON Array" in snowflake database?
body: <p>I have a VARCHAR(16777216) column in a snowflake database table, that is structured as an array with JSON in it. </p>
  
  <p>An example of a row in the column: <code>[ {"Name":"John", "Last Name": "Doe"}, {"Name":"Frank", "Last Name": "Doe"}]</code></p>
  
  <p>How do I use sql to select all of the Last Names in each row?</p>
  
  <p>Please note, this is a VARCHAR COLUMN. </p>