title: How to solve error "Field delimiter ',' found while expecting record delimiter '\n'" while loading json data to the stage
body: <p>I am trying to &quot;COPY INTO&quot; command to load data from s3 to the snowflake</p>
  <p>Below are the steps I followed to create the stage and loading file from stage to Snowflake</p>
  <h3>JSON file</h3>
  <pre class="lang-json prettyprint-override"><code>{
     &quot;Name&quot;:&quot;Umesh&quot;,
     &quot;Desigantion&quot;:&quot;Product Manager&quot;,
     &quot;Location&quot;:&quot;United Kingdom&quot;
  }
  </code></pre>
  <pre class="lang-sql prettyprint-override"><code>create or replace stage emp_json_stage
  url='s3://mybucket/emp.json'
  credentials=(aws_key_id='my id' aws_secret_key='my key');
  
  # create the table with variant
  CREATE TABLE emp_json_raw (
    json_data_raw VARIANT
  );
  
  #load data from stage to snowflake
  
  COPY INTO emp_json_raw from @emp_json_stage;
  </code></pre>
  <p>I am getting below error</p>
  <blockquote>
  <p>Field delimiter ',' found while expecting record delimiter '\n' File
  'emp.json', line 2, character 18 Row 2, column
  &quot;emp_json_raw&quot;[&quot;JSON_DATA_RAW&quot;:1]</p>
  </blockquote>
  <p>I am using a simple JSON file, and I don't understand this error.</p>
  <p>What causes it and how can I solve it?</p>