This article summarizes the features, objects, properties, and data types that are available for Databricks projects.

Features

• Direct Connect

  • Engineering cluster

  • Unity catalog API

Objects and properties

• Schemas

  • Properties

• Tables

  • Properties

  • Constraints

    • PK

    • FK

    • Check

  • Partitioning key

    • Columns

  • Bloom filter index

    • Columns

    • Options

  • Clustering key

    • Auto

    • Columns

  • Columns

  • Table properties

  • File format

    • Avro

    • Csv

    • Delta

    • Json

    • Orc

    • Parquet

    • Text

  • Comment/Description

• Columns

  • Data type (see summary of types below)

  • (NOT) NULL

  • Expression

  • Default

  • Identity

    • Start

    • Increment

  • Comment/Description

• Views

  • Properties

  • Columns

  • Comment/Description

• Materialized Views

  • Properties

  • Columns

  • Comment/Description

• External Table

  • Properties

  • Columns

  • Location

  • Constraints

    • PK

    • FK

    • Check

  • File format

    • Avro

    • Csv

    • Delta

    • Json

    • Orc

    • Parquet

    • Text

  • Comment/Description

Data types

• Numeric Data Types

  • BIGINT

  • SMALLINT

  • TINYINT

  • DECIMAL

  • DOUBLE

  • FLOAT

  • INT

• String & binary data types

  • STRING

  • BINARY

  • VARCHAR

• Logic data types

  • BOOLEAN

• Geo data types

  • Geography

  • Geometry

• Date data types

  • DATE

  • TIMESTAMP

  • INTERVAL

  • TIMESTAMP_NTZ

• Complex data types

  • Struct

  • Array

  • Map

  • VARIANT

See also:

• Snowflake

• Azure Synapse

• SQL Server

• PostgreSQL and AlloyDB

• BigQuery

• Amazon Redshift

• Oracle

• MySQL