A single ASCII character to separate fields in the input file. You can use characters such as pipe (|), tilde (~), or a tab (\t). The delimiter must not be a part of the data. Default is \036, the octal representation of the non-printable character, record separator.

Loads data into VARCHAR columns even if the data contains UTF-8 characters that are not valid. When you specify ACCEPTINCHARS, the replaces UTF-8 character that is not valid with an equal length string consisting of the character specified in ACCEPTINVCHARS. If you have specified '|' in ACCEPTINVCHARS, the replaces the three-byte UTF-8 character with '|||'.

Specifies the quote character to use with comma separated values. Default is \037, the octal representation of the non-printable character, unit separator.

Overrides current compression encoding and applies compression to an empty table. Use the COMPUPDATE option in an insert operation when the rows in a table are more than 100,000. The behavior of COMPUPDATE depends on how it is configured:

If you do not specify COMPUPDATE, the COPY command applies compression if the target table is empty and all columns in the table have either RAW or no encoding.
If you specify COMPUPDATE ON, the COPY command replaces the existing encodings if the target table is empty and the columns in the table have encodings other than RAW.
If you specify COMPUPDATE OFF, the COPY command does not apply compression.

Specify the Amazon Redshift Role Resource Name (ARN) to run the on installed on an Amazon EC2 system in the following format:

AWS_IAM_ROLE=arn:aws:iam::<account ID>:role/<role-name>

If you specify STATUPDATE ON, the COPY command updates the statistics even if the table is empty or not. Ensure that the current user is either the table owner or a superuser for the COPY command to work.
If you specify STATUPDATE OFF, the COPY command does not update the statistics.
If you do not specify STATUPDATE, the COPY command requires the insert permissions.