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 (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.
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 (Char, Character, String, Text)	string	Maximum value: 16,777,216 You can increase the maximum precision value to 104,857,600. For more information about how to increase the maximum precision value, see the `VARCHAR_MAX_PRECISION` parameter in JDBC URL parameters.