The following table shows how Microsoft Fabric Lakehouse data types are mapped to Data Integrity Suite internal data types.
| Fabric Data Type | Catalog Type |
|---|---|
| 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 |