Redshift Datatype Mapping
  • 1 Minute to read
  • Dark
    Light
  • PDF

Redshift Datatype Mapping

  • Dark
    Light
  • PDF

Type Mapping

We match Redshift data types to Rivery data types as we extract your data.

The following table shows the mapping of Redshift data types to Rivery-compatible types:

Redshift TypeRivery Type
INTERVALTIMESTAMP
DOUBLE_PRECISIONFLOAT
FLOATFLOAT
CHARSTRING
DATEDATE
VARCHARSTRING
TIMESTAMPTIMESTAMP
ENUMSTRING
BOOLEANBOOLEAN
ARRAYSTRING
arraySTRING
BYTEASTRING
BITBOOLEAN
REALFLOAT
BIGINTINTEGER
TEXTSTRING
SMALLINTINTEGER
NUMERICFLOAT
INTEGERINTEGER
CIDRSTRING
DropEnumTypeSTRING
INETSTRING
MACDDRSTRING
OIDSTRING
TSVECTORSTRING
UUIDSTRING
DATERANGEINTEGER
INT4RANGEINTEGER
INT8RANGEINTEGER
JSONSTRING
JSONBSTRING
NUMRANGEFLOAT
TSRANGEFLOAT
HSTORESTRING
SUPERJSON

Was this article helpful?