Snowflake 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 38 bit precision and scale. |
NUMBER (INT, INTEGER, BIGINT, SMALLINT, TINYINT, BYTEINT) | decimal | Number with 38 bit precision and scale as 0. Maximum value: 9.99999999999999E+37 Minimum value: -9.99999999999999E+36 |
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 (TEXT, CHAR, CHARACTER, STRING) | string | Maximum value: 16,777,216 Default value is 16,777,216. |