Snowflake Connector Guide

Snowflake Connector Guide

Snowflake and Transformation Data Types

Snowflake and Transformation Data Types

The following table lists the Snowflake data types that Data Integration supports and the corresponding transformation data types:
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.


Updated November 07, 2019


Explore Informatica Network