Page tree


Contents:

   

Feature Availability: This feature may not be available in all product editions. For more information on available features, see Compare Editions.

This section covers data type conversions between the Designer Cloud® application and SQL Server databases.

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)
StringNVARCHAR

VARCHAR(256)
DatetimeDATETIME

DATETIME2

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.

See Also for SQL Server Data Type Conversions:

This page has no comments.