View Source

NOTE: The 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 Type	Supported?
array	N
bigint	Y	Integer
tinyint	Y	Integer
mediumint	Y	Integer
smallint	Y	Integer
int	Y	Integer
bit [ (n) ]	Y	String
float	Y	Float
numeric	Y	Float
decimal	Y	Decimal
real	Y	Float
boolean	Y	Bool
character varying(n), varchar(n)	Y	String
character(n), char(n)	Y	String
date	Y	Date
double	Y	Decimal
enum	N
set	N
json	Y	String
text	Y	String
tinytext	Y	String
mediumtext	Y	String
lontext	Y	String
time	Y	Datetime
datetime	Y	Datetime
timestamp	Y	Datetime
year	Y	String

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.

	MySQL Column Type	Notes
Bool	BIT
	VARCHAR
	TINYINT(1)
Integer	BIGINT
	INT
	SMALLINT
	MEDIUMINT
	TINYINT
	VARCHAR
String	VARCHAR(1024)
	TINYTEXT
	TEXT
	MEDIUMTEXT
	LONGTEXT
Datetime	TIMESTAMP
	DATETIME
	DATE
	VARCHAR
Timestamp	VARCHAR
Float	FLOAT
	DECIMAL
	REAL
	NUMERIC
	VARCHAR
Map	VARCHAR
Array	VARCHAR

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