AI/BI Dashboards

Databricks · Databricks SQL & BI

Theory

AI/BI dashboards (formerly Lakeview dashboards, which replaced the legacy Databricks SQL dashboards) are the built-in way to build and share reports. A dashboard has a Data tab, where you add datasets as SQL queries or Unity Catalog tables and metric views, and canvas pages where you add visualizations, text and filters. Visuals are built by picking fields, or by describing the chart in plain language and letting the AI assistant draft it. When ready, you Publish the dashboard, choosing whether viewers see data with your embedded credentials or their own permissions, share it with users or the whole account, and set a schedule to refresh it and email subscribers.

Example: Meera builds Sales Overview with a dataset on main.sales.orders joined to customers, a bar chart of sales by city, a counter for total sales and a date range filter, then publishes it to the sales team with a daily 7 AM refresh.

Why we use it

Teams need governed, fast reports right next to the data without exporting to another tool. AI/BI dashboards run on SQL warehouses, respect Unity Catalog permissions and can be shared with people who do not have a Databricks login through account-level sharing.

When to use it

Use AI/BI dashboards for operational and team reporting on lakehouse data. Use Power BI or Tableau when the company already standardises on them or needs complex semantic models. Use Genie Agents for ad-hoc natural-language questions instead of more dashboard pages.

How it works

  1. + New → Dashboard
  2. Data tab: add a SQL dataset or pick a Unity Catalog table
  3. Canvas: Add a visualization, choose type and fields
  4. Add filters, a counter and text for context
  5. Should viewers use your data access? Yes: Publish with embedded credentials. No: Publish without, so viewers need SELECT.
  6. Share and add a refresh schedule

Syntax

UI: + New → Dashboard  (or Dashboards → Create dashboard)
  Data tab → Add SQL dataset / Add data source → canvas → Add a visualization → pick fields
  Publish (embed credentials or not) → Share → Schedule
As code: dashboards in Declarative Automation Bundles (.lvdash.json)

Example

-- Dataset 'orders_by_city' on the Data tab
SELECT c.city, c.segment, o.order_date, o.amount
FROM main.sales.orders o
JOIN main.sales.customers c ON o.customer_id = c.customer_id
WHERE o.order_date >= :start_date;

-- Canvas widgets built on that dataset:
--   Counter: SUM(amount)               -> Total sales
--   Bar:     X = city, Y = SUM(amount) -> Sales by city
--   Filter:  date range on order_date, single-select on segment

Key points

Databricks topics

Databricks Fundamentals

Compute

Notebooks & Development

Apache Spark on Databricks

Delta Lake

Unity Catalog & Governance

Data Ingestion

Declarative Pipelines (Lakeflow)

Lakeflow Jobs

Databricks SQL & BI

Architecture, Performance & Cost

Machine Learning & AI

Certification & Interview

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Master Databricks

The lakehouse platform from the ground up: Apache Spark, Delta Lake, Unity Catalog, Lakeflow pipelines and jobs, Databricks SQL and MLflow. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice SQL / Spark SQL Sharpen the SQL you use in Databricks SQL and Spark SQL: 150 query problems in a live editor with instant checking. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Databricks  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

{{ sec.h }}

{{ sec.body }}

{{ sec.body }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax
{{ current.syntax }}
Example
{{ current.example }}
Want to run this yourself? Databricks needs a real workspace — there's no in-browser engine for it. Click Copy above, then paste it into a notebook or the SQL editor in Databricks Free Edition (free, no credit card) and run it on serverless compute.
Key Points — click to check off as you learn
  • {{ pt.mark }} {{ pt.text }}

Share this topic