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 Type	Dremio Type
BIGINT IDENTITY	BIGINT
BIGINT	BIGINT
BINARY	VARBINARY
BIT	BOOLEAN
CHAR	VARCHAR
DATE	DATE
DATETIME	TIMESTAMP
DATETIME2	TIMESTAMP
DECIMAL	DECIMAL
DECIMAL() IDENTITY	DECIMAL
FLOAT	DOUBLE
IMAGE	VARBINARY
INT IDENTITY	INTEGER
INT	INTEGER
MONEY	DOUBLE
NCHAR	VARCHAR
NTEXT	VARCHAR
NUMERIC	DECIMAL
NUMERIC() IDENTITY	DECIMAL
NVARCHAR	VARCHAR
REAL	FLOAT
SMALLDATETIME	TIMESTAMP
SMALLINT IDENTITY	INTEGER
SMALLINT	INTEGER
SMALLMONEY	DOUBLE
SYSNAME	VARCHAR
TEXT	VARCHAR
TIME	TIME
TINYINT IDENTITY	INTEGER
TINYINT	INTEGER
UNIQUEIDENTIFIER	VARBINARY
VARBINARY	VARBINARY
VARCHAR	VARCHAR