Amazon Redshift Data Types
Dremio supports Amazon Redshift data types, as shown in the following table which provides the mappings from Amazon Redshift to Dremio data types. If there are additional Redshift types not listed in the table, then those types are not supported in Dremio.
| Amazon Redshift Data Type | Dremio Type |
|---|---|
| BIT | BOOLEAN |
| BOOL | BOOLEAN |
| BOOLEAN | BOOLEAN |
| BPCHAR | VARCHAR |
| BYTEA | VARBINARY |
| CHAR | VARCHAR |
| CHARACTER VARYING | VARCHAR |
| DATE | DATE |
| FLOAT4 | FLOAT |
| FLOAT8 | DOUBLE |
| INT | INTEGER |
| INT2 | INTEGER |
| INT4 | INTEGER |
| INT8 | BIGINT |
| INTEGER | INTEGER |
| NCHAR | VARCHAR |
| NUMERIC | DECIMAL |
| NVARCHAR | VARCHAR |
| TEXT | VARCHAR |
| TIMESTAMP WITH TIMEZONE | TIMESTAMP |
| TIMESTAMP WITHOUT TIMEZONE | TIMESTAMP |
| TIMESTAMP | TIMESTAMP |
| TIMESTAMPTZ | TIMESTAMP |
| TINYINT | INTEGER |
| VARBINARY | VARBINARY |
| VARCHAR | VARCHAR |