Data Integration Connectors
- Data Integration Connectors
- All Products
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.
|