Monitoring - Data Type Mapping - Redshift

Generic Connectors

Source Data Type

Destination Data Type

Notes

INTEGER

BIGINT

 

NUMBER

DOUBLE PRECISION

 

 STRING

 VARCHAR

 

DATETIME

TIMESTAMP WITHOUT TIMEZONE

 

BOOLEAN

BOOLEAN

 

ARRAY

VARCHAR

 

OBJECT

VARCHAR

 

*Others

VARCHAR

 

Singer Connectors

Source Data Type

Destination Data Type

Notes

INTEGER

 BIGINT

 

NUMBER

 DOUBLE PRECISION

 

STRING

VARCHAR

 

DATETIME

TIMESTAMP WITHOUT TIMEZONE

 

BOOLEAN

BOOLEAN

 

ARRAY

VARCHAR

 

OBJECT

VARCHAR

 

*Others

VARCHAR

 

MySQL CDC

Source Data Type

Destination Data Type

Notes

BIGINT

BIGINT

 

BIGINT UNSIGNED

NUMERIC

 

SMALLINT

SMALLINT

 

SMALLINT UNSIGNED

INTEGER

 

TINYINT

SMALLINT

 

INT

INTEGER

 

MEDIUMINT

INTEGER

 

YEAR

INTEGER

 

INT UNSIGNED

BIGINT

 

MEDIUMINT UNSIGNED

BIGINT

 

CHARACTER

VARCHAR

 

VARCHAR

VARCHAR

 

DATE

DATE

 

DATETIME

TIMESTAMP WITHOUT TIMEZONE

 

TIMESTAMP

TIMESTAMP WITHOUT TIMEZONE

 

TIME

TIME WITH TIMEZONE

 

DOUBLE

DOUBLE PRECISION

 

DECIMAL

NUMERIC

 

FLOAT

REAL

 

TEXT

VARCHAR

 

MEDIUMTEXT

VARCHAR

 

TINYTEXT

VARCHAR

 

LONGTEXT

VARCHAR

 

ENUM

VARCHAR

 

SET

VARCHAR

 

BINARY

VARCHAR

 

VARBINARY

VARCHAR

 

BIT

BIGINT

 

GEOMETRY

GEOMETRY

 

GEOMETRYCOLLECTION

GEOMETRY

 

MULTIPOINT

GEOMETRY

 

LINESTRING

GEOMETRY

 

MULTIPOLYGON

GEOMETRY

 

POINT

GEOMETRY

 

POLYGON

GEOMETRY

 

MULTILINESTRING

GEOMETRY

 

BLOB

VARCHAR

 

TINYBLOB

VARCHAR

 

MEDIUMBLOB

VARCHAR

 

LONGBLOB

VARCHAR

 

*Others

VARCHAR

 

PostgreSQL CDC

Source Data Type

Destination Data Type

Notes

BIGINT

BIGINT

 

BIGSERIAL

BIGINT

 

BOOLEAN

BOOLEAN

 

CHARACTER

CHARACTER

 

VARCHAR

VARCHAR

 

TEXT

VARCHAR

 

MONEY

VARCHAR

 

USER DEFINED

VARCHAR

 

DATE

DATE

 

DOUBLE PRECISION

DOUBLE PRECISION

 

INTEGER

INTEGER

 

SERIAL

INTEGER

 

NUMERIC

NUMERIC

 

REAL

REAL

 

SMALLINT

SMALLINT

 

SMALLSERIAL

SMALLINT

 

TIME

TIME WITHOUT TIMEZONE

 

TIME WITHOUT TIMEZONE

TIME WITHOUT TIMEZONE

 

TIMESTAMP

TIMESTAMP WITHOUT TIMEZONE

 

TIMESTAMP WITH TIMEZONE

TIMESTAMP WITH TIMEZONE

 

TIMESTAMP WITHOUT TIMEZONE

TIMESTAMP WITHOUT TIMEZONE

 

JSON

VARCHAR

 

JSONB

VARCHAR

 

ARRAY

VARCHAR

 

BIT VARYING

VARCHAR

 

BIT

BIGINT

 

*Others

VARCHAR

 

SQL Server CDC

Source Data Type

Destination Data Type

Notes

 BIGINT

BIGINT

 

 BIT

BOOLEAN

 

CHAR

CHARACTER

 

VARCHAR

VARCHAR

 

DATE

DATE

 

FLOAT

DOUBLE PRECISION

 

INT

INTEGER

 

NUMERIC

NUMERIC

 

REAL

REAL

 

SMALLINT

SMALLINT

 

TIME

TIME WITHOUT TIMEZONE

 

*Others

VARCHAR

 

SalesForce CDC

Source Data Type

Destination Data Type

Notes

 ID

VARCHAR

 

REFERENCE

VARCHAR

 

EMAIL

VARCHAR

 

PHONE

VARCHAR

 

PICKLIST

VARCHAR

 

STRING

VARCHAR

 

TEXTAREA

VARCHAR

 

ADDRESS

VARCHAR

 

URL

VARCHAR

 

COMBOBOX

VARCHAR

 

DATETIME

TIMESTAMP WITH TIMEZONE

 

DATE

DATE

 

DOUBLE

DOUBLE PRECISION

 

PERCENT

VARCHAR

 

CURRENCY

VARCHAR

 

*Others

VARCHAR