Redshift datatype mapping
Updated 18 November 2025
Type mapping
You can match the Redshift data types to Data Integration data types while extracting your data.
The following table shows the mapping of Redshift data types to Data Integration-compatible types:
| Redshift Type | Data Integration Type |
|---|---|
| INTERVAL | TIMESTAMP |
| DOUBLE_PRECISION | FLOAT |
| FLOAT | FLOAT |
| CHAR | STRING |
| DATE | DATE |
| VARCHAR | STRING |
| TIMESTAMP | TIMESTAMP |
| ENUM | STRING |
| BOOLEAN | BOOLEAN |
| ARRAY | STRING |
| array | STRING |
| BYTEA | STRING |
| BIT | BOOLEAN |
| REAL | FLOAT |
| BIGINT | INTEGER |
| TEXT | STRING |
| SMALLINT | INTEGER |
| NUMERIC | FLOAT |
| INTEGER | INTEGER |
| CIDR | STRING |
| DropEnumType | STRING |
| INET | STRING |
| MACDDR | STRING |
| OID | STRING |
| TSVECTOR | STRING |
| UUID | STRING |
| DATERANGE | INTEGER |
| INT4RANGE | INTEGER |
| INT8RANGE | INTEGER |
| JSON | STRING |
| JSONB | STRING |
| NUMRANGE | FLOAT |
| TSRANGE | FLOAT |
| HSTORE | STRING |
| SUPER | JSON |
