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

BYTE[(n)]N 
VARBYTE[(n)]N 
BYTEINTY Integer
SMALLINTYInteger 
BIGINTYInteger 
INTEGERYInteger 
DECIMAL [(n[,m])]YDecimal 
NUMERIC [(n[,m])]YDecimal
REALYDecimal
DOUBLE PRECISIONYDecimal
FLOATYDecimal
NUMBER(n[,m])YDecimal 
NUMBER[(*[,m])]YDecimal
DATEYString 
Time(0)YDatetime 
Time(0) WITH TIME ZONEYDatetime 
TIME (n)YString
TIME (n) WITH TIME ZONEYString
TIMESTAMP (0)YString
Timestamp(0) WITH TIME ZONEYDatetime
TIMESTAMP (n)YDatetime
TIMESTAMP (n) WITH TIME ZONEYString
INTERVAL DAY [(n)]YString
INTERVAL DAY [(n)] TO HOURYString
INTERVAL DAY [(n)] TO MINUTEYString
INTERVAL DAY [(n)] TO SECONDYString
INTERVAL HOUR [(n)]YString
INTERVAL HOUR [(n)] TO MINUTEYString
INTERVAL HOUR [(n)] TO SECONDYString
INTERVAL MINUTE [(n)]YString
INTERVAL MINUTE [(n)] TO SECOND [(m)]YString
INTERVAL MONTHYString
INTERVAL SECOND [(n,[m])]YString
INTERVAL YEAR [(n)]YString
INTERVAL YEAR [(n)] TO MONTHYString
CHAR[(n)]YString
CHARACTER(n) CHARACTER SET GRAPHICN 
VARCHAR(n)YString
CHAR VARYING(n)YString
LONG VARCHARYString
LONG VARGRAPHICN 
VARGRAPHICN 
PERIOD(DATE)N 
PERIOD(TIME (0))N 
PERIOD(TIME (0)) WITH TIME ZONEN 
PERIOD(TIME (n))N 
PERIOD(TIME (n)) WITH TIME ZONEN 
PERIOD(TIMESTAMP(0))N 
PERIOD(TIMESTAMP(0)) WITH TIME ZONEN 
PERIOD(TIMESTAMP(n))N 
PERIOD(TIMESTAMP(n)) WITH TIME ZONEN 
BLOBN 
CLOBYString
XMLYString
ARRAYYArray
VARARRAYYArray
TD_ANYTYPEN 
VARIANT_TYPEN 
DistinctN 
StructuredN 
ST_CircularStringN 
ST_CompoundCurveN 
ST_CurveN 
ST_CurvePolygonN 
ST_GeomCollectionN 
ST_GeometryN 
ST_LineStringN 
ST_MultiCurveN 
ST_MultiLineStringN 
ST_MultiPointN 
ST_MultiPolygonN 
ST_MultiSurfaceN 
ST_PointN 
ST_PolygonN 
ST_SurfaceN 
JSONYString

Publish/Write

Publishing to this datastore is not supported in this release.

 

This page has no comments.