Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Outdated release! Latest docs are Release 8.2: Snowflake Data Type Conversions

   

NOTE: The Trifacta® data types 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

Trifacta Data 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

Trifacta Data Type

SupportedSnowflake TypeNotes

Array

N 
BoolYBOOLEAN
DateYDATE
DatetimeYTIMESTAMP
TimeYTIME
FloatYFLOAT
IntegerYBIGINT
MapN 
StringYVARCHAR

  • No labels

This page has no comments.