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 Type | Dremio Type |
---|---|
bigint identity | bigint |
bigint | bigint |
binary | varbinary |
bit | boolean |
char | varchar |
date | date |
datetime | timestamp |
datetime2 | timestamp |
decimal() identity | decimal (as of 4.0) |
float | double |
image | varbinary |
int identity | integer |
int | integer |
money | double |
nchar | varchar |
ntext | varchar |
numeric | decimal (as of 4.0) |
numeric() identity | decimal (as of 4.0) |
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 |
xml | varchar |
Was this page helpful?
Glad to hear it! Thank you for your feedback.
Sorry to hear that. Thank you for your feedback.