databricks-sql-reference

Reference Databricks SQL syntax, functions, and optimization techniques.

Updated Mar 31, 2026
One-click install
npx skills add https://github.com/bspt628/databricks-lakeview-skills --skill databricks-sql-reference
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: databricks-sql-reference
Source: https://github.com/bspt628/databricks-lakeview-skills/tree/main/sql-reference
Command: npx skills add https://github.com/bspt628/databricks-lakeview-skills --skill databricks-sql-reference

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Databricks SQLの文法と関数を参照できる一元ガイドを提供し、複雑なクエリの作成を迅速化します。

Core Features & Use Cases

  • Databricks独自関数の紹介、型変換、正規表現、文字列操作、日付・配列関数、パフォーマンス最適化の手法を網羅します。
  • 実務でのクエリ作成や最適化、デバッグ、教育目的の学習に適用可能です。

Quick Start

Look up a Databricks SQL function and apply its syntax to your query.

Frequently Asked Questions about databricks-sql-reference

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

FAQPage Schema
How do I optimize Databricks SQL query performance for typical analytics workflows?

Databricks SQL performance can be optimized using specific functions and safe query design techniques outlined in the reference. It covers optimization tips and concrete examples to accelerate query development.

What Databricks SQL functions are available for string manipulation and regex operations?

Databricks SQL provides built-in functions for string manipulation and regex operations. The reference guide details these functions with usage guidance and concrete examples to ensure correct application.

How do I handle date and array operations in Databricks SQL?

Databricks SQL supports specific date and array functions for data transformations. The reference guide covers these operations with usage examples to ensure correct function versions and safe query design.

Can I use standard SQL syntax for data type conversions in Databricks?

Databricks SQL supports data type conversions using its specific functions. The reference guide details the correct syntax and function versions needed to ensure safe query design and accurate conversions.

What is the best way to look up Databricks-specific functions for query development?

The best way to look up Databricks-specific functions is using a compact reference guide. It provides syntax, usage guidance, and concrete examples to accelerate query development and ensure correct function versions.

Are there limitations when using Databricks SQL functions for complex query design?

Databricks SQL functions require correct versions and safe query design to avoid limitations. The reference guide includes usage guidance and concrete examples to prevent errors during complex query development.