Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Bolo.
ASK INFAPreview
MySQL Source Data Type | Amazon Redshift Target Data Type |
|---|---|
bigint | bigint |
bigint unsigned | numeric(20,0) |
binary( size ), 1 <= s <= 255 | character varying( size ), 2 <= s <= 510 |
bit( precision ), 1 <= p <= 64 | character varying( size ), 2 <= s <= 16 |
blob | character varying(65535) |
char( size ), 1 <= s <= 255 | character varying( size ), 4 <= s <= 1020 |
date | date |
datetime | timestamp without time zone |
decimal(p,s), 1 <= p <= 38, 0 <= s <= 29 | numeric(p,s), 1 <= p <= 38, 0 <= s <= 29 |
decimal(p,s), 39 <= p <= 65, 0 <= s <= 29 | character varying( size ), 40 <= s <= 67 |
double | double precision |
float | real |
geomcollection | character varying(65535) |
geometry | character varying(65535) |
geometrycollection | character varying(65535) |
int | integer |
int unsigned | bigint |
json | character varying(65535) |
linestring | character varying(65535) |
longblob | character varying(65535) |
longtext | character varying(65535) |
mediumblob | character varying(65535) |
mediumint | integer |
mediumint unsigned | integer |
mediumtext | character varying(65535) |
multilinestring | character varying(65535) |
multipoint | character varying(65535) |
multipolygon | character varying(65535) |
numeric | numeric(10,0) |
point | character varying(65535) |
polygon | character varying(65535) |
smallint | smallint |
smallint unsigned | integer |
text | character varying(65535) |
time( precision ), 0 <= p <= 6 | character varying( size ), 10 <= s <= 17 |
timestamp( precision ), 0 <= p <= 6 | timestamp without time zone |
tinyblob | character varying(510) |
tinyint | smallint |
tinyint unsigned | smallint |
tinytext | character varying(256) |
varbinary( size ), 1 <= s <= 65535 | character varying( size ), 2 <= s <= 65535 |
varchar( size ), 1 <= s <= 21844 | character varying( size ), 4 <= s <= 65535 |
year | smallint |
