Page tree

Trifacta Dataprep



Contents:

If you licensed Dataprep by Trifacta before Oct. 14, 2020, you are using the Dataprep by Trifacta Legacy product edition. On October 14, 2022, this product edition will be decommissioned by Google and will be no longer available for use. Current customers of this product edition are encouraged to transition to one of the product editions hosted by Trifacta. See Product Editions.

   

Feature Availability: This feature is available in the following editions:

  • Dataprep by Trifacta® Enterprise Edition
  • Dataprep by Trifacta Professional Edition
  • Dataprep by Trifacta Premium
  • Dataprep by Trifacta Standard

This section covers data type conversions between the Trifacta® application and PostgreSQL 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

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 
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 platform writes unmapped types as String data type.

See Also for Postgres Data Type Conversions:

This page has no comments.