The standard language used to query and manage relational data, short for Structured Query Language. Syntax for SQL warehouses and Databricks Runtime is documented in the Databricks SQL reference.
Also called Structured Query Language.
Read more: Databricks docs
In the Ultra Transcenders books
Each book explains SQL in context, with comparison tables and the common traps.
Terms in this definition
- Standard deployment type
A Foundry deployment type billed per token that keeps processing of prompts and responses inside the Azure geography of the resource, meeting data residency needs at lower volumes.
- MANAGE
A Unity Catalog privilege allowing a principal to grant and revoke access on an object, hand over its ownership and drop it, all without being the owner. It gives no data access by itself and is not part of
ALL PRIVILEGES. - SQL
Relational databases such as Azure SQL Database are queried, defined and updated using this standard language.
- Serverless
Compute tier for single Azure SQL databases that scales automatically, pauses when idle and charges by the second. It is offered in General Purpose and Hyperscale, not Business Critical, and reserved capacity does not apply.
- Databricks Runtime
The software image, Apache Spark among its core parts, that Azure Databricks installs on compute. Long-term support (LTS) releases are the advised choice when job compute runs production work.
- Databricks SQL
Brings warehousing to an Azure Databricks lakehouse. ANSI SQL runs against Delta tables using SQL warehouses, compute tuned for heavy query concurrency and BI tools.