Page tree

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
DateYTIMESTAMP

NOTE: Date values without time information from Trifacta are written to Snowflake as Datetime values. This is a known issue.

DatetimeYTIMESTAMP
TimeYTIME
FloatYFLOAT
IntegerYBIGINT
MapN

StringYVARCHAR

This page has no comments.