Data Type Mapping
Data Type Mappings
The driver maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings.
NOTE: In Snowflake, the type fetched can differ from the type used to create a field. Set SessionParameters to JDBC_TREAT_DECIMAL_AS_INT=false to map INT types to DECIMAL and avoid this behavior.
| Data Source | Data Type |
| NUMBER | decimal |
| DECIMAL | decimal |
| NUMERIC | decimal |
| INT | decimal |
| INTEGER | decimal |
| BIGINT | decimal |
| SMALLINT | decimal |
| TINYINT | decimal |
| BYTEINT | decimal |
| DOUBLE | real |
| FLOAT | real |
| FLOAT4 | real |
| FLOAT8 | real |
| DOUBLEPRECISION | real |
| REAL | real |
| VARCHAR | varchar |
| CHAR | varchar |
| STRING | varchar |
| TEXT | varchar |
| BINARY | binary |
| VARBINARY | binary |
| BOOLEAN | bool |
| DATE | date |
| DATETIME | datetime |
| TIME | time |
| TIMESTAMP | datetime |
| TIMESTAMP_LTZ | datetime |
| TIMESTAMP_NTZ | datetime |
| TIMESTAMP_TZ | datetime |
| VARIANT | varchar |
| OBJECT | varchar |
| ARRAY | varchar |
| GEOGRAPHY | varchar |