Ignoreheader CSV file using Redshift

Question

I am copying a CSV file into a redshift table but I keep getting an error because it is infering the header of the csv file. Is there any way to ignore the header when loading csv files into redshift. I am new to redshift so all the help would be appreciated.

Here is my copy statement:

copy db.table1
from 's3://path/203.csv'
credentials 'mycrednetials'
csv
ignoreheader
delimiter ','
region 'us-west-2' ;

Any input would highly be appreciated.

Answer 1

Try this:

copy db.table1
from 's3://path/203.csv'
credentials 'mycrednetials'
csv
ignoreheader 1
delimiter ','
region 'us-west-2' ;