title: how to resolve syntax error using copy command from s3 to redshift db
body: <p>Syntax error in copy command from s3 to redshift</p>
  
  <p>I can connect to the the redshift database but get syntax error at tablename of copy command.  I'm using a csv file in s3 to schema.tblname in redshift</p>
  
  <pre><code>COPY ###_schema.tblName_csv
  FROM 's3://####/###/Filename.csv'
  CREDENTIALS 'aws_iam_role=arn:aws:iam::######'
  DATEFORMAT 'auto'
  IGNOREHEADER 1
  DELIMITER ','
  IGNOREBLANKLINES;
  </code></pre>
  
  <p>I'd like to be able to select * from this tbl after loading data</p>