Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Amazon Redshift connectors
  3. Part 2: Data Integration with Amazon Redshift V2 Connector
  4. Part 3: Data Integration with Amazon Redshift Connector

Amazon Redshift Connectors

Amazon Redshift Connectors

Octal values as DELIMITER and QUOTE

Octal values as DELIMITER and QUOTE

In addition to printable ASCII characters, you can use octal values for printable and non-printable ASCII characters as DELIMITER and QUOTE.
To use a printable character as DELIMITER or QUOTE, you can either specify the ASCII character or the respective octal value. However, to use a non-printable character as DELIMITER or QUOTE, you must specify the respective octal value.
Example for a printable character:
DELIMITER=#
or
DELIMITER=\043
Example for a non-printable character, file separator:
QUOTE=\034
Octal values 000-037 and 177 represent non-printable characters and 040-176 represent printable characters. The following table lists the recommended octal values, for QUOTE and DELIMITER in the Copy command and as DELIMITER in the Unload command, supported by Amazon Redshift:
Command Option
Recommended Octal Values
COPY QUOTE
001-010, 016-037, 041-054, 057, 073-100,133, 135-140, 173-177
COPY DELIMITER
001-011, 013, 014, 016, 017, 020-046, 050-054, 057, 073-133, 135-177
UNLOAD DELIMITER
001-011, 013, 014, 016, 017, 020-041, 043-045, 050-054, 056-133, 135-177