title: How to load s3 csv gz file to Redshift in Copy commd with backslash character
body: <p>one s3 file is *.csv.gz, it delimter as comma, but some rows have some special words.</p>
  
  <p>CSV file data sample:
  doc_key,doc_name,doc_brand,brand_inc,etl_load_date
  8a14eff760993c84d2306b3547fc6bea,VIRTUALLY CALIFORNIA,UNITED STATES OF AMERICA,UNKNOWN,2018-02-28
  1fd23373942c9ffcdfc7223cd1114ee1,"ARIZONA \"9\" LLC",UNITED STATES OF AMERICA,UNKNOWN,2018-02-28</p>
  
  <p>copy stg.train_ticket from 's3://{path}/'
  CREDENTIALS 'aws_access_key_id={aws_access_key_id};aws_secret_access_key={aws_secret_access_key}'
  TRIMBLANKS TRUNCATECOLUMNS ACCEPTINVCHARS dateformat as 'auto' 
  GZIP csv quote as '"' delimiter ',' IGNOREHEADER as 1;</p>
  
  <p>I ran the copy cmd on sqlworkbench and get error:
  An error occurred when executing the SQL command:
  copy stg.train_ticket from 's3://{path}/'
  CREDENTIALS 'aws_access_key_id={aws_access_key_id};aws_secret_access...</p>
  
  <p>Amazon Invalid operation: Load into table 'train_ticket ' failed.  Check 'stl_load_errors' system table for details.;
  1 statement failed.</p>
  
  <p>Checked this table stl_load_errors and detailed error info:
  column: doc_name
  err_reason: Invalid quote formatting for CSV
  raw_field_value: ARIZONA \
  err_code: 1214</p>
  
  <p>Could anyone please help take a look how to escape the backslash?</p>
  
  <p>Thanks
  Tom</p>