Explore the Microsoft Fabric Lakehouse datatype to catalog datatype mappings available for the datasource.
| Fabric datatype | Catalog datatype |
|---|---|
| INT | Integer |
| DECIMAL | Decimal |
| NUMERIC | Decimal |
| DOUBLE PRECISION | Double |
| VARCHAR | String |
| CHAR | String |
| TEXT | String |
| DATE | Date |
| TIME | Time |
| TIMESTAMP | DateTime |
| BOOLEAN | Boolean |
| bit | Boolean |
| money | Decimal |
| smallmoney | Decimal |
| nvarchar | String |
| nchar | String |
| ntext | String |
| uniqueidentifier | String |
| xml | String |
| hierarchyid | String |
| sql_variant | String |
| datetime2 | DateTime |
| datetimeoffset | DateTime |
| smalldatetime | DateTime |
| image | Blob |
| geography | Geospatial |
| geometry | Geospatial |
| timestamp_ntz | DateTime |
| long | Integer |
| short | Integer |
| byte | Integer |
| double | Double |
| string | String |
| integer | Integer |
| array | String |
| map | String |
| struct | String |
| void | String |
| null | String |