Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Outdated release! Latest docs are Release 8.2: Postgres Data Type Conversions

   

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.

  • No labels

This page has no comments.