~/talk

Generate test data quick, easy and lots of it with the Databricks Labs Data Generator

Talkat SQLBits 2023 · 2023-03-14..03-18· [data-engineering]
links:none on file
slides:none on file

Databricks Labs Data Generator uses Spark to create synthetic data at cluster scale, generating 100 million rows in 11s on a 12‑node (104‑core) cluster and scaling to 1B in ~3m, 10B in ~18m. It reads table schemas or specs, emits DataFrame output and writes to Delta or Parquet, supports regex and Spark SQL expressions to relate columns, and achieves repeatable referential-like joins via seeding. Requires tuning shuffle partitions to match cluster cores and some example integrations (regex, Faker) need manual fixes.

AI-written summary · about

  1. 0:00Introduction and setup
  2. 3:18Need for synthetic test data
  3. 6:10Installing the data generator
  4. 8:57Generating 100 million rows
  5. 10:20Scaling to billions of rows
  6. 11:03Customizing column generation
  7. 13:10Using regex for data patterns
  8. 14:12Generating from existing tables
  9. 15:15Referential integrity in data
  10. 17:21Limitations and integrations
  11. 18:49Summary and Q&A
~/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.