Redshift Data Types

Dremio supports selecting the following Redshift Database types. The following table shows the mappings from Redshift to Dremio data types.

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