A SQL command reporting facts about a whole Delta or Iceberg table rather than its columns, such as where it is stored, how big it is, how many files it has, how it is partitioned and which protocol versions it uses.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains DESCRIBE DETAIL in context, with comparison tables and the common traps.
Terms in this definition
- 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.
- Event
Table in Log Analytics where entries from Windows event logs are kept.
- WHERE
Limits a SELECT, UPDATE or DELETE to just the rows meeting a condition. Omit it, and the statement hits every row.