Microsoft Fabric Data Warehouse Connector > Data type reference > Microsoft Fabric Data Warehouse and transformation data types
  

Microsoft Fabric Data Warehouse and transformation data types

Use only the supported Microsoft Fabric Data Warehouse data types in a mapping or mapping in advanced mode to read from and write to Microsoft Fabric Data Warehouse.
The following table lists the Microsoft Fabric Data Warehouse data types that Data Integration supports and the corresponding transformation data types:
Microsoft Fabric Data Warehouse Data Type
Transformation Data Type
Description
Bigint
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Bit
Integer
1, 0, or NULL
Char
String
1 to 8000 characters
Date
Date/Time
January 1, 1900 to December 31, 9999
Datetime2
Date/Time
1900-01-01 00:00:000000
Decimal
Decimal
Maximum value: 9.999999999999998e+37
Minimum value: -9.999999999999998e+37
Float
Double
Precision 15, scale 0
Int
Integer
-2,147,483,648 to 2,147,483,647
Numeric
Decimal
Precision 1 to 28, scale 0 to 28
Real
Double
Precision 7, scale 0
Smallint
Integer
-32,768 to 32,767
Time
String
00:00:00.000 to 23:59:59.999
Uniqueidentifier
String
36 characters
Varbinary
Binary
1 to 8000 bytes
Varchar
String
1 to 8000 characters