You are here:
Data Type Compatibility in Data Federation
When federating data from external sources, the source data is converted to the corresponding Data 360 data types. If the source data contains a data type that's not supported in Data 360, the column is ignored. During data stream creation, fields whose data types aren’t supported in Data 360 are listed under the Unsupported Fields tab. Array, struct, and other nested datatypes are not supported in data federation.
Mapping Snowflake Data Types with Data 360 Data Types
| Snowflake Data type | Data 360 Data Type |
|---|---|
| NUMBER, DECIMAL, NUMERIC | Number |
| INT, INTEGER, SMALLINT, TINYINT, BYTEINT | Number |
| BIGINT | Number |
| FLOAT, FLOAT4, FLOAT8, DOUBLE, DOUBLE PRECISION, REAL | Number |
| VARCHAR, CHAR, CHARACTER, STRING, TEXT | Text |
| DATETIME, TIMESTAMP, TIMESTAMP_LTZ, TIMESTAMP_NTZ, TIMESTAMP_TZ | DateTime |
| DATE | Date |
| BOOLEAN | Boolean |
| TIME | Not supported |
| VARIANT, OBJECT, ARRAY, GEOGRAPHY, GEOMETRY | Not supported |
| BINARY, VARBINARY | Not supported |
Mapping Google BigQuery Data Types with Data 360 Data Types
| Google BigQuery Data type | Data 360 Data Type |
|---|---|
| BIGNUMERIC | Number |
| FLOAT64 | Number |
| INT64 | Number |
| NUMERIC | Number |
| STRING | Text |
| DATE | Date |
| DATETIME | DateTime |
| TIMESTAMP | DateTime |
| BOOL | Boolean |
| BYTES | Not Supported |
| TIME | Not Supported |
Mapping Redshift Data Types with Data 360 Data Types
| Redshift Data type | Data 360 Data Type |
|---|---|
| SMALLINT | Number |
| INTEGER | Number |
| BIGINT | Number |
| DECIMAL | Number |
| REAL | Number |
| DOUBLE PRECISION | Number |
| CHAR | Text |
| VARCHAR | Text |
| DATE | Date |
| TIMESTAMP | DateTime |
| TIMESTAMPZ | DateTime |
| BOOL | Boolean |
| GEOMETRY | Not Supported |
| GEOGRAPHY | Not Supported |
| HLLSKETCH | Not Supported |
| TIME | Not Supported |
| TIMETZ | Not Supported |
| VARBYTE | Not Supported |
Mapping Databricks Data Types with Data 360 Data Types
| Databricks Data type | Data 360 Data Type |
|---|---|
| BIGINT | Number |
| SMALLINT | Number |
| INT | Number |
| TINYINT | Number |
| DECIMAL(p,s) | Number |
| DOUBLE | Number |
| FLOAT | Number |
| STRING | Text |
| DATE | Date |
| DATETIME | DateTime |
| TIMESTAMP | DateTime |
| INTERVAL | Not Supported |
| ARRAY | Not Supported |
| BOOL | Boolean |
| STRUCT | Not Supported |
| MAP | Not Supported |
Did this article solve your issue?
Let us know so we can improve!
