title: Copy JSON column in Redshift
body: <p>I have to import a csv file in redshift from s3.
  One of the columns in the table is JSON format. </p>
  
  <p>While using COPY command, I get the following error - </p>
  
  <pre><code>Invalid timestamp format or value [YYYY-MM-DD HH24:MI:SS]   
  </code></pre>
  
  <p>The command used is -</p>
  
  <pre><code>COPY api_log FROM 's3://X/Y' credentials 'aws_access_key_id=;aws_secret_access_key=' delimiter ',' maxerror as 250 TRUNCATECOLUMNS;
  </code></pre>
  
  <p>COMMIT;       </p>
  
  <p>Sample data is -</p>
  
  <pre><code>c1 c2    c3
  
    X       Y     {a:b,c:d}
  </code></pre>