MySQL Source Data Type | Snowflake Target Data Type |
|---|---|
bigint | number(19) |
bigint unsigned | number(20) |
binary(size), 1 <= size <= 255 | binary(size), 1 <= size <= 255 |
bit(precision), 1 <= p <= 64 | binary(size), 1 <= size <= 8 |
blob | binary |
char(size), 1 <= size <= 255 | varchar(size), 4 <= size <= 1020 |
date | date |
datetime | timestamp_ntz(0) |
decimal(p,s), 1 <= p <= 38, 0 <= s <= 29 | number(p,s), 1 <= p <= 38, 0 <= s <= 29 |
decimal(p,s), 39 <= p <= 65, 0 <= s <= 29 | char(size), 40 <= size <= 67 |
double | float |
float | float |
geomcollection | binary |
geometry | binary |
geometrycollection | binary |
int | number(10) |
int unsigned | number(10) |
json | variant |
linestring | binary |
longblob | binary |
longtext | varchar |
mediumblob | binary |
mediumint | number(7) |
mediumint unsigned | number(8) |
mediumtext | varchar |
multilinestring | binary |
multipoint | binary |
multipolygon | binary |
numeric(10,0) | integer |
point | binary |
polygon | binary |
smallint | number(5) |
smallint unsigned | number(5) |
text | varchar |
time(precision), 0 <= p <= 6 | varchar(size), 10 <= size <= 17 |
timestamp(precision), 0 <= p <= 6 | timestamp_ntz(precision), 0 <= p <= 6 |
tinyblob | binary |
tinyint | number(3) |
tinyint unsigned | number(3) |
tinytext | varchar(340) |
varbinary(size), 1 <= size <= 65535 | binary(size), 1 <= size <= 65535 |
varchar(size), 1 <= size <= 21844 | varchar(size), 4 <= size <= 87376 |
year | number(4) |