Skip to content
BENIBIX Learn

Databricks SQL

Data🧰 PlatformsData Platforms

Also known as Databricks SQL Warehouse, DBSQL, SQL Warehouse (Databricks)

The part of Databricks for SQL and charts. It runs on SQL warehouses.

Think of it like

It is like a front desk at a busy shop. You ask for what you need, and you never go in the back.

Example

Finance links Power BI to a SQL warehouse in Databricks. Its reports read the same Delta tables the data team builds.

Why it matters

A lakehouse can now serve charts the way a warehouse does. There is no second copy of the data.

Definition

Databricks SQL is the part of Databricks built for analysts and BI tools. It runs SQL on lakehouse tables. The compute it uses is called a SQL warehouse. A serverless one starts in seconds and stops when idle. It has its own SQL editor, simple dashboards and links for tools like Power BI and Tableau. The data is the same Delta tables the engineers use.
Databricks SQL is the SQL warehouse on the top row, the way in for BI.

Common mistake

Sizing one huge warehouse for everyone. Give BI and ad hoc users their own, so one heavy query does not slow all.

Key takeaways

  1. 1
    For analysts. SQL, an editor and BI links.
  2. 2
    SQL warehouses. Compute that starts and stops.
  3. 3
    Same tables. No second copy of the data.