ADO.NET Provider for Snowflake

Build 24.0.9060

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060