Recovers a managed or external Unity Catalog table, or a materialized view, after it has been dropped, within a 7-day default window. List options using SHOW TABLES DROPPED; choose one by UNDROP TABLE WITH ID.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains UNDROP in context, with comparison tables and the common traps.
Terms in this definition
- External
API Management virtual network mode in which the gateway stays public but can call private back ends inside the VNet.
- Unity Catalog
Azure Databricks' governance solution covering both data and AI in one place, with centralised permissions, auditing, data discovery and lineage.
- Event
Table in Log Analytics where entries from Windows event logs are kept.
- Materialized view
A view that stores its query output ahead of time. A serverless pipeline maintains it, refreshing it on demand with
REFRESH MATERIALIZED VIEW, on a schedule or when upstream data changes, incrementally when it can. - WINDOW
Returns rows from a sorted, optionally partitioned table, either at fixed positions (ABS) or relative to the current row (REL). Running totals plus moving averages are common uses.
- List
Permission on Key Vault secrets allowing a caller to enumerate those in a vault, though their values are not returned.
- Table options
Set only at creation with
OPTIONS, these key-value storage settings can't be altered or dropped afterwards; on Delta tables they also show up among the table properties.