Page tree

 

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

Trifacta Data Type

INTYInteger
TINYINTYInteger
SMALLINTYInteger
BIGINTYInteger
FLOATYFloat
REALYFloat
BITYBool
SMALLMONEYYString
MONEYYString
DECIMALYFloat
NUMERICYString
DATETIMEOFFSETYString
TIMEYString
DATEYString
DATETIMEYString
DATETIME2YString
SMALLDATETIMEYString
CHARYString
VARCHARYString
NCHARYString
NVARCHARYString
SYSNAMEYString
BINARYYString
VARBINARYYString
UNIQUEIDENTIFIERYString
TIMESTAMPN 
GEOGRAPHYN 
GEOMETRYN 
HIERARCHYIDN 
IMAGEN 
TEXTN 
NTEXTN 
XMLN 
CURSORN 
ROWVERSIONN 
SQL_VARIANTN 

Publish/Write

NOTE: By default, the maximum length of values published to VARCHAR columns is 256 characters. As needed, this limit can be changed for multiple publication targets. For more information, see Configure Application Limits.

Trifacta Data Type
SQL DW Data TypeNotes
StringVARCHAR 
IntegerBIGINT

 

FloatFLOAT 
BoolBIT 
DatetimeDATETIME2If a time-only value is published as an append to a pre-defined DATETIME2 column, then the output column is prepended with 1900-01-01.
Datetime (with time value only)TIMEIf a value is published as an append to a pre-defined TIME column, then any date information is dropped from the output.
DatetimeVARCHARIf a Datetime value is published as an append to a pre-defined VARCHAR column, then the output column contains the string value of whatever appears in the Transformer page.
MapVARCHAR 
ArrayVARCHAR 
DateVARCHAR 
All Other Data TypesVARCHAR 

This page has no comments.