Snowflake Data Cloud Connector

Back Next

Snowflake Data Cloud and transformation data types

The following table lists the Snowflake data types that Data Integration supports and the corresponding transformation data types:

Snowflake Data Cloud Data Type	Transformation Data Type	Range and Description
Binary (Varbinary)	binary	Maximum value: 8,388,60 Default value is 8,388,60.
Boolean	string	A Boolean attribute.
Date	datetime	Date and time values.
Float (Double, Double precision, Real, Float, Float4, Float8)	double	Floating point numbers with double-precision (64 bit). Maximum value: 1.7976931348623158e+307 Minimum value: -1.79769313486231E+307
Number (Decimal, Numeric)	decimal	Number with 28-bit precision and scale for mappings. Number with 38-bit precision and scale for mappings in advanced mode.
NUMBER (Int, Integer, Bigint, Smallint, Tinyint, Byteint)	decimal	Number with 28-bit precision and scale as 0. Maximum value: 9.99999999999999E+27 Minimum value: -9.99999999999999E+26
Time	datetime	Date and time values. This data type doesn't apply to mappings in SQL ELT mode and mappings in advanced mode.
Timestamp_LTZ	datetime	Date and time values.
Timestamp_NTZ (Timestamp_NTZ, datetime)	datetime	Date and time values.
Timestamp_TZ	datetime	Date and time values.
Varchar (Text, Char, Character, String)	string	Maximum value: 16,777,216 Default value is 16,777,216.