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

> Reference for data type mappings from database sources to Snowflake in Integrate.io ELT & CDC. Understand how source types map on replication.

## Data Type Mapping

### Generic Connectors

| **Source Data Type** | **Destination Data Type** | **Notes** |
| :------------------- | :------------------------ | :-------- |
| INTEGER              | NUMBER                    |           |
| NUMBER               | DOUBLE                    |           |
| STRING               | TEXT                      |           |
| DATETIME             | TIMESTAMP TZ              |           |
| BOOLEAN              | BOOLEAN                   |           |
| ARRAY                | VARIANT                   |           |
| 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               | BINARY                    |           |
| VARBINARY            | BINARY                    |           |
| BIT                  | BINARY                    |           |
| GEOMETRY             | VARIANT                   |           |
| GEOMETRYCOLLECTION   | VARIANT                   |           |
| MULTIPOINT           | VARIANT                   |           |
| LINESTRING           | VARIANT                   |           |
| MULTIPOLYGON         | VARIANT                   |           |
| POINT                | VARIANT                   |           |
| POLYGON              | VARIANT                   |           |
| MULTILINESTRING      | VARIANT                   |           |
| BLOB                 | BINARY                    |           |
| TINYBLOB             | BINARY                    |           |
| MEDIUMBLOB           | BINARY                    |           |
| LONGBLOB             | BINARY                    |           |
| JSON                 | 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                    |           |
| DECIMAL              | NUMBER                    |           |
| TIME                 | TIME                      |           |
| BIT                  | VARIANT                   |           |
| \*Others             | TEXT                      |           |

### Salesforce CDC

| **Source Data Type** | **Destination Data Type** | **Notes** |
| :------------------- | :------------------------ | :-------- |
| ID                   | TEXT                      |           |
| REFERENCE            | TEXT                      |           |
| EMAIL                | TEXT                      |           |
| PHONE                | TEXT                      |           |
| PICKLIST             | TEXT                      |           |
| STRING               | TEXT                      |           |
| TEXTAREA             | TEXT                      |           |
| ADDRESS              | TEXT                      |           |
| URL                  | TEXT                      |           |
| COMBOBOX             | TEXT                      |           |
| DATETIME             | TEXT                      |           |
| DATE                 | DATE                      |           |
| DOUBLE               | FLOAT                     |           |
| PERCENT              | NUMBER                    |           |
| CURRENCY             | NUMBER                    |           |
| \*Others             | TEXT                      |           |

### Salesforce V2 (from version 1.2.19)

| Source Data Type           | Destination Data Type | Notes                                      |
| :------------------------- | :-------------------- | :----------------------------------------- |
| address                    | VARIANT               |                                            |
| anyType                    | VARIANT               |                                            |
| base64                     | TEXT                  |                                            |
| boolean                    | BOOLEAN               |                                            |
| byte                       | TEXT                  |                                            |
| calculated                 | VARIANT               |                                            |
| combobox                   | TEXT                  |                                            |
| currency                   | FLOAT                 | FLOAT and NUMBER are synonyms in Snowflake |
| datacategorygroupreference | TEXT                  |                                            |
| date                       | DATE                  |                                            |
| datetime                   | TIMESTAMP\_NTZ        |                                            |
| double                     | FLOAT                 |                                            |
| email                      | TEXT                  |                                            |
| encryptedstring            | TEXT                  |                                            |
| id                         | TEXT                  |                                            |
| int                        | NUMBER                |                                            |
| json                       | VARIANT               |                                            |
| location                   | VARIANT               |                                            |
| long                       | NUMBER                |                                            |
| masterrecord               | TEXT                  |                                            |
| multipicklist              | VARIANT               |                                            |
| percent                    | FLOAT                 | FLOAT and NUMBER are synonyms in Snowflake |
| phone                      | TEXT                  |                                            |
| picklist                   | TEXT                  |                                            |
| reference                  | TEXT                  |                                            |
| string                     | TEXT                  |                                            |
| textarea                   | TEXT                  |                                            |
| time                       | TIME                  |                                            |
| url                        | TEXT                  |                                            |

### File Storage Taps (S3 Source)

| **Source Data Type** | **Destination Data Type** | **Notes**     |
| :------------------- | :------------------------ | :------------ |
| STRING               | TEXT                      | default value |
| BOOLEAN              | BOOLEAN                   |               |
| NUMBER               | DOUBLE                    |               |
| INTEGER              | NUMBER                    |               |
| ARRAY                | VARIANT                   |               |
| OBJECT               | VARIANT                   |               |
| BIGINT               | NUMBER                    |               |
| DATE                 | TIMESTAMP\_NTZ            |               |
| DATETIME             | TIMESTAMP\_TZ             |               |