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 |
float4 | float |
float8 | double |
int | integer |
int2 | integer |
int4 | integer |
int8 | integer |
integer | integer |
nchar | varchar |
numeric | double |
nvarchar | varchar |
text | varchar |
timestamp with timezone | timestamp |
timestamp without timezone | timestamp |
timestamp | timestamp |
timestamptz | timestamp |
tinyint | integer |
varbinary | varbinary |
varchar | varchar |