Page tree


Contents:

Our documentation site is moving!

For up-to-date documentation of Dataprep, please visit us at https://help.alteryx.com/Dataprep/.

   

Feature Availability: This feature may not be available in all product editions. For more information on available features, see Compare Editions.

This section covers data type conversions between the Dataprep by Trifacta application and MySQL databases.

NOTE: The Dataprep by 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?

Dataprep by Trifacta Data Type

arrayN
bigintYInteger
tinyintYInteger
mediumintYInteger
smallintYInteger
intYInteger
bit [ (n) ]YString
floatYFloat
numericYFloat
decimalYDecimal
realYFloat
booleanYBool
character varying(n), varchar(n)YString
character(n), char(n)YString
dateYDate
doubleYDecimal
enumN
setN
jsonYString
textYString
tinytextYString
mediumtextYString
lontextYString
timeYDatetime
datetimeYDatetime
timestampYDatetime
yearYString

Write/Publish

NOTE: MySQL enforces a limit of 65,535 bytes per row. During publishing, row sizes that are larger than this limit yield a Row size too large  error, and the job fails.


Dataprep by Trifacta Data Type

MySQL Column TypeNotes
BoolBIT

VARCHAR

TINYINT(1)
IntegerBIGINT

INT

SMALLINT

MEDIUMINT

TINYINT

VARCHAR
StringVARCHAR(1024)

TINYTEXT

TEXT

MEDIUMTEXT

LONGTEXT
DatetimeTIMESTAMP

DATETIME

DATE

VARCHAR
TimestampVARCHAR
FloatFLOAT

DECIMAL

REAL

NUMERIC

VARCHAR
MapVARCHAR
ArrayVARCHAR

NOTE: If you are appending to an existing table where a column's Dataprep by 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.

See Also for MySQL Data Type Conversions:

This page has no comments.