~/talk

Snowflake concepts & architecture

Talkat SQLBits 2024 · 2024-03-19..03-23· [databases]
links:none on file
slides:none on file

Snowflake is a fully managed, cloud data platform that runs on Azure, AWS or GCP and can replicate across them via cloud-agnostic Snowgrid. Storage is decoupled from compute: query engines run in virtual warehouses (MPP compute) that auto-scale and auto-pause, while data lives in optimized compressed columnar stores. Enterprise buys 90-day time travel for point‑in‑time recovery and the engine offers zero-copy cloning so 5 TB table copies don’t duplicate storage. Demos use Azure and a 30‑day $400 free trial.

AI-written summary · about

  1. 0:00Introduction
  2. 1:11Snowflake as cloud platform
  3. 5:47Architecture layers
  4. 9:22Virtual warehouses cost
  5. 13:13Web portal features
  6. 17:01Cloning and time travel
  7. 19:50Security roles
  8. 20:10Summary
~/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.