Open Table Connector > Data type reference > Open Table and transformation data types
  

Open Table and transformation data types

The following table lists the Open Table data types that Data Integration supports and the corresponding transformation data types:
Open Table data type
Transformation data type
Supported Open Table format
Description
Bigint
Bigint
Delta Lake
-9223372036854775808 to 9223372036854775807
Binary
Binary
Apache Iceberg, Delta Lake
Variable length binary data.
Boolean
String
Apache Iceberg, Delta Lake
True or false
Date
Date/Time
Apache Iceberg, Delta Lake
Calendar date without timezone and time.
0001-01-01 to 9999-12-31
Precision 29, scale 9
Decimal (Precision, Scale)
Decimal
Apache Iceberg, Delta Lake
The maximum value for precision is 38, and the maximum value for scale is 38.
Double
Double
Apache Iceberg, Delta Lake
4.94065645841246544e-324d to 1.79769313486231570e+308d, positive or negative.
Float
Double
Apache Iceberg, Delta Lake
1.40129846432481707e-45 to 3.40282346638528860e+38, positive or negative.
Int
Integer
Apache Iceberg, Delta Lake
231 to 231 -1.
Smallint
Integer
Delta Lake
-32768 to 32767
String
String
Apache Iceberg, Delta Lake
Variable length character data.
Timestamp
Date/Time
Apache Iceberg, Delta Lake
Timestamp without timezone.
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(Precision to the microsecond)
Tinyint
Integer
Delta Lake
-128 to 127