Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Bolo.
ASK INFAPreview
MySQL Source Data Type | Databricks Delta Target Data Type |
|---|---|
bigint | long |
bigint unsigned | decimal(20) |
binary( size ), 1 <= s <= 255 | binary |
bit( precision ), 1 <= p <= 64 | binary |
blob | binary |
char( size ), 1 <= s <= 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 <= s <= 65535 | binary |
varchar( size ), 1 <= s <= 21844 | string |
year | integer |
