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
Apache Iceberg,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
  • - For mappings, the maximum values for precision and scale are 28.
  • - For mappings in advanced mode, the maximum values for precision and scale are 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
*Applies only to mappings in advanced mode.