~/talk

Designing performant and scalable data lakes

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

Shows how an enterprise data lake on Azure uses Azure Data Lake Storage plus Azure Databricks/HDInsight and Azure Synapse to ingest raw data, apply schema on demand, and serve BI or real‑time apps; recommends organizing by raw/enriched/curated/workspace zones, using parquet and coalescing small files to hit the 100 MB rule of thumb for throughput, and tuning row‑groups to cut IOs from tens of thousands to thousands; covers AAD + RBAC + POSIX ACLs, private endpoints, lifecycle tiers and choosing LRS ZRS GRS GZRS per environment.

AI-written summary · about

  1. 0:00Start
  2. 2:28Traditional on-prem analytics pipeline
  3. 4:53Modern data warehouse
  4. 8:13Advanced Analytics
  5. 9:00Realtime Analytics
  6. 17:01Azure Data Lake Storage Summary
  7. 18:55How do I set up my data lake?
  8. 25:13How do I organize my data?
  9. 29:31How do I secure my data?
  10. 33:14A Little More on Authorization
  11. 39:50How do I manage cost? (Continued...)
  12. 42:32How do I optimize my data lake?
  13. 44:39File size and format
  14. 49:15Partition your data for optimized access
  15. 52:11Query Acceleration (Preview)
~/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.