skills.rest
FMurray
FMurrayCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

databricks-app-python

Build Python-based Databricks applications using Dash, Streamlit, or Flask frameworks.

Updated Mar 5, 2026
Search Tags:#deployment#dashboard#streamlit#databricks#dash#unity catalog#python web app
One-click install
npx skills add https://github.com/FMurray/mlfts --skill databricks-app-python-fmurray
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databricks-app-python
Source: https://github.com/FMurray/mlfts/tree/main/.agents/skills/databricks-app-python
Command: npx skills add https://github.com/FMurray/mlfts --skill databricks-app-python-fmurray

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires dash, dash-bootstrap-components, streamlit, plotly, pandas, pydantic, databricks-sdk, databricks-sql-connector, python-dotenv.

What problem does it solve? Building data applications on Databricks requires coordinating Pydantic models, SQL Warehouse connections, Unity Catalog schemas, and framework-specific UI code, which is error-prone without established patterns. This Skill provides a complete architecture and implementation guide for creating production Python web apps on Databricks. ## Core Features & Use Cases - Framework Guidance: Detailed implementation patterns for Dash (Bootstrap components, callbacks, Plotly charts) and Streamlit (caching, session state, forms), with a comparison table to help choose between them. - Dual Backend Architecture: Standardized mock backend for rapid development plus a real backend using Databricks SQL Connector with SDK Config authentication against Unity Catalog. - Deployment Workflows: Step-by-step deployment via Databricks CLI or Databricks Asset Bundles, including app.yaml configuration, log inspection, and multi-environment setup. - Use Case: A data team needs an order management dashboard backed by Unity Catalog tables. The Skill guides model design, mock data generation, Dash UI construction, real SQL backend wiring, and deployment to Databricks Apps. ## Quick Start Ask the agent to build a Dash order management app on Databricks with a mock backend and Unity Catalog integration.

Frequently Asked Questions about databricks-app-python

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

FAQPage Schema
How do I build a Dash app on Databricks?▼

Create Pydantic models, a mock backend with sample data, and a real backend using databricks-sql-connector with SDK Config authentication. Build the UI with dash-bootstrap-components and Plotly charts, then deploy with an app.yaml file using the Databricks CLI apps deploy command.

Dash vs Streamlit for Databricks apps, which should I choose?▼

Choose Dash for production dashboards needing precise layout control, Bootstrap styling, and complex callbacks. Choose Streamlit for rapid prototyping, data science demos, and notebook-like development with automatic reactivity and built-in state management.

How do I connect a Streamlit app to a Databricks SQL Warehouse?▼

Use databricks.sql.connect with the SDK Config object for authentication, passing the warehouse HTTP path. Wrap the connection in @st.cache_resource so it persists across reruns and sessions instead of creating new connections each time.

Does Databricks Apps authentication require a personal access token?▼

No explicit token is needed when using the SDK Config approach. Authentication is handled automatically through the Databricks CLI profile locally or a service principal when running as a Databricks App.

Why is my Databricks app failing after deployment?▼

Check logs first with databricks apps logs <app-name>. Common causes include missing dependencies, SQL connection failures, an incorrect DATABRICKS_WAREHOUSE_ID, or insufficient service principal permissions on the warehouse and catalog.

When should I not use this Python app approach?▼

Do not use it when the user specifies APX, React, Node.js, or other non-Python frameworks. It is scoped to Python web frameworks like Dash, Streamlit, and Flask only.

Related Skills

Explore More Software Engineering Skills→
LaurentPRAT-DBLaurentPRAT-DB

databricks-resource-deployment

Deploy Databricks notebooks, jobs, clusters, SQL warehouses, and databases.

Community
Advanced
robkiskrobkisk

databricks-asset-bundles

Create and manage Databricks Asset Bundles for multi-environment deployments.

Community
Advanced
TheGrowthExponentTheGrowthExponent

Development & Deployment Skills

Automate Databricks development, deployment, and DevOps operations.

Official
Intermediate
thbehthbeh

databricks-app-apx

Develop and deploy full-stack Databricks applications with FastAPI and React.

Community
Intermediate