databricks-aibi-dashboards

Create and update Databricks AI/BI dashboards with validated SQL queries and JSON layouts.

3|Updated Jan 2, 2025
One-click install
npx skills add https://github.com/ScottHMcKean/genai_notebooks --skill databricks-aibi-dashboards-scotthmckean
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: databricks-aibi-dashboards
Source: https://github.com/ScottHMcKean/genai_notebooks/tree/main/.cursor/skills/databricks-aibi-dashboards
Command: npx skills add https://github.com/ScottHMcKean/genai_notebooks --skill databricks-aibi-dashboards-scotthmckean

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines the creation and deployment of Databricks AI/BI (formerly Lakeview) dashboards, ensuring data accuracy and visual consistency through a rigorous validation process.

Core Features & Use Cases

  • Guided Dashboard Creation: Follows a strict workflow for building dashboards from data to deployment.
  • Mandatory Query Validation: Enforces testing of all SQL queries using execute_sql before deployment to prevent errors.
  • Structured Layout and Design: Provides guidelines for optimal widget sizing, positioning, and cardinality to ensure readability.
  • Use Case: A data analyst needs to create a sales performance dashboard. They use this Skill to define datasets, test their SQL queries, build visualizations like KPIs and charts, and deploy the dashboard, confident that all data is validated.

Quick Start

Use the databricks-aibi-dashboards skill to create a new dashboard named 'Sales Performance' using the provided SQL queries and widget specifications.

Frequently Asked Questions about databricks-aibi-dashboards

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

FAQPage Schema
How do I build Databricks AI/BI dashboards with validated SQL queries?

To build Databricks AI/BI dashboards, you must define datasets and validate all SQL queries using execute_sql before deployment. This process enforces data accuracy and uses JSON-based layouts to configure widgets and ensure visual consistency.

What is the best way to update a Lakeview dashboard layout without breaking visualizations?

The best way to update a Lakeview dashboard layout is by using JSON-based deployment configurations that enforce strict widget sizing, positioning, and cardinality rules. This structured approach maintains readability and dashboard integrity during updates.

Do I need to test SQL queries before deploying Databricks AI/BI dashboards?

Yes, mandatory query validation is required before deploying Databricks AI/BI dashboards. You must test all SQL queries using execute_sql to prevent errors and ensure data accuracy prior to defining datasets and publishing visualizations.

Can I automate Databricks dashboard publishing and management through defined tools?

Yes, you can automate Databricks dashboard publishing and management through defined MCP tools. This automation orchestrates the entire workflow from SQL query validation and dataset definition to JSON-based layout deployment and publishing.

Why does my Databricks AI/BI dashboard deployment fail due to widget configuration?

Dashboard deployment may fail if widget configurations violate data modeling, sizing, or cardinality best practices. Enforcing strict adherence to layout guidelines and validating SQL queries beforehand prevents these structural errors and ensures performance.

Does the databricks-aibi-dashboards skill work without external dependencies?

Yes, the databricks-aibi-dashboards skill operates without external dependencies. It relies on internal references to orchestrate SQL validation, dataset definition, and JSON layout deployment for Databricks AI/BI dashboards directly.