Snowflake Cloud Data Warehouse V2 Connector > Data type reference > Snowflake Cloud Data Warehouse V2 and transformation data types
  

Snowflake Cloud Data Warehouse V2 and transformation data types

The following table lists the Snowflake Cloud Data Warehouse V2 data types that Cloud Data Integration supports and the corresponding transformation data types:
Snowflake Cloud Data Warehouse V2 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.
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.
Not applicable for elastic mappings.
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.