Redshift to MySQL mapping
AutoSync maps Redshift object types to the following MySQL column types:
Redshift object type | MySQL column type |
---|---|
character |
CHAR |
character varying |
VARCHAR |
date |
DATE |
time without time zone |
TIME |
timetz |
TIME |
timestamp without time zone |
DATETIME |
timestamp with time zone |
DATETIME |
boolean |
BIT |
smallint |
SMALLINT |
integer |
INT |
bigint |
BIGINT |
numeric |
DECIMAL |
real |
FLOAT |
double precision |
DOUBLE |
geometry |
VARCHAR |
geography |
VARCHAR |
hllsketch |
JSON |
super |
VARCHAR |
binary varying |
BLOB |
sl_timestamp |
DATETIME |