Press Enter to see full results

ELT & CDC
Knowledge Base

Monitoring - Data Type Mapping - BigQuery

Generic Connectors

Source Data Type	Destination Data Type	Notes
INTEGER	INTEGER
NUMBER	BIGNUMERIC
STRING	STRING
DATETIME	DATETIME
BOOLEAN	BOOLEAN
ARRAY	JSON
OBJECT	JSON
*Others	STRING

Singer Connectors

Source Data Type	Destination Data Type	Notes
INTEGER	INTEGER
NUMBER	BIGNUMERIC
STRING	STRING
DATETIME	DATETIME
BOOLEAN	BOOLEAN
ARRAY	JSON
OBJECT	JSON
*Others	STRING

MySQL CDC

Source Data Type	Destination Data Type	Notes
BIGINT	INTEGER
BIGINT UNSIGNED	INTEGER
SMALLINT	INTEGER
SMALLINT UNSIGNED	INTEGER
TINYINT	INTEGER
INT	INTEGER
MEDIUMINT	INTEGER
YEAR	INTEGER
INT UNSIGNED	INTEGER
MEDIUMINT UNSIGNED	INTEGER
CHARACTER	STRING
VARCHAR	STRING
DATE	DATE
DATETIME	DATETIME
TIMESTAMP	TIMESTAMP
TIME	TIME
DOUBLE	FLOAT
DECIMAL	BIGDECIMAL
FLOAT	FLOAT
TEXT	VARCHAR
MEDIUMTEXT	VARCHAR
TINYTEXT	VARCHAR
LONGTEXT	VARCHAR
ENUM	VARCHAR
SET	VARCHAR
BINARY	VARCHAR
VARBINARY	VARCHAR
BIT	BIGINT
GEOMETRY	GEOGRAPHY
GEOMETRYCOLLECTION	GEOGRAPHY
MULTIPOINT	GEOGRAPHY
LINESTRING	GEOGRAPHY
MULTIPOLYGON	GEOGRAPHY
POINT	GEOGRAPHY
POLYGON	GEOGRAPHY
MULTILINESTRING	GEOGRAPHY
BLOB	STRING
TINYBLOB	STRING
MEDIUMBLOB	STRING
LONGBLOB	STRING
*Others	STRING

PostgreSQL CDC

Source Data Type	Destination Data Type	Notes
BIGINT	INTEGER
BIGSERIAL	INTEGER
BOOLEAN	BOOLEAN
CHARACTER	STRING
VARCHAR	STRING
TEXT	STRING
MONEY	STRING
USER DEFINED	STRING
DATE	DATE
DOUBLE PRECISION	FLOAT
INTEGER	INTEGER
SERIAL	INTEGER
NUMERIC	BIGNUMERIC
REAL	FLOAT
SMALLINT	INTEGER
SMALLSERIAL	INTEGER
TIME	TIME
TIME WITHOUT TIMEZONE	TIME
TIMESTAMP	TIMESTAMP
TIMESTAMP WITH TIMEZONE	TIMESTAMP
TIMESTAMP WITHOUT TIMEZONE	TIMESTAMP
JSON	JSON
JSONB	JSON
ARRAY	STRING
BIT VARYING	INTEGER
BIT	INTEGER
*Others	STRING