Redshift datatype mapping
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 |
