MySQL connector reference

Preview

The MySQL connector is in Public Preview. Contact your Databricks account team to request access.

Find reference material for the MySQL connector in Lakeflow Connect, including data type mappings and DDL operation handling.

Data type mappings

Databricks automatically transforms MySQL data types into Delta-compatible data types. The following table shows how MySQL types map to Delta types:

MySQL type	Delta type
`TINYINT`	`SMALLINT`
`TINYINT UNSIGNED`	`SMALLINT`
`SMALLINT`	`SMALLINT`
`SMALLINT UNSIGNED`	`INTEGER`
`MEDIUMINT`	`INT`
`MEDIUMINT UNSIGNED`	`INT`
`INT`	`INT`
`INT UNSIGNED`	`LONG`
`BIGINT`	`BIGINT`
`BIGINT UNSIGNED`	`DECIMAL(20,0)`
`DECIMAL/NUMERIC(p,s)` If precision and scale is less than or equal to 38	`DECIMAL(p,s)`
`DECIMAL/NUMERIC` If precision and scale is greater than 38	`STRING`
`DOUBLE`	`DOUBLE`
`FLOAT`	`FLOAT`
`BIT(N)`	`BINARY`
`BIT(1)`	`BOOLEAN`
`BOOL`	`SMALLINT`
`DATE`	`DATE`
`DATETIME`	`STRING`
`TIME`	`STRING`
`TIMESTAMP`	`TIMESTAMP`
`YEAR`	`STRING`
`BINARY`	`BINARY`
`CHAR`	`STRING`
`BLOB`	`BINARY`
`LONGBLOB`	`BINARY`
`LONGTEXT`	`STRING`
`MEDIUMBLOB`	`BINARY`
`MEDIUMTEXT`	`STRING`
`TINYBLOB`	`BINARY`
`TINYTEXT`	`STRING`
`VARBINARY`	`BINARY`
`VARCHAR`	`STRING`
`JSON`	`STRING`
`ENUM`	`STRING`
`SET`	`STRING`
`TEXT`	`STRING`
`GEOMETRY`	`NOT SUPPORTED`
`GEOMETRYCOLLECTION`	`NOT SUPPORTED`
`LINESTRING`	`NOT SUPPORTED`
`MULTILINESTRING`	`NOT SUPPORTED`
`MULTIPOINT`	`NOT SUPPORTED`
`MULTIPOLYGON`	`NOT SUPPORTED`

The MySQL connector supports both SCD Type 1 and SCD Type 2:

SCD Type 1: Only the latest version of each row is maintained. Updates overwrite previous values.
SCD Type 2: All versions of each row are maintained with start and end timestamps.