Page tree

Trifacta SaaS



Contents:


   

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

See below.

DatetimeYTIMESTAMP
TimeYTIME
FloatYFLOAT
IntegerYBIGINT
MapN 
StringYVARCHAR

Notes on Date publishing:


NOTE: Trifacta Date columns 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.

Trifacta date format

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
  • On publication, all dates are written in the following format: yyyy-mm-dd
  • No other date formats are supported for writing to Snowflake as date values.


This page has no comments.