~/talk

Simplify your ETL with Databricks Delta Lake

Talkat SQLBits 2020 · 2020-09-29..10-04· [data-engineering]
links:none on file
slides:none on file

Explains how Databricks Delta Lake adds an ACID transaction log (JSON commits, min/max stats) so datasets gain time travel, schema enforcement/evolution and upserts via merge into. Demonstrates compaction and ordering reducing 300 small files to 12, cutting a flight-number query from ~20s to ~3s, and shows delta caching plus Spark cache halving repeated query time to ~2s. Covers vacuum to remove old files and notes some optimizations like optimize and ordering require Databricks premium runtime.

AI-written summary · about

  1. 0:00Intro
  2. 1:02Data warehouses vs data lakes
  3. 4:21Baggage of data lakes
  4. 5:49Delta Lake
  5. 7:07Main Concept
  6. 8:49Key Features
  7. 12:42Free vs Premium Version
  8. 13:59Demo
  9. 19:12Vacuum
  10. 22:32Big Data
  11. 25:37Example
  12. 36:22Merge into
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.