title: Snowflake parse_json on varchar column seeing error JSON: unknown keyword "None"
body: <p>I've ingested into a table the following rows in varchar column <code>breakdown</code> :</p>
  <pre><code>[{'platform': 'facebook', 'total': 20701, 'likes': 10106, 'shares': 3774, 'comments': 6168, 'tweets': None, 'favorites': None, 'hahas': 375, 'wows': 164, 'loves': 31, 'sads': 21, 'angrys': 62}]
  
  [{'platform': 'facebook', 'total': 15958, 'likes': 7206, 'shares': 2931, 'comments': 541, 'tweets': None, 'favorites': None, 'hahas': 62, 'wows': 852, 'loves': 145, 'sads': 1968, 'angrys': 2253}]
  </code></pre>
  <p>When I try to do this to break out each dictionary into its own column I see this error:</p>
  <pre><code>with org_table as (
    select
  loaded_date,
  parse_json(breakdown) as CUSTOM_FIELDS
  from my_table)
  select
  CUSTOM_FIELDS:platform::string as platform
  from org_table
  </code></pre>
  <blockquote>
  <p>Error parsing JSON: unknown keyword &quot;None&quot;, pos 107</p>
  </blockquote>
  <p>Is there something I can change when creating the table file format to help with this? Below is the file format I have for this table:</p>
  <pre><code>    &quot;type&quot;: 'csv',
      &quot;field_delimiter&quot;: ',',
      &quot;EMPTY_FIELD_AS_NULL&quot;: True,
      'escape_unenclosed_field': None,
      'date_format': 'YYYY-MM-DD',
      'skip_header': 1,
      'escape': 'None',
      'FIELD_OPTIONALLY_ENCLOSED_BY': '&quot;',
      'error_on_column_count_mismatch': False,
      'NULL_IF': ('NULL', '', ' ', 'NULL', 'NULL', '//N', '\\N'),
      'RECORD_DELIMITER': '\n'
  </code></pre>