skills.rest
AarushiShah
AarushiShahCOMMUNITY
Explore all skills by this author →
GitHub

databricks-aibi-dashboards

Create and deploy Databricks AI/BI dashboards with validated SQL queries and widget layouts.

Updated Mar 24, 2026
Search Tags:#data visualization#business intelligence#databricks#unity catalog#lakeview#sql validation#ai/bi dashboards
One-click install
npx skills add https://github.com/AarushiShah/coding-agents-databricks-apps --skill databricks-aibi-dashboards-aarushishah
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databricks-aibi-dashboards
Source: https://github.com/AarushiShah/coding-agents-databricks-apps/tree/main/.claude/skills/databricks-aibi-dashboards
Command: npx skills add https://github.com/AarushiShah/coding-agents-databricks-apps --skill databricks-aibi-dashboards-aarushishah

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Building Databricks AI/BI (Lakeview) dashboards by hand is error-prone: untested SQL queries, mismatched widget field names, wrong spec versions, and broken layouts cause "Invalid widget definition" errors. This Skill enforces a mandatory validate-then-deploy workflow so dashboards render correctly on the first deployment. ## Core Features & Use Cases - Mandatory SQL validation workflow: Requires testing every dataset query via execute_sql before calling create_or_update_dashboard, preventing broken widgets. - Complete widget specifications: Provides exact JSON patterns for counters, tables, bar/line/pie charts, text headers, and global or page-level filters, including correct spec versions and field-name matching rules. - Layout and readability rules: Enforces a 6-column grid with no gaps, recommended widget sizes, and cardinality limits so charts stay readable. - Use Case: Ask the agent to build a sales dashboard from a Unity Catalog table; it inspects the schema, tests each query, assembles the dashboard JSON with KPIs, charts, and filters, and deploys it to your workspace. ## Quick Start Create an AI/BI dashboard from the samples.nyctaxi.trips table showing total trips, average fare, and trips by pickup ZIP, then deploy it to my workspace.

Frequently Asked Questions about databricks-aibi-dashboards

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create a Databricks AI/BI dashboard with SQL queries?▼

First get table schemas with get_table_details, then write and test every dataset query via execute_sql before deploying. Build the dashboard JSON with datasets and widget layouts, then call create_or_update_dashboard with a warehouse ID.

Why does my dashboard widget show "no selected fields to visualize"?▼

This is a field name mismatch: the name in query.fields must exactly match the fieldName in encodings. For example, if the field name is "sum(spend)", the encoding fieldName must also be "sum(spend)".

What widget spec versions do Databricks AI/BI dashboards use?▼

Counters, tables, and filters use spec version 2, while bar, line, and pie charts use version 3. Text widgets have no spec block at all and use multilineTextboxSpec directly on the widget.

How do I add global filters to a Databricks dashboard?▼

Place filter widgets on a dedicated page with pageType PAGE_TYPE_GLOBAL_FILTERS using widgetType filter-multi-select, filter-single-select, or filter-date-range-picker. The filter affects all pages whose datasets contain the filter field.

Why does my dashboard show "Invalid widget definition" errors?▼

Common causes are wrong spec versions, using widgetType "filter" instead of a specific filter type, adding a spec block to text widgets, or deploying untested SQL. Always validate queries with execute_sql before deployment.

Related Skills

Explore More Data & Analytics Skills→
ThomazRossitoThomazRossito
31

databricks-aibi-dashboards

Build, validate, and deploy Databricks AI/BI dashboards with SQL checks.

Community
Advanced
webrix-aiwebrix-ai
1

dashboard-generation

Create analytics dashboards with KPIs, charts, and automated refresh schedules.

Official
Intermediate
jasonzhu0922-sketchjasonzhu0922-sketch
6

explore-data

Profiles datasets to assess structure, quality, distributions, and analysis opportunities.

Community
Intermediate
404kidwiz404kidwiz

data-analyst

Design interactive dashboards and optimize SQL queries for business intelligence.

Community
Advanced