databricks-synthetic-data-generation

Generate synthetic customer, order, and ticket data as parquet files in Databricks Volumes.

Updated Mar 10, 2026
One-click install
npx skills add https://github.com/robkisk/coding-agents-databricks-app --skill databricks-synthetic-data-generation-robkisk
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: databricks-synthetic-data-generation
Source: https://github.com/robkisk/coding-agents-databricks-app/tree/main/.claude/skills/databricks-synthetic-data-generation
Command: npx skills add https://github.com/robkisk/coding-agents-databricks-app --skill databricks-synthetic-data-generation-robkisk

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the creation of realistic, story-driven synthetic data for Databricks, enabling robust testing, effective demos, and the generation of synthetic tables.

Core Features & Use Cases

  • Realistic Data Generation: Uses Faker and Spark to create data with non-linear distributions, integrity constraints, and temporal patterns.
  • Databricks Integration: Saves generated data directly to Databricks Volumes in parquet format.
  • Workflow Automation: Supports a robust workflow of local file editing, execution on Databricks, and context reuse for faster iterations.
  • Use Case: Generate a dataset of 10,000 customer orders with realistic amounts, statuses, and order dates, ensuring that higher-tier customers generate more orders, and save it to a specified Databricks schema and volume.

Quick Start

Use the databricks-synthetic-data-generation skill to create 10,000 customer orders and save them to the 'my_catalog.my_schema.raw_data' volume.

Frequently Asked Questions about databricks-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 testing?

This approach uses Python, Faker, and Spark to generate Databricks synthetic data with non-linear distributions, integrity constraints, and temporal patterns. It creates story-driven datasets of customer, order, and ticket records to enable robust testing and effective demos.

How do I create synthetic data with non-linear distributions in Spark?

To create synthetic data with non-linear distributions in Spark, you configure the generation logic so higher-tier customers produce more orders. This ensures the synthetic data follows realistic business constraints and temporal patterns rather than uniform random distribution.

Can I save generated synthetic data directly to Databricks Volumes as parquet?

Yes, the workflow automates saving generated synthetic data directly to Databricks Volumes as parquet files. You specify the target Databricks schema and volume, and the output is written there for immediate downstream processing.

Do I need PySpark and Faker to generate synthetic tables in Databricks?

Yes, you need PySpark and Faker alongside numpy, pandas, and holidays to generate synthetic tables in Databricks. These dependencies support the creation of realistic data with temporal patterns and integrity constraints executed on Databricks clusters.

What is the best way to iteratively develop synthetic data scripts for Databricks clusters?

The best way to iteratively develop synthetic data scripts for Databricks clusters is to edit files locally and execute them remotely with context reuse. This workflow supports faster iterations when refining customer, order, and ticket data generation logic.

Does synthetic data generation support temporal patterns and integrity constraints?

Yes, synthetic data generation supports temporal patterns and integrity constraints. By using Faker and Spark, the generated customer, order, and ticket datasets maintain realistic time-based behaviors and relational integrity for accurate testing and demonstrations.