Page tree

Trifacta Dataprep


Contents:

On April 28, 2021, Google is changing the required permissions for attaching IAM roles to service accounts. If you are using IAM roles for your Google service accounts, please see Changes to User Management.

   

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

  • Cloud Dataprep Premium by TRIFACTA® INC.
  • Cloud Dataprep Standard by TRIFACTA INC.


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.

This page has no comments.