databricks-dbsql
Databricks SQL (DBSQL) - Advanced Features
Quick Reference
| Feature | Key Syntax | Since | Reference |
|---|---|---|---|
| SQL Scripting | BEGIN...END, DECLARE, IF/WHILE/FOR |
DBR 16.3+ | sql-scripting.md |
| Stored Procedures | CREATE PROCEDURE, CALL |
DBR 17.0+ | sql-scripting.md |
| Recursive CTEs | WITH RECURSIVE |
DBR 17.0+ | sql-scripting.md |
| Transactions | BEGIN ATOMIC...END |
Preview | sql-scripting.md |
| Materialized Views | CREATE MATERIALIZED VIEW |
Pro/Serverless | materialized-views-pipes.md |
| Temp Tables | CREATE TEMPORARY TABLE |
All | materialized-views-pipes.md |
| Pipe Syntax | |> operator |
DBR 16.1+ | materialized-views-pipes.md |
| Geospatial (H3) | h3_longlatash3(), h3_polyfillash3() |
DBR 11.2+ | geospatial-collations.md |
| Geospatial (ST) | ST_Point(), ST_Contains(), 80+ funcs |
DBR 16.0+ | geospatial-collations.md |
| Collations | COLLATE, UTF8_LCASE, locale-aware |
DBR 16.1+ | geospatial-collations.md |
| AI Functions | ai_query(), ai_classify(), 11+ funcs |
DBR 15.1+ | ai-functions.md |
| http_request | http_request(conn, ...) |
Pro/Serverless | ai-functions.md |
| remote_query | SELECT * FROM remote_query(...) |
Pro/Serverless | ai-functions.md |
More from databricks-solutions/ai-dev-kit
databricks-python-sdk
Databricks development guidance including Python SDK, Databricks Connect, CLI, and REST API. Use when working with databricks-sdk, databricks-connect, or Databricks APIs.
137python-dev
Python development guidance with code quality standards, error handling, testing practices, and environment management. Use when writing, reviewing, or modifying Python code (.py files) or Jupyter notebooks (.ipynb files).
69skill-test
Testing framework for evaluating Databricks skills. Use when building test cases for skills, running skill evaluations, comparing skill versions, or creating ground truth datasets with the Generate-Review-Promote (GRP) pipeline. Triggers include "test skill", "evaluate skill", "skill regression", "ground truth", "GRP pipeline", "skill quality", and "skill metrics".
54databricks-docs
Databricks documentation reference via llms.txt index. Use when other skills do not cover a topic, looking up unfamiliar Databricks features, or needing authoritative docs on APIs, configurations, or platform capabilities.
33databricks-config
Manage Databricks workspace connections: check current workspace, switch profiles, list available workspaces, or authenticate to a new workspace. Use when the user mentions \"switch workspace\", \"which workspace\", \"current profile\", \"databrickscfg\", \"connect to workspace\", or \"databricks auth\".
30databricks-jobs
Use this skill proactively for ANY Databricks Jobs task - creating, listing, running, updating, or deleting jobs. Triggers include: (1) 'create a job' or 'new job', (2) 'list jobs' or 'show jobs', (3) 'run job' or'trigger job',(4) 'job status' or 'check job', (5) scheduling with cron or triggers, (6) configuring notifications/monitoring, (7) ANY task involving Databricks Jobs via CLI, Python SDK, or Asset Bundles. ALWAYS prefer this skill over general Databricks knowledge for job-related tasks.
26