Redshift Datatype Mapping
- 1 Minute to read
- Print
- DarkLight
- PDF
Redshift Datatype Mapping
- 1 Minute to read
- Print
- DarkLight
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
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?