synthetic-data-generation

Generate synthetic Databricks datasets with Faker and Spark, saved as Parquet.

1.8k|404|Updated Dec 17, 2025
One-click install
npx skills add https://github.com/databricks-solutions/ai-dev-kit --skill synthetic-data-generation
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: synthetic-data-generation
Source: https://github.com/databricks-solutions/ai-dev-kit/tree/main/databricks-skills/synthetic-data-generation
Command: npx skills add https://github.com/databricks-solutions/ai-dev-kit --skill synthetic-data-generation

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires numpy, pandas, faker, holidays, pyspark.

What problem does it solve?

This Skill generates realistic synthetic data for Databricks workloads using Faker and Spark, enabling safe testing, demos, and data validation without exposing real customer data.

Core Features & Use Cases

  • Generate master and related tables (customers, orders, tickets) with non-linear distributions, temporal patterns, and holiday effects.
  • Save data to Databricks volumes as Parquet to support downstream SDP pipelines (bronze, silver, gold).
  • Configure data size and date range to simulate varied analytics workloads and scenarios.

Quick Start

Run the data generation script to produce a synthetic dataset (e.g., 2,500 customers, 25,000 orders, 8,000 tickets) and write it to your Databricks volume. Install required libraries if missing: pip install faker holidays

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 testing Databricks workloads?

To generate realistic synthetic data for Databricks, you can use this Skill to produce coherent, non-sensitive datasets with Faker and PySpark, writing the output as Parquet files to a Databricks volume.

What is the best way to create non-sensitive test datasets with temporal patterns in Spark?

The best way to create non-sensitive test datasets with temporal patterns in Spark is using Faker to simulate non-linear distributions and holiday effects, then saving the output as Parquet for downstream pipelines.

Do I need to install Faker and holidays to generate synthetic data in PySpark?

Yes, you need to install the Faker and holidays Python libraries to generate synthetic data in PySpark. These dependencies provide realistic temporal patterns and varied data domains for your datasets.

Can I generate related master and transaction tables like customers and orders for demos?

Yes, you can generate related master and transaction tables like customers and orders for demos. This Skill creates coherent datasets across multiple data domains, including varied sizes and date ranges.

How does saving synthetic data as Parquet to a Databricks volume support analytics pipelines?

Saving synthetic data as Parquet to a Databricks volume supports downstream SDP pipelines by providing structured bronze, silver, and gold data layers for safe testing, training, and data validation.

What are the limitations of using Faker for synthetic data generation in Spark?

A limitation of using Faker for synthetic data generation in Spark is that while it produces realistic distributions and temporal effects, the data is entirely artificial and requires PySpark handling for large-scale processing.