> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# ELT/CDC: Monitoring - Data Type Mapping - BigQuery

> Reference for data type mappings from database sources to Google BigQuery in Integrate.io ELT & CDC. Understand type conversions during sync.

### 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                |       |

### 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                |       |