synthetic-data-generation

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

1|1|Updated Nov 9, 2025
One-click install
npx skills add https://github.com/Paldom/databricks-apps-streamlit-vibe-coding-starter --skill synthetic-data-generation-paldom
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: synthetic-data-generation
Source: https://github.com/Paldom/databricks-apps-streamlit-vibe-coding-starter/tree/main/.agents/skills/synthetic-data-generation
Command: npx skills add https://github.com/Paldom/databricks-apps-streamlit-vibe-coding-starter --skill synthetic-data-generation-paldom

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the creation of realistic, story-driven synthetic data for Databricks, eliminating the need for manual data creation or the use of sensitive production data for testing and development.

Core Features & Use Cases

  • Realistic Data Generation: Creates synthetic datasets with non-linear distributions, referential integrity, and time-based patterns using Faker and Spark.
  • Databricks Integration: Saves generated data as Parquet files directly into Unity Catalog Volumes, ready for downstream Spark Declarative Pipelines (SDP).
  • Use Case: Generate 10,000 realistic customer orders with associated customer details and support tickets for a new feature demo, ensuring data integrity and believable distributions.

Quick Start

Use the synthetic-data-generation skill to create 5,000 customer records and 10,000 order records in the 'my_catalog.my_schema' schema.

Frequently Asked Questions about synthetic-data-generation

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

FAQPage Schema
How do I generate realistic synthetic data for Databricks?

You can generate realistic synthetic data for Databricks using Python, Faker, and Spark to create datasets with non-linear distributions, referential integrity, and time-based patterns. The generated data is saved as Parquet files directly into Unity Catalog Volumes.

Can I use Faker to create synthetic datasets with referential integrity in Spark?

Yes, you can use Faker with Spark to create synthetic datasets that maintain referential integrity across related tables, such as linking customer records to their associated orders and support tickets for believable distributions.

What's the best way to create test data for Spark Declarative Pipelines?

The best way to create test data for Spark Declarative Pipelines is to generate story-driven synthetic datasets and save them as Parquet files into Unity Catalog Volumes, which serve as the direct input source for your downstream pipelines.

Does synthetic data generation work with Unity Catalog Volumes?

Yes, synthetic data generation works with Unity Catalog Volumes by saving the raw generated data as Parquet files directly into the catalog schema, making it immediately accessible for analytics and AI development.

Why use synthetic data instead of production data for Databricks demos?

Using synthetic data eliminates the need for sensitive production data during testing and development. It automates the creation of story-driven datasets, ensuring data privacy while providing realistic distributions for feature demos.

Do I need Python and Spark to generate synthetic data for my data pipelines?

Yes, you need Python and Spark alongside the Faker and holidays libraries to generate synthetic data with non-linear distributions and time-based patterns for your data pipelines.