skills.rest
teegin-g
teegin-gCOMMUNITY
Explore all skills by this author →
GitHub

databricks-dbsql

Apply advanced Datasheet SQL features including recursive CTEs and stored procedures.

Updated Jan 30, 2026
Search Tags:#sql#lakehouse#databricks#dbsql#procedural-sql#recursive-ctes
One-click install
npx skills add https://github.com/teegin-g/Slopcast --skill databricks-dbsql-teegin-g
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databricks-dbsql
Source: https://github.com/teegin-g/Slopcast/tree/main/.agents/skills/databricks-dbsql
Command: npx skills add https://github.com/teegin-g/Slopcast --skill databricks-dbsql-teegin-g

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill helps data teams leverage Databricks SQL (DBSQL) advanced features to build robust, scalable analytics pipelines and governance in Lakehouse environments.

Core Features & Use Cases

  • Procedural SQL: use BEGIN...END blocks, DECLARE variables, and control flow for ETL and validation.
  • Advanced analytics: recursive CTEs, transactions, and upserts with MERGE-like patterns to handle complex data lifecycles.
  • DBSQL components: stored procedures, dynamic SQL, materialized views, and pipe syntax for readable transformations.
  • Lakehouse federation: leverage remote_query, http_request, read_files, and AI-enabled functions in cross-database analytics.
  • Use case example: orchestrate multi-table updates, build BI-ready gold models, and accelerate dashboards with serverless warehouses.

Quick Start

Run a sample DBSQL query that demonstrates a recursive CTE and a materialized view refresh.

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 scripts in Databricks SQL?▼

Recursive CTEs in Databricks SQL handle hierarchical data structures and complex data lifecycles by referencing themselves. You use them for multi-level traversals, building BI-ready gold models, and orchestrating advanced analytics transformations.

What is the best way to build BI-ready gold models in a Databricks lakehouse?▼

Building BI-ready gold models in a Databricks lakehouse uses materialized views, upserts with MERGE patterns, and serverless warehouses. This accelerates dashboard performance and structures transformed data for downstream analytics.

Does Databricks SQL support lakehouse federation for remote queries?▼

Stored procedures in Databricks SQL encapsulate dynamic SQL and business logic for reusable transformations. They orchestrate multi-table updates and complex data lifecycles, reducing pipeline redundancy and enforcing governance.

When should I use serverless warehouses for Databricks SQL performance optimization?▼

Use serverless warehouses for Databricks SQL performance optimization when accelerating dashboards and scaling analytics pipelines. They provide automatic compute scaling and codify best practices for robust lakehouse query execution.

Related Skills

Explore More Data & Analytics Skills→
aaronachermannaaronachermann

databricks-dbsql

Describe Databricks SQL advanced features for analytics pipelines.

Community
Advanced
ivanshamaevivanshamaev
14

starrocks-realtime-analytics

Design StarRocks real-time analytics pipelines from Kafka streams to BI-ready queries.

Community
Advanced
mkgs-databricks-demosmkgs-databricks-demos
1

databricks-dbsql

Execute procedural SQL, MERGE upserts, and recursive queries in Databricks DBSQL.

Official
Advanced
BlackkadderBlackkadder

databricks-dbsql

Enable procedural SQL, stored procedures, and recursive CTEs in Databricks SQL.

Community
Advanced