Press Enter to see full results

ELT & CDC
Knowledge Base

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