Page tree

Limited Availability: If you are interested in installing or upgrading to this release of Trifacta Self-Managed Enterprise Edition, please contact Alteryx Support.

   

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

BOOLEANYBool
VARCHARYString
INTEGERYInteger

Publish/Write

Trifacta Data Type

DB2 Data TypeNotes
BoolBOOLEAN

VARCHAR
IntegerBIGINT

INT

SMALLINT

VARCHAR
StringVARCHAR(1024)
DatetimeTIMESTAMP

VARCHAR
TimeVARCHAR(1024)
DecimalDECIMAL

NUMERIC

VARCHAR
MapVARCHAR(1024)
ArrayVARCHAR(1024)

See Also for DB2 Data Type Conversions:

This page has no comments.