Redshift Data Types
Dremio supports selecting the following Redshift Database types. The following table shows the mappings from Redshift to Dremio data types.
[info] Note: If a type is not present in the table, it is not currently supported.
| Redshift Database Type | Dremio Type |
|---|---|
| bit | boolean |
| bool | boolean |
| boolean | boolean |
| bpchar | varchar |
| bytea | varbinary |
| char | varchar |
| character varying | varchar |
| date | date |
| float8 | double |
| int | integer |
| int2 | integer |
| int4 | integer |
| int8 | integer |
| integer | integer |
| nchar | varchar |
| numeric | decimal (as of 4.0 |
| nvarchar | varchar |
| text | varchar |
| timestamp with timezone | timestamp |
| timestamp without timezone | timestamp |
| timestamp | timestamp |
| timestamptz | timestamp |
| tinyint | integer |
| varbinary | varbinary |
| varchar | varchar |