The following table lists data types supported by the driver and how they are mapped to JDBC data types.

See "getTypeInfo()" for getTypeInfo() results of data types supported by the driver.

Table 1. Snowflake Data Types
Snowflake Data Type JDBC Data Type
ARRAY VARCHAR
BIGINT1 NUMERIC
BINARY BINARY
BOOLEAN BOOLEAN
CHAR VARCHAR
DATE DATE
DECIMAL DECIMAL
DOUBLE DOUBLE
FLOAT DOUBLE
INTEGER1 NUMERIC
NUMBER DECIMAL
OBJECT VARCHAR
REAL DOUBLE
TIME TIME
TIMESTAMP TIMESTAMP
TIMESTAMPLTZ TIMESTAMP
TIMESTAMPNTZ TIMESTAMP
TIMESTAMPTZ TIMESTAMP
VARBINARY BINARY
VARCHAR VARCHAR
VARIANT VARCHAR
1 This data type is a fixed-point number type for which precision and scale cannot be specified. By default, this data type maps to NUMERIC. However, you may use the IntegerFieldMapping property to map this type and other such types to BIGINT.