skills.rest
thbeh
thbehCOMMUNITY
Explore all skills by this author →
GitHub

databricks-dbsql

Execute advanced SQL and AI functions in Databricks SQL.

Updated May 31, 2026
Search Tags:#data analysis#sql#databricks#ai functions#advanced sql
One-click install
npx skills add https://github.com/thbeh/coding-agents-databricks-apps --skill databricks-dbsql-thbeh
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databricks-dbsql
Source: https://github.com/thbeh/coding-agents-databricks-apps/tree/main/.claude/skills/databricks-dbsql
Command: npx skills add https://github.com/thbeh/coding-agents-databricks-apps --skill databricks-dbsql-thbeh

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires databricks-sql, serverless sql warehouse, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill unit offers advanced SQL features and AI functions in Databricks SQL, enabling users to perform complex data analysis and leverage AI capabilities directly within the SQL environment.

Core Features & Use Cases

  • Advanced SQL Functions: Execute advanced SQL operations such as stored procedures, recursive CTEs, transactions, and materialized views.
  • AI Functions: Leverage AI functions like ai_query, ai_classify, and ai_extract to enrich data and perform complex analyses.
  • Use Case: For instance, users can use this Skill to classify support tickets or extract entities from text, enhancing their data analysis capabilities.

Quick Start

Use the databricks-dbsql skill to execute a SQL query and visualize the results in a chart.

Frequently Asked Questions about databricks-dbsql

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

FAQPage Schema
How do I use AI functions to classify text data in Databricks SQL?▼

Use AI functions in Databricks SQL like `ai_classify` to categorize text data and `ai_extract` to pull entities directly within your SQL queries. This enables complex text analysis and data enrichment without leaving the SQL environment.

Can I write stored procedures and recursive CTEs in Databricks SQL?▼

Yes, Databricks SQL supports advanced SQL scripting including stored procedures, recursive CTEs, and transactions. These features allow you to execute complex data transformations and logic directly within your data warehouse.

Do I need a Serverless SQL Warehouse to run advanced SQL features in Databricks?▼

Yes, executing advanced SQL features and AI functions requires a Serverless SQL Warehouse along with Databricks SQL. This serverless compute environment provides the necessary infrastructure to run complex queries and AI functions.

What is the best way to analyze support tickets using Databricks SQL?▼

The best way to analyze support tickets in Databricks SQL is by utilizing built-in AI functions like `ai_classify` to categorize tickets and `ai_extract` to identify key entities. This allows for automated, enriched data analysis directly in SQL.

How do I visualize SQL query results from Databricks?▼

You can execute a SQL query using the databricks-dbsql skill and visualize the results in a chart. This provides immediate visual insights from your advanced SQL operations and AI function outputs.

What are the limitations of using materialized views in Databricks SQL?▼

Materialized views in Databricks SQL are supported for advanced data analysis, but their performance and refresh capabilities depend on the underlying Serverless SQL Warehouse configuration. Proper compute setup is required to maintain them efficiently.

Related Skills

Explore More Data & Analytics Skills→
LaurentPRAT-DBLaurentPRAT-DB

databricks-warehouse-selector

Select the optimal Databricks SQL warehouse by scoring serverless status, cluster size, and naming conventions.

Community
Intermediate
elophantoelophanto
116

analytics-reporting

Analyzes raw data to build dashboards, reports and KPI tracking using SQL and Python/R.

Community
Advanced
leary-pokenleary-poken
1

databricks-genie

Create and manage Databricks Genie Spaces and query them via the Conversation API.

Community
Advanced
Zack2626-okZack2626-ok

databricks-ai-functions

Invoke Databricks AI Functions for sentiment analysis, classification, and summarization in SQL and PySpark pipelines.

Community
Advanced