On this page

    Microsoft SQL Server Data Types

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

    Note:
    If a type is not present in the table, it is not currently supported.

    SQL Server Database TypeDremio Type
    bigint identitybigint
    bigintbigint
    binaryvarbinary
    bitboolean
    charvarchar
    datedate
    datetimetimestamp
    datetime2timestamp
    decimal() identitydecimal (as of 4.0)
    floatdouble
    imagevarbinary
    int identityinteger
    intinteger
    moneydouble
    ncharvarchar
    ntextvarchar
    numericdecimal (as of 4.0)
    numeric() identitydecimal (as of 4.0)
    nvarcharvarchar
    realfloat
    smalldatetimetimestamp
    smallint identityinteger
    smallintinteger
    smallmoneydouble
    sysnamevarchar
    textvarchar
    timetime
    tinyint identityinteger
    tinyintinteger
    uniqueidentifiervarbinary
    varbinaryvarbinary
    varcharvarchar
    xmlvarchar