Skip to main content

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