Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Bolo.
ASK INFAPreview
MySQL Source Data Type | Snowflake Target Data Type |
|---|---|
bigint | number(19) |
bigint unsigned | number(20) |
binary( size ), 1 <= s <= 255 | binary( size ), 1 <= s <= 255 |
bit( precision ), 1 <= p <= 64 | binary( size ), 1 <= s <= 8 |
blob | binary(65535) |
char( size ), 1 <= s <= 255 | varchar( size ), 4 <= s <= 1020 |
date | date |
datetime | datetime(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 <= s <= 67 |
double | float |
float | float |
geomcollection | binary |
geometry | binary |
geometrycollection | binary |
int | number(10) |
int unsigned | number(10) |
json | varchar |
linestring | binary |
longblob | binary |
longtext | varchar |
mediumblob | binary |
mediumint | number(7) |
mediumint unsigned | number(8) |
mediumtext | varchar |
multilinestring | binary |
multipoint | binary |
multipolygon | binary |
numeric | integer |
point | binary |
polygon | binary |
smallint | number(5) |
smallint unsigned | number(5) |
text | varchar(65536) |
time( precision ), 0 <= p <= 6 | varchar( size ), 10 <= s <= 17 |
timestamp( precision ), 0 <= p <= 6 | timestamp_ntz( precision ), 0 <= p <= 6 |
tinyblob | binary(255) |
tinyint | number(3) |
tinyint unsigned | number(3) |
tinytext | varchar(256) |
varbinary( size ), 1 <= s <= 65535 | binary( size ), 1 <= s <= 65535 |
varchar( size ), 1 <= s <= 21844 | varchar( size ), 4 <= s <= 87376 |
year | number(4) |
