databricks-synthetic-data-gen

Generate realistic synthetic data for Databricks using Spark, Faker, and Pandas UDFs.

Updated Mar 19, 2026
One-click install
npx skills add https://github.com/Blackkadder/databricks-apps-and-agents-workshop --skill databricks-synthetic-data-gen-blackkadder
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: databricks-synthetic-data-gen
Source: https://github.com/Blackkadder/databricks-apps-and-agents-workshop/tree/main/.claude/skills/databricks-synthetic-data-gen
Command: npx skills add https://github.com/Blackkadder/databricks-apps-and-agents-workshop --skill databricks-synthetic-data-gen-blackkadder

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires faker, pandas, numpy, holidays, and includes scripts (resource) and references (resource) components.

What problem does it solve?

Generating realistic synthetic data for Databricks enables testing, demos, and development without exposing real data, while providing scalable, controlled datasets that mimic production patterns.

Core Features & Use Cases

  • Spark + Faker + Pandas UDFs for scalable data generation across thousands to millions of rows.
  • Serverless execution by default with multi-format output options (Parquet, JSON, CSV, Delta).
  • Small datasets can be generated locally and uploaded to Unity Catalog volumes; large datasets are generated directly into volumes.
  • Built-in data patterns: non-linear distributions, time-based patterns, and referential integrity to support realistic domain scenarios (e.g., e-commerce, CRM, IoT).

Quick Start

Run the generator to create a representative synthetic dataset (e.g., 10k customers and 50k orders) in your Unity Catalog volume.

Frequently Asked Questions about databricks-synthetic-data-gen

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate realistic synthetic data in Databricks at scale?

Generate scalable synthetic data in Databricks using Spark combined with Faker and Pandas UDFs. This approach scales from thousands to millions of rows while enforcing non-linear distributions, time-based patterns, and referential integrity across domains like e-commerce, CRM, or IoT.

Can I output synthetic data to Delta format and Unity Catalog volumes?

Yes, synthetic data can be output directly to Delta, Parquet, JSON, or CSV formats. Small datasets generate locally for upload to Unity Catalog volumes, while large datasets generate directly into volumes using serverless compute by default.

What is the best way to maintain referential integrity when generating synthetic datasets?

Maintain referential integrity in synthetic datasets by enforcing master-detail generation patterns. This ensures realistic relationships between entities, such as customers and orders, while applying non-linear distributions and time-based patterns for accurate domain modeling.

Does this synthetic data generation approach support serverless compute workloads?

Yes, the synthetic data generation process uses serverless compute by default for Databricks workloads. This allows efficient scaling from small local uploads to massive datasets generated directly within Unity Catalog volumes.

How do I create mock datasets for Databricks demos and sandbox testing?

Create mock datasets for Databricks demos and sandbox testing by running the generator to produce representative synthetic data. A quick start example generates 10,000 customers and 50,000 orders directly into your Unity Catalog volume without exposing real data.

What Python dependencies are needed for scalable synthetic data generation with Spark?

Scalable synthetic data generation with Spark requires the faker, pandas, numpy, and holidays Python dependencies. These libraries support Pandas UDFs to generate realistic, non-linear distributions and time-based patterns across large datasets.