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

arrayN 
bigintYInteger
tinyintYInteger
mediumintYInteger
smallintYInteger
intYInteger
bit [ (n) ]YString
floatYFloat
numericYFloat
decimalYDecimal
realYFloat
booleanYBool
character varying(n), varchar(n)YString
character(n), char(n)YString
dateYDate
doubleYDecimal
enumN 
setN
jsonYString
textYString
tinytextYString
mediumtextYString
lontextYString
timeYDatetime
datetimeYDatetime
timestampYDatetime
yearYString

Write/Publish

Trifacta Data Type

PostgreSQL Column TypeNotes
BoolBIT 
 VARCHAR 

TINYINT(1)
IntegerBIGINT 
 INT 
 SMALLINT 

MEDIUMINT

TINYINT
 VARCHAR 
StringVARCHAR 

TINYTEXT

TEXT

MEDIUMTEXT

LONGTEXT
DatetimeTIMESTAMP 

DATETIME

DATE
 VARCHAR 
TimestampVARCHAR 
FloatFLOAT 
 DECIMAL 

REAL

NUMERIC
 VARCHAR 
MapVARCHAR 
ArrayVARCHAR 

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.