ODBC Driver for Snowflake

Supported Data Types - ODBC Driver for Snowflake



Data Type Mapping

The Devart ODBC Driver for Snowflake supports all Snowflake data types.

The following table describes how the Snowflake data types are mapped to the ODBC data types.

Snowflake Data Types ODBC Data Types

NUMBER

NUMERIC

SQL_NUMERIC

DECIMAL

SQL_DECIMAL

TINYINT

BYTEINT

SQL_TINYINT

SMALLINT

SQL_SMALLINT

INTEGER

INTE

SQL_INTEGER

BIGINT

SQL_BIT

DOUBLE

DOUBLE PRECISION

SQL_DOUBLE

FLOAT

FLOAT4

FLOAT8

SQL_FLOAT

REAL

SQL_REAL

CHAR, CHARACTER

SQL_CHAR

VARCHAR

STRING

TEXT

Length <= 4000: SQL_VARCHAR

Length > 4000: SQL_LONGVARCHAR

VARBINARY

BINARY

Length <= 4000: SQL_VARBINARY

Length > 4000: SQL_LONGVARBINARY

BOOLEAN

SQL_BIT

DATE

SQL_DATE

TIME

SQL_TIME

DATETIME

TIMESTAMP

TIMESTAMP_NTZ

TIMESTAMP_LTZ

TIMESTAMP_TZ

SQL_TIMESTAMP

PICKLIST

VARIANT

OBJECT

ARRAY

GEOGRAPHY

SQL_LONGVARCHAR

© 2015-2022 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback