Databricks Delta Connector > Data type reference > Databricks Delta and transformation data types
  

Databricks Delta and transformation data types

The following table compares the Databricks Delta native data type to the transformation data type:
Databricks Delta Data Type
Transformation Data Type
Range and Description
Binary
Binary
1 to 104,857,600 bytes.
Bigint
Bigint
-9,223,372,036,854,775,808 to +9,223,372,036,854,775,807.
8-byte signed integer.
Boolean
Integer
1 or 0.
Date
Date/Time
January 1,0001 to December 31,9999.
Decimal
Decimal
For Cloud Data Integration mappings:
Precision 1 to 18 digits, scale 0 to 18.
For elastic mappings: Precision 1 to 38, scale 0 to 38.
Double
Double
Precision 15.
Float
Double
Precision 7.
Int
Integer
-2,147,483,648 to +2,147,483,647.
Smallint
Integer
-32,768 to +32,767.
String
String
1 to 104,857,600 characters.
Tinyint
Integer
-128 to 127
Timestamp
Date/Time
January 1,0001 00:00:00 to December 31,9999 23:59:59.997997.