Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

NOTE: The

D s item
itemdata types
rtrue
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

D s item
itemData Type

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

D s item
itemData Type

SupportedSnowflake TypeNotes

Array

N
 


BoolYBOOLEAN
DateY
DATE
TIMESTAMP


Info

NOTE: Date values without time information from

D s product
are written to Snowflake as Datetime values. This is a known issue.


DatetimeYTIMESTAMP
TimeYTIME
FloatYFLOAT
IntegerYBIGINT
MapN
 


StringYVARCHAR