Databricks SQL Parser Support in GSP

Explore the Databricks SQL Parser product page

This page documents the SQL syntax support for Databricks in the General SQL Parser.

Syntax Coverage Corpus

GSP tests Databricks syntax against 38 documented constructs grouped into 24 categories, each cross-referenced to the documentation that defines it (38 distinct source pages).

Parse coverage

Measured against GSP Java 4.2.8 on 2026-08-31 (UTC) (artifact sha256 1117856ef134). Each construct below carries the complete set of examples from the Databricks documentation; a construct counts as fully covered only when every one of its examples parses. Percentages are pass rates over this documented-example corpus — not a percentage of the entire SQL dialect.

	Constructs fully parsed	Individual statements parsed
All constructs	34 of 38 (89%)	86 of 91 (95%)
SELECT (queries)	6 of 6 (100%)	11 of 11 (100%)
DML (INSERT / UPDATE / DELETE / MERGE)	4 of 4 (100%)	12 of 12 (100%)
Stored procedures	0 of 1 (0%)	2 of 3 (67%)

Statements are split using the parser's own statement splitter, so multi-statement examples and procedure bodies are counted correctly. The SELECT, DML and stored-procedure rows classify each statement by its parsed statement type: a construct is counted in a row when its examples contain at least one statement of that class, and is fully parsed when all of them parse. Stored procedures covers CREATE PROCEDURE / FUNCTION / PACKAGE / TRIGGER definitions and anonymous blocks.

Machine-readable: dialect data (JSON) · all-dialect matrix · coverage matrix overview

All 38 constructs

Construct	Category	Parses	Specified in
ALTER TABLE	ALTER	4 of 5	Databricks docs
ALTER VIEW	ALTER	all 3	Databricks docs
ANALYZE TABLE	ANALYZE	all 3	Databricks docs
CACHE TABLE	CACHE	1 of 3	Databricks docs
COPY INTO	COPY	all 3	Databricks docs
CREATE FUNCTION	CREATE	2 of 3	Databricks docs
CREATE SCHEMA	CREATE	all 2	Databricks docs
CREATE TABLE	CREATE	all 1	Databricks docs
CREATE TABLE CLONE	CREATE	all 3	Databricks docs
CREATE TABLE LIKE	CREATE	all 2	Databricks docs
CREATE VIEW	CREATE	all 2	Databricks docs
DELETE FROM	DELETE	all 3	Databricks docs
MERGE INTO	DELTA	all 1	Databricks docs
DESCRIBE HISTORY	DESCRIBE	1 of 2	Databricks docs
DESCRIBE TABLE	DESCRIBE	all 3	Databricks docs
DROP SCHEMA	DROP	all 2	Databricks docs
DROP TABLE	DROP	all 2	Databricks docs
DROP VIEW	DROP	all 2	Databricks docs
EXPLAIN	EXPLAIN	all 3	Databricks docs
GRANT	GRANT	all 3	Databricks docs
INSERT	INSERT	all 5	Databricks docs
OPTIMIZE	OPTIMIZE	all 3	Databricks docs
MSCK REPAIR TABLE	REPAIR	all 1	Databricks docs
RESTORE	RESTORE	all 2	Databricks docs
REVOKE	REVOKE	all 2	Databricks docs
Common Table Expression	SELECT	all 2	Databricks docs
LATERAL VIEW	SELECT	all 3	Databricks docs
PIVOT	SELECT	all 1	Databricks docs
SELECT	SELECT	all 1	Databricks docs
Time Travel	SELECT	all 2	Databricks docs
SET	SET	all 2	Databricks docs
SHOW COLUMNS	SHOW	all 2	Databricks docs
SHOW TABLES	SHOW	all 3	Databricks docs
TRUNCATE TABLE	TRUNCATE	all 2	Databricks docs
UPDATE	UPDATE	all 3	Databricks docs
USE SCHEMA	USE	all 1	Databricks docs
VACUUM	VACUUM	all 3	Databricks docs
VALUES	VALUES	all 2	Databricks docs

Key Features Supported

• Standard SQL operations (SELECT, INSERT, UPDATE, DELETE)
• Delta Lake operations (MERGE, OPTIMIZE, VACUUM)
• Spark SQL functions and data types
• Window functions and analytical queries
• Streaming operations and structured streaming
• Unity Catalog and data governance features