ClickHouse Data Seeding Script

Overview

Architecture

Prerequisites

Usage

Basic Usage

High Volume Load Testing

Custom Configuration

Single Environment Mode with Specific IDs

Configuration Options

Multi-Organization Mode Options

Single Environment Mode Options

Data Volume Estimates

At scale=1 (default)

Derived Data

At scale=10

Organization Profiles

Enterprise (High Volume)

Large

Medium

Workflow Templates

Time Distribution

Business Hours Weighting

Weekend Reduction

Peak Patterns

Data Tables Populated

Primary Tables (Direct Insert)

Materialized Views (Auto-Populated)

Status Distributions

Workflow Runs

Step Runs

Delivery Lifecycle

Example Output

Troubleshooting

Connection Errors

Out of Memory

Slow Insertion

Development

File Structure

Adding New Organization Profiles

Adding New Workflow Templates

Performance Tips

Notes