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