Microsoft Fabric OneLake Connector > Data type reference > Iceberg data types and transformation data types
  

Iceberg data types and transformation data types

Iceberg data types map to transformation data types that the Secure Agent uses to move data across platforms.
The following table lists the Iceberg data types that the Secure Agent supports and the corresponding transformation data types:
Iceberg data type
Transformation data type
Range and description
Binary
Binary
Represents byte sequence values.
Boolean
Int
1 or 0
Date
Date/Time
October 15, 1582 to December 31, 9999.
Decimal
Decimal
Precision 1 to 28 digits, scale 0 to 28.
Double
Double
Precision 15.
Float
Double
Precision 7.
Fixed(L)
Binary
Fixed length value.
Long
Bigint
-9,223,372,036,854,775,808 to +9,223,372,036,854,775,807
Int
Int
-2,147,483,648 to +2,147,483,647
String
String
4000
Time1
Bigint
Time of the day.
Timestamp 1
Date/Time
October 15, 1582 00:00:00 to December 31, 9999 23:59:59.997.
Precision to microsecond.
Timestamptz
Date/Time
Date and time with timezone.
UUID1
Binary
UUID2
String
16
1 Doesn't apply to mappings in advanced mode.
2 Applies only to mappings in advanced mode.