SQL reference for SQL Analytics
This is a SQL command reference for Databricks SQL Analytics.
General reference
This general reference describes data types, functions, identifiers, literals, and semantics:
DDL statements
You use data definition statements to create or modify the structure of database objects in a database:
Data retrieval statements
You use the SELECT
statement to retrieve rows
from one or more tables according to the specified clauses. The full syntax
and brief description of supported clauses are explained in
SELECT. The SQL statements related
to SELECT
are also included in this section.
SQL Analytics also provides the ability to generate logical and physical plan for a query using the EXPLAIN statement.
Delta Lake statements
You use Delta Lake SQL statements to manage tables stored in Delta Lake format:
For details on using Delta Lake statements, see Delta Lake and Delta Engine guide.
Auxiliary statements
You use auxiliary statements to collect statistics, manage caching, explore metadata, set configurations, and manage resources:
Security statements
You use security SQL statements to manage access to data:
For details using these statements, see Data object privileges.