MySQL Source and Databricks Target

MySQL Source Data Type	Databricks Target Data Type
bigint	long
bigint unsigned	decimal(20)
binary(size), 1 <= size <= 255	binary
bit(precision), 1 <= p <= 64	binary
blob	binary
char(size), 1 <= size <= 255	string
date	string
datetime	timestamp
decimal(p,s), 1 <= p <= 38, 0 <= s <= 29	decimal(p,s), 1 <= p <= 38, 0 <= s <= 29
decimal(p,s), 39 <= p <= 65, 0 <= s <= 29	string
double	double
float	float
geomcollection	binary
geometry	binary
geometrycollection	binary
int	integer
int unsigned	long
json	string
linestring	binary
longblob	binary
longtext	string
mediumblob	binary
mediumint	integer
mediumint unsigned	integer
mediumtext	string
multilinestring	binary
multipoint	binary
multipolygon	binary
numeric	decimal
point	binary
polygon	binary
smallint	integer
smallint unsigned	integer
text	string
time(precision), 0 <= p <= 6	string
timestamp(precision), 0 <= p <= 6	timestamp
tinyblob	binary
tinyint	integer
tinyint unsigned	integer
tinytext	string
varbinary(size), 1 <= size <= 65535	binary
varchar(size), 1 <= size <= 21844	string
year	integer