Databricks supports a wide range of data types, categorized as follows:

Numeric Types:

• Integral: TINYINT, SMALLINT, INT, BIGINT
• Exact: DECIMAL
• Floating Point: FLOAT, DOUBLE

Date and Time Types:

• DATE
• TIMESTAMP
• TIMESTAMP_NTZ

Other Simple Types:

• STRING
• BOOLEAN
• BINARY

Complex Types:

• ARRAY
• MAP
• STRUCT

Additional Notes:

• Databricks also supports INTERVAL types for representing time intervals.
• There are special rules for STRING and NULL types when it comes to type promotion.