On this page

    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 TypeDremio Type
    bitboolean
    boolboolean
    booleanboolean
    bpcharvarchar
    byteavarbinary
    charvarchar
    character varyingvarchar
    datedate
    float8double
    intinteger
    int2integer
    int4integer
    int8integer
    integerinteger
    ncharvarchar
    numericdecimal (as of 4.0
    nvarcharvarchar
    textvarchar
    timestamp with timezonetimestamp
    timestamp without timezonetimestamp
    timestamptimestamp
    timestamptztimestamp
    tinyintinteger
    varbinaryvarbinary
    varcharvarchar