Supported Snowflake data types

Datatype

Generic SQL datatype

Java datatype for modification

ARRAY

ARRAY

not supported

BIGINT

NUMERIC

java.math.BigDecimal

BINARY

BINARY

java.lang.byte[]

BOOLEAN

BOOLEAN

java.math.BigDecimal

BYTEINT

NUMERIC

java.math.BigDecimal

CHAR

VARCHAR

java.lang.String

CHARACTER

VARCHAR

java.lang.String

DATE

DATE

de.ubs.xdm.utils.core.HighPrecisionTimestamp

DATETIME

TIMESTAMP

de.ubs.xdm.utils.core.HighPrecisionTimestamp

DECIMAL

NUMERIC

java.math.BigDecimal

DOUBLE

FLOAT

java.math.BigDecimal

DOUBLE PRECISION

FLOAT

java.math.BigDecimal

FLOAT

FLOAT

java.math.BigDecimal

FLOAT4

FLOAT

java.math.BigDecimal

FLOAT8

FLOAT

java.math.BigDecimal

GEOGRAPHY

GEOGRAPHY

java.lang.String

INTEGER

NUMERIC

java.math.BigDecimal

NUMBER

NUMERIC

java.math.BigDecimal

NUMERIC

NUMERIC

java.math.BigDecimal

REAL

FLOAT

java.math.BigDecimal

SMALLINT

NUMERIC

java.math.BigDecimal

STRING

VARCHAR

java.lang.String

TEXT

VARCHAR

java.lang.String

TIME

TIME

de.ubs.xdm.utils.core.HighPrecisionTimestamp

TIMESTAMP_LTZ

TIMESTAMP_LTZ

not supported

TIMESTAMP_NTZ

TIMESTAMP

de.ubs.xdm.utils.core.HighPrecisionTimestamp

TIMESTAMP_TZ

TIMESTAMP_WITH_TIMEZONE

de.ubs.xdm.utils.core.HighPrecisionTimestamp

TINYINT

NUMERIC

java.math.BigDecimal

VARBINARY

BINARY

java.lang.byte[]

VARCHAR

VARCHAR

java.lang.String