Rows older than a set number of days, measured from a timestamp column, are removed automatically (DELETE ROWS ... DAYS AFTER). It covers Unity Catalog managed Delta or Iceberg tables plus pipeline streaming tables, depends on predictive optimization, and runs at no guaranteed time.
Also called auto time-to-live.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Auto-TTL in context, with comparison tables and the common traps.
Terms in this definition
- Set
Secret permission in Key Vault for writing secrets; some older material refers to it as Create.
- TIMESTAMP
Represents a moment in time and displays it in the session's time zone.
TIMESTAMP_NTZis the variant with no time zone. - CRUD
Shorthand for create, read, update and delete, the four basic things you do with data. Data-plane roles in Azure Cosmos DB, for instance, authorise those operations on items.
- Unity Catalog
Azure Databricks' governance solution covering both data and AI in one place, with centralised permissions, auditing, data discovery and lineage.
- Iceberg
An open format for tables. Within Unity Catalog, managed ones are available and foreign ones can only be read, while the docs cover
USING ICEBERGon materialized views but not on AUTO CDC streaming tables. - Pipeline
Groups activities logically so that, together, they move and transform data, either one after another or side by side; found in both Azure Data Factory and Microsoft Fabric.
- Streaming
Sending model output piece by piece as server-sent events. Only the delivery changes; the answer's content, completeness and cost stay the same.
- Predictive optimization
Unity Catalog managed tables can have
OPTIMIZE,VACUUMandANALYZEscheduled and run for them on serverless compute without manual effort. Accounts created on or after 11 November 2024 get this turned on by default.