Amazon Redshift Writer Feature Type: User Attributes

For information on the parameters in this dialog that are common to all readers, see:

For information on the parameters in this dialog that are common to all writers, see:

User attributes for this format are defined below.

Name

The name of the column to be written. Valid values for column name include any character string devoid of SQL offensive characters and less than 32 characters in length.
Type

The type of a column in a table. The valid values for the column type are listed below:

Closedbool

Represents logical Boolean values (true/false).

Closedchar

Represents a fixed-length character string of a specified length, including trailing blanks (if any). The maximum length is 4096 bytes. These strings are always padded with spaces, so a CHAR(10) column always occupies 10 bytes of storage.

Closeddate

Represents a calendar date (year, month, day). Use this type to store simple calendar dates without timestamps. It ranges from 4713 BC to 294276 AD with a resolution of 1 day.

Closedfloat4

Represents a single-precision floating-point number. This is an inexact storage type, meaning that values are stored as approximations and may result in slight discrepancies. It has up to 6 significant digits of precision.

Closedfloat8

Represents a double-precision floating-point number. This is an inexact storage type, meaning that values are stored as approximations and may result in slight discrepancies. It has up to 15 significant digits of precision.

Closedint2

Represents a signed 2-byte integer. It ranges from -32768 to +32767.

Closedint4

Represents a signed 4-byte integer. It ranges from -2147483648 to +2147483647.

Closedint8

Represents a signed 8-byte integer. It ranges from -9223372036854775808 to +9223372036854775807.

Closedtimestamp

Represents a complete timestamp value that includes the date and the time of day. The values are UTC, not local time. It ranges from 4173 BC to 294276 AD with a resolution of 1 microsecond (up to a maximum of 6 digits of precision for fractional seconds).

Closedvarchar

Represents a variable-length character string with a user-defined limit.

This type supports UTF-8 multibyte characters up to a maximum of 4bytes. So a VARCHAR(120) column consists of a maximum of

  • 120 single-byte characters,
  • 60 two-byte characters,
  • 40 three-byte characters, or
  • 30 four-byte characters.

The maximum length is 65535 bytes (64K – 1). VARCHAR values are not padded with spaces.