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

Table 1. Snowflake Data Types
Snowflake Data Type ODBC Data Type
ARRAY SQL_VARCHAR
BIGINT1 SQL_NUMERIC
BINARY SQL_BINARY
BOOLEAN SQL_BIT
CHAR SQL_VARCHAR
DATE SQL_TYPE_DATE
DECIMAL SQL_DECIMAL
DOUBLE SQL_DOUBLE
FLOAT SQL_DOUBLE
INTEGER1 SQL_NUMERIC
NUMBER SQL_DECIMAL
OBJECT SQL_VARCHAR
REAL SQL_DOUBLE
TIME SQL_TYPE_TIME
TIMESTAMP SQL_TYPE_TIMESTAMP
TIMESTAMP_LTZ SQL_TYPE_TIMESTAMP
TIMESTAMP_NTZ SQL_TYPE_TIMESTAMP
TIMESTAMP_TZ SQL_TYPE_TIMESTAMP
VARBINARY SQL_BINARY
VARCHAR SQL_VARCHAR
VARIANT SQL_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 Integer Field Mapping option to map this type and other such types to BIGINT.