SqlDBM Help Center

All CollectionsDatabase Object and Feature Support

Databricks Support Summary

Databricks Support Summary

Databricks object and data type support summary

S

Written by Serge Gershkovich

Updated over 3 weeks ago

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
- 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
- Types:
  - Materialized
- Properties
- 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
Date data types
- DATE
- TIMESTAMP
- INTERVAL

See also: