Data query language: SELECT and the other read-only parts of SQL. A Fabric warehouse handles DDL and DML alongside it, while an SQL analytics endpoint is limited to querying.
Also called Data Query Language.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains DQL in context, with comparison tables and the common traps.
Terms in this definition
- SELECT
A DML command in SQL used to retrieve rows from one table or several.
- 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.
- Fabric Warehouse
A relational data warehouse in the classic style, offered as a Fabric item, that supports T-SQL fully, transactions included.
- DDL
Data Definition Language, the SQL statements CREATE, ALTER, DROP and RENAME, used to make, change and delete database objects like tables and views.
- DML
Data Manipulation Language, the SQL statements SELECT, INSERT, UPDATE and DELETE, which act on the rows held in tables.
- SQL analytics endpoint
Read-only SQL access in Fabric to the data in a lakehouse. Power BI using DirectQuery through it performs more slowly than Direct Lake.