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
bigserialYInteger
bit [ (n) ]YString
bit varying [ (n) ]YString
booleanYBool
boxYString
byteaYString
character varying(n), varchar(n)YString
character(n), char(n)YString
cidrYString
circleYString
compositeN 
dateYDate
daterangeN 
decimalYDecimal
double precisionYDecimal
enumN 
inetYString
int4rangeN 
int8rangeN 
integerYInteger
interval [ fields ] [ (p) ]YString
jsonYObject
lineN 
lsegYString
macaddrYString
moneyYDecimal
numericYDecimal/Integer
numrangeN 
oidN 
pathYString
pointYString
polygonYString
realYDecimal
serialYInteger
smallintYInteger
smallserialYInteger
textYString
time [ (p) ]YDate
time [ (p) ] with time zoneYString
timestamp [ (p) ]YDate
timestamp [ (p) ] with time zoneYDate
tsqueryYString
tsrangeN 
tstzrangeN 
tsvectorYString
txid_snapshotYString
uuidYString
xmlYString

Write/Publish

Trifacta Data Type

PostgreSQL Column TypeNotes
BoolBOOL 
 VARCHAR 
IntegerBIGINT 
 INT 
 SMALLINT 
 VARCHAR 
StringVARCHAR 
DatetimeTIMESTAMP 
 VARCHAR 
TimestampVARCHAR 
FloatDECIMAL 
 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 Trifacta platform writes unmapped types as String data type.

This page has no comments.