Monitoring - Data Type Mapping - Snowflake

Generic Connectors

Source Data Type

Destination Data Type

Notes

STRING

TEXT

 

OBJECT

VARIANT

 

NUMBER

DOUBLE

 

INTEGER

NUMBER

 

DATETIME

TIMESTAMP TZ

 

BOOLEAN

BOOLEAN

 

ARRAY

VARIANT

 

*Others

TEXT

 

Singer Connectors

Source Data Type

Destination Data Type

Notes

INTEGER

NUMBER

 

NUMBER

DOUBLE

 

STRING

TEXT

 

DATETIME

TIMESTAMP TZ

 

BOOLEAN

BOOLEAN

 

ARRAY

VARCHAR

 

OBJECT

VARIANT

 

*Others

TEXT

 

MySQL CDC

Source Data Type

Destination Data Type

Notes

BIGINT

NUMBER

 

BIGINT UNSIGNED

NUMBER

 

SMALLINT

NUMBER

 

SMALLINT UNSIGNED

NUMBER

 

TINYINT

NUMBER

 

INT

NUMBER

 

MEDIUMINT

NUMBER

 

YEAR

NUMBER

 

INT UNSIGNED

NUMBER

 

MEDIUMINT UNSIGNED

NUMBER

 

CHARACTER

TEXT

 

VARCHAR

TEXT

 

DATE

DATE

 

DATETIME

TIMESTAMP TZ

 

TIMESTAMP

TIMESTAMP TZ

 

TIME

TIME

 

DOUBLE

FLOAT

 

DECIMAL

FLOAT

 

FLOAT

FLOAT

 

TEXT

TEXT

 

MEDIUMTEXT

TEXT

 

TINYTEXT

TEXT

 

LONGTEXT

TEXT

 

ENUM

TEXT

 

SET

TEXT

 

BINARY

VARIANT

 

VARBINARY

VARIANT

 

BIT

VARIANT

 

GEOMETRY

VARIANT

 

GEOMETRYCOLLECTION

VARIANT

 

MULTIPOINT

VARIANT

 

LINESTRING

VARIANT

 

MULTIPOLYGON

VARIANT

 

POINT

VARIANT

 

POLYGON

VARIANT

 

MULTILINESTRING

VARIANT

 

BLOB

VARIANT

 

TINYBLOB

VARIANT

 

MEDIUMBLOB

VARIANT

 

LONGBLOB

VARIANT

 

*Others

TEXT

 

PostgreSQL CDC

Source Data Type

Destination Data Type

Notes

BIGINT

NUMBER

 

BIGSERIAL

NUMBER

 

BOOLEAN

BOOLEAN

 

CHARACTER

TEXT

 

VARCHAR

TEXT

 

TEXT

NUMBER

 

MONEY

NUMBER

 

USER DEFINED

NUMBER

 

DATE

DATE

 

DOUBLE PRECISION

FLOAT

 

INTEGER

NUMBER

 

SERIAL

NUMBER

 

NUMERIC

NUMBER

 

REAL

FLOAT

 

SMALLINT

NUMBER

 

SMALLSERIAL

NUMBER

 

TIME

TIME

 

TIME WITHOUT TIMEZONE

VARIANT

 

TIMESTAMP

TIMESTAMP

 

TIMESTAMP WITH TIMEZONE

TIMESTAMP TZ

 

TIMESTAMP WITHOUT TIMEZONE

TIMESTAMP NTZ

 

JSON

VARIANT

 

JSONB

VARIANT

 

ARRAY

VARIANT

 

BIT VARYING

VARIANT

 

BIT

VARIANT

 

*Others

TEXT

 

SQL Server CDC

Source Data Type

Destination Data Type

Notes

BIGINT

NUMBER

 

INT

NUMBER

 

SMALLINT

NUMBER

 

VARCHAR

TEXT

 

TEXT

TEXT

 

MONEY

TEXT

 

DATE

DATE

 

REAL

FLOAT

 

FLOAT

FLOAT

 

NUMERIC

NUMBER

 

TIME

TIME

 

BIT

VARIANT

 

*Others

TEXT

 

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

VARCHAR

 

DATE

DATE

 

DOUBLE

DOUBLE PRECISION

 

PERCENT

BIGINT

 

CURRENCY

BIGINT

 

*Others

VARCHAR