title: SQL compilation error: JSON file format can produce one and only one column of type variant or object or array when copying from S3 to Snowflake
body: <p>I have the following JSON stored in S3:</p>
  <pre><code>{&quot;data&quot;:&quot;this is a test for firehose&quot;}
  </code></pre>
  <p>I have created the table <code>test_firehose</code> with a varchar column data, and a file_format called <code>JSON</code> with type JSON and the rest in default values. I want to copy the content from s3 to snowflake, and I have tried with the following statement:</p>
  <pre><code>COPY INTO test_firehose
  FROM 's3://s3_bucket/firehose/2020/12/30/09/tracking-1-2020-12-30-09-38-46'
  FILE_FORMAT = 'JSON';
  </code></pre>
  <p>And I receive the error:</p>
  <pre><code>    SQL compilation error: JSON file format can produce one and only one column of type 
  variant or object or array. Use CSV file format if you want to load more than one column.
  </code></pre>
  <p>How could I solve this? Thanks</p>