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

BigintYInteger
BIGINT IDENTITYYInteger
BinaryYString (Base64)
BitYBool
CharYString
CursorN 
DateYDate
DatetimeYDate
Datetime2YDate
DatetimeoffsetYString
DecimalYInteger/Decimal
DECIMAL IDENTITYYInteger
FloatYDecimal
GEOGRAPHYYString
GEOMETRYYString
HIERARCHYIDYString
ImageYString
IntYInteger
INT IDENTITYYInteger
MoneyYDecimal
NcharYString
NtextYString
NumericYInteger/Decimal
NUMERIC IDENTITYYInteger
NvarcharYString
Nvarchar(max)YString
RealYDecimal
SmalldatetimeYDate
SmallintYInteger
SMALLINT IDENTITYYInteger
SmallmoneyYDecimal
Sql_variantN 
TableN 
TextYString
TimeYString
TimestampYString
TinyintYInteger
TINYINT IDENTITYYInteger
UniqueidentifierYString
VarbinaryYString (Base64)
Varbinary(max)YString (Base64)
VarcharYString
Varchar(max)YString
XmlYString

Write/Publish

Trifacta Data Type

SQL Server Column TypeNotes
BoolBIT 
 VARCHAR(256) 
IntegerBIGINT 
 INT 
 SMALLINT 
 DECIMAL 
 VARCHAR(256) 
StringVARCHAR(256) 
DatetimeDATETIME 
 TIMESTAMP 
 VARCHAR(256) 
TimestampTIME 
 VARCHAR(256) 
FloatFLOAT 
 DECIMAL 
 NUMERIC 
 VARCHAR(256) 
MapVARCHAR(256) 
ArrayVARCHAR(256) 


NOTE: If you are appending to an existing table where a column's Trifacta data type is not mapped to the column data type in the target table, a validation error is thrown, as the platform writes unmapped types as String data type.

This page has no comments.