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 |
Was this page helpful?
Glad to hear it! Thank you for your feedback.
Sorry to hear that. Thank you for your feedback.