Databricks · Databricks Data Analyst Associate
Lakehouse Federation and time travel
Databricks Data Analyst Associate · Lesson 10 of 18 · 1:05:50
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the Databricks Certified Data Analyst Associate exam. In this lesson: Lakehouse Federation (connections and read-only foreign catalogs), joining federated and Delta tables in one query, when to ingest instead, table versions, VERSION AS OF and TIMESTAMP AS OF, RESTORE, and retention with VACUUM. Includes three original practice questions.
Preview the topics
- The analyst wants to query the invoices of the finance PostgreSQL database from Databricks SQL, with no copy, under Unity Catalog permissions. What must exist first?
- A report must be rebuilt from the rentals table exactly as it looked yesterday at 8:00, before a late load changed some rows. The table must stay as it is. Which query fits?
- On Tuesday morning, a bad update overwrote the prices of half the bikes. An hour later, the analyst wants the whole bikes table back as it was just before, with a trace of the mistake kept in the history. What should the analyst run?