Skip to main content

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 TypeDremio Type
BITBOOLEAN
BOOLBOOLEAN
BOOLEANBOOLEAN
BPCHARVARCHAR
BYTEAVARBINARY
CHARVARCHAR
CHARACTER VARYINGVARCHAR
DATEDATE
FLOAT4FLOAT
FLOAT8DOUBLE
INTINTEGER
INT2INTEGER
INT4INTEGER
INT8BIGINT
INTEGERINTEGER
NCHARVARCHAR
NUMERICDECIMAL
NVARCHARVARCHAR
TEXTVARCHAR
TIMESTAMP WITH TIMEZONETIMESTAMP
TIMESTAMP WITHOUT TIMEZONETIMESTAMP
TIMESTAMPTIMESTAMP
TIMESTAMPTZTIMESTAMP
TINYINTINTEGER
VARBINARYVARBINARY
VARCHARVARCHAR