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

Publish/Write

Publishing to this datastore is not supported in this release.

This page has no comments.