On this page

    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