Page tree

Trifacta Dataprep


Contents:

On April 28, 2021, Google is changing the required permissions for attaching IAM roles to service accounts. If you are using IAM roles for your Google service accounts, please see Changes to User Management.

   

Feature Availability: This feature is available in Cloud Dataprep Premium by TRIFACTA® INC.

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.