Redshift Datatype Mapping
- 1 Minute to read
- Print
- DarkLight
- PDF
Redshift Datatype Mapping
- 1 Minute to read
- Print
- DarkLight
- PDF
Article Summary
Type Mapping
We match Redshift data types to Rivery data types as we extract your data.
The following table shows the mapping ofRedshift data types to Rivery-compatible types:
| Redshift Type | Rivery 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 |
Was this article helpful?