skills.rest
datasciencemonkey
datasciencemonkeyCOMMUNITY
Explore all skills by this author →
GitHub

databricks-dbsql

Implement procedural SQL, stored procedures, recursive CTEs, transactions and views in Databricks SQL.

27|9|Updated Feb 3, 2026
Search Tags:#sql#lakehouse#databricks#materialized-views#dbsql#procedural-sql#recursive-ctes
One-click install
npx skills add https://github.com/datasciencemonkey/coding-agents-databricks-apps --skill databricks-dbsql
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databricks-dbsql
Source: https://github.com/datasciencemonkey/coding-agents-databricks-apps/tree/main/.claude/skills/databricks-dbsql
Command: npx skills add https://github.com/datasciencemonkey/coding-agents-databricks-apps --skill databricks-dbsql

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

DBSQL provides a comprehensive set of procedural, analytical, and governance features that let data teams implement complex data pipelines inside Databricks SQL, reducing manual orchestration and external tooling.

Core Features & Use Cases

  • Procedural SQL & scripting: automate ETL and data-munging tasks with BEGIN...END blocks, variables, and control flow.
  • Stored procedures, transactions & MV: create reusable routines, atomic blocks, and reliable materialized views to accelerate BI workloads.
  • Advanced querying & integration: leverage Recursive CTEs, pipe syntax, and Lakehouse Federation-ready queries for scalable analytics.

Quick Start

Run a sample workflow that demonstrates a simple stored procedure, a recursive CTE, and a materialized view on a serverless Databricks SQL warehouse.

Frequently Asked Questions about databricks-dbsql

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

FAQPage Schema
How do I write procedural SQL and stored procedures in Databricks SQL?▼

Procedural SQL in Databricks SQL lets you automate ETL tasks using BEGIN...END blocks, variables, control flow, and stored procedures to create reusable routines. This reduces manual orchestration and external tooling for data pipelines.

Can I use recursive CTEs and materialized views in Databricks SQL?▼

Yes, Databricks SQL supports recursive CTEs for hierarchical querying and materialized views to accelerate BI workloads. These features enable advanced querying and reliable data acceleration across lakehouse environments.

Does Databricks SQL support transactions across Unity Catalog-managed environments?▼

Databricks SQL supports transactions through atomic blocks ensuring safe governance across Unity Catalog-managed environments. This provides reliable, scalable DBSQL usage for complex data pipelines and BI workloads.

What is the best way to optimize serverless Databricks SQL warehouses?▼

Optimize serverless Databricks SQL warehouses by implementing procedural SQL, materialized views, and Lakehouse Federation-ready queries. These patterns ensure scalable analytics and efficient DBSQL usage across data pipelines.

When do I need procedural SQL in Databricks instead of external orchestration tools?▼

You need procedural SQL in Databricks when automating ETL and data-munging tasks with variables and control flow. This approach reduces manual orchestration and eliminates external tooling dependencies inside DBSQL.

Related Skills

Explore More Data & Analytics Skills→
leary-pokenleary-poken
1

databricks-dbsql

Document advanced Databricks SQL patterns for procedural SQL, stored procedures, and governance.

Community
Advanced
RamVegirajuRamVegiraju
4

databricks-dbsql

Automate Databricks SQL workflows with procedural SQL, recursive queries, and materialized views.

Community
Advanced
databrickslabsdatabrickslabs
38

databricks-dbsql

Implement Databricks SQL workflows with stored procedures and geospatial functions.

Official
Advanced
aaronachermannaaronachermann

databricks-dbsql

Describe Databricks SQL advanced features for analytics pipelines.

Community
Advanced