On this page

    Microsoft SQL Server Data Types

    Dremio supports SQL Server data types, as shown in the following table which provides the mappings from SQL Server to Dremio data types. If there are additional SQL Server types not listed in the table, then those types are not supported in Dremio.

    SQL Server Data TypeDremio Type
    BIGINT IDENTITYBIGINT
    BIGINTBIGINT
    BINARYVARBINARY
    BITBOOLEAN
    CHARVARCHAR
    DATEDATE
    DATETIMETIMESTAMP
    DATETIME2TIMESTAMP
    DECIMALDECIMAL
    DECIMAL() IDENTITYDECIMAL
    FLOATDOUBLE
    IMAGEVARBINARY
    INT IDENTITYINTEGER
    INTINTEGER
    MONEYDOUBLE
    NCHARVARCHAR
    NTEXTVARCHAR
    NUMERICDECIMAL
    NUMERIC() IDENTITYDECIMAL
    NVARCHARVARCHAR
    REALFLOAT
    SMALLDATETIMETIMESTAMP
    SMALLINT IDENTITYINTEGER
    SMALLINTINTEGER
    SMALLMONEYDOUBLE
    SYSNAMEVARCHAR
    TEXTVARCHAR
    TIMETIME
    TINYINT IDENTITYINTEGER
    TINYINTINTEGER
    UNIQUEIDENTIFIERVARBINARY
    VARBINARYVARBINARY
    VARCHARVARCHAR