Page tree

Release 8.2.1



Contents:

   


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.

NOTE: Dots (.) in the names of Oracle tables or table columns are not supported.

NOTE: You cannot disable type inference for Oracle sources. This is a known issue.

Access/Read

Source Data TypeSupported

Trifacta Data Type

ANYDATAN
ANYDATASETN
ANYTYPEN
BFILEN
BINARY_DOUBLEYDecimal
BINARY_FLOATYDecimal
BLOBN
CHARYString
CLOBYString
DATEYDate/Time
DBURITypeYString
FLOATYDecimal
HTTPURITypeYString
INTERVAL_DAY TO SECONDYString
INTERVAL_YEAR TO MONTHYString
LONG RAWYString (base64)
<media types>N
NCHARYString
NCLOBYString
NUMBERYDecimal / Integer
NVARCHAR2YInteger
RAWYString (base64)
ROWIDN
SDO_GEOMETRYN
SDO_GEORASTERN
SDO_TOPO_GEOMETRYN
TIMESTAMPYString
TIMESTAMP WITH LOCAL TIMEZONEYString
TIMESTAMP WITH TIMEZONEYString
URITYPEYString
UROWIDN
VARCHAR2YString
XDBUIRTypeYString
XMLTypeN

NOTE: Implementation of Oracle custom types is a custom engagement. For more information, please contact Alteryx Customer Success Services.


Write/Publish

Trifacta Data Type

Oracle Column TypeNotes
BoolVARCHAR(256)Oracle VARCHAR column type must include the maximum number of permitted characters.
IntegerINT

INTEGER

SMALLINT

DECIMAL

DEC

NUMERIC

NUMBER

FLOAT

VARCHAR(256)Oracle VARCHAR column type must include the maximum number of permitted characters.
StringVARCHAR(256)Oracle VARCHAR column type must include the maximum number of permitted characters.
DatetimeTIMESTAMP

VARCHAR(256)Oracle VARCHAR column type must include the maximum number of permitted characters.
TimestampVARCHAR(256)Oracle VARCHAR column type must include the maximum number of permitted characters.
FloatDECIMAL(38,9)Oracle DECIMAL column type must include the scale (total number of permitted digits) and precision (total number of digits permitted to the right of the decimal) as parameters.

DEC

NUMERIC

NUMBER

FLOAT

VARCHAR(256)Oracle VARCHAR column type must include the maximum number of permitted characters.
MapVARCHAR(256)Oracle VARCHAR column type must include the maximum number of permitted characters.
ArrayVARCHAR(256)Oracle VARCHAR column type must include the maximum number of permitted characters.

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.