This section covers data type conversions between the and Snowflake databases.

NOTE: The listed in this page reflect the raw data type of the converted column. Depending on the contents of the column, the Transformer Page may re-infer a different data type, when a dataset using this type of source is loaded.

Access/Read

Source TypeSupported

NUMBER

YInteger
DECIMALYInteger
NUMERICYInteger
INTYInteger
INTEGERYInteger
BIGINTYInteger
SMALLINTYInteger
FLOATYDecimal
FLOAT4YDecimal
FLOAT8YDecimal
DOUBLEYDecimal
DOUBLE_PRECISIONYDecimal
REALYDecimal
VARCHARYString
CHARYString
CHARACTERYString
STRINGYString
TEXTYString
BINARYYString
VARBINARYYString
BOOLEANYBool
DATEYString
DATETIMEYString
TIMEYString
TIMESTAMPYString
TIMESTAMP_TZY

Datetime

TIMESTAMP_LTZY 1)

Datetime

TIMESTAMP_NTZ Y 2)

Datetime

VARIANTN 
OBJECTN 
ARRAYN 

Notes:

  1. Convert to Datetime using local timezone of the Snowflake connector
  2. Convert to Datetime using UTC

Write/Publish

SupportedSnowflake TypeNotes

Array

N 
BoolYBOOLEAN
DateYTIMESTAMP

See below.

DatetimeYTIMESTAMP
TimeYTIME
FloatYFLOAT
IntegerYBIGINT
MapN 
StringYVARCHAR

Notes on Date publishing:


NOTE: can be published to existing Snowflake columns of Date, Datetime, and String type.

When Dates are published to Snowflake, the following date formats are supported. In some cases, missing data is inserted into the output value.

Snowflake date format

yy-dd-mm

yy-dd-mm
yy-mm-ddyy-mm-dd
dd-mm-yydd-mm-yy
mm-dd-yymm-dd-yy
mm-yymm-yy
dd-mm1970-dd-mm
mm-dd1970-mm-dd
mm-yymm-yy-01