title: Error parse JSON missing comma pos <number>
body: <p>I have a column with a varchar and want to convert it to a JSON by parse_Json. 
  (<em>{u'meta': {u'removedAt': None, u'validation': {u'createdTime': 157....</em>)</p>
  
  <p>When I use : </p>
  
  <pre><code>select get_path(PARSE_JSON(OFFER), 'field') from
  </code></pre>
  
  <p>this error occours: SQL-Fehler [100069] [22P02]: Error parsing JSON: missing colon, pos 3.</p>
  
  <p>So I try to add a Colon at position 3</p>
  
  <pre><code>select get_path(PARSE_JSON(REPLACE (offer,'u','u:')), 'field') from
  </code></pre>
  
  <p>So this error occurred SQL-Fehler [100069] [22P02]: Error parsing JSON: misplaced colon, pos 10</p>
  
  <p>By now I don't know how do handle this and the information by snowflake doesnt really help.
  <a href="https://support.snowflake.net/s/article/error-error-parsing-json-missing-comma-pos-number" rel="nofollow noreferrer">https://support.snowflake.net/s/article/error-error-parsing-json-missing-comma-pos-number</a></p>
  
  <p>Thanks for your help</p>