Amazon 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`