Page tree

 

Contents:


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

Notes
INTYInteger 
TINYINTYInteger 
SMALLINTYInteger 
BIGINTYInteger

NOTE: The Trifacta platform may infer bigint columns containing very large or very small values as String data type.If needed, you can disable type inference for individual schematized sources. For more information, see Import Data Page.

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  

Write/Publish

Create new table

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

NOTE: The Trifacta platform may infer Integer columns containing very large or very small values as String data type. Before you publish, you should verify that your columns containing extreme values are interpreted as Integer type.You can import a target schema to assist in lining up your columns with the expected target. For more information, see Overview of RapidTarget.

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

If a value is published as an append to a pre-defined TIME column, then any date information is dropped from the output.

NOTE: The platform publishes to Timestamp columns only for append operations to pre-existing tables.


DatetimeVARCHAR

If 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.

When you publish results from a job through the Publishing dialog to SQL DW, all Datetime column values are written as String type.

MapVARCHAR 
ArrayVARCHAR 
DateVARCHAR 
All Other Data TypesVARCHAR 

Append to existing table

If you are publishing to a pre-existing table, the following data type conversions apply:

  • Columns: Trifacta data types
  • Rows: Target table data types

In any table cell, a Y indicates that the append operation for that data type mapping is supported.

 StringIntegerDatetimeBoolFloatMapArray
VARCHARYYYYYYY
NVARCHARYYYYYYY
CHARYYYYYYY
NCHARYYYYYYY
TINYINT       
SMALLINT       
INT       
BIGINT Y     
DATETIME2  Y    
TIME  Y    
BIT   Y   
FLOAT Y  Y  
REAL Y  Y  
DECIMAL Y  Y  

This page has no comments.