Data Type Mapping
Data Type Mappings
The provider 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 | bigint |
DECIMAL | decimal |
NUMERIC | decimal |
INT | bigint |
INTEGER | bigint |
BIGINT | bigint |
SMALLINT | bigint |
TINYINT | bigint |
BYTEINT | bigint |
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 |