sqlsynthgen

sqlsynthgen is a package for making copies of relational databases and populating them with random data.

If you are new to sqlsynthgen (SSG for short), we recommend going through the pages of this documentation roughly in order: After installing SSG and learning the basic commands that it uses from the quick start guide, the introductory tutorial will walk you through a relatively simple use case in detail. You can then look at one of our other two example use cases, one for financial data and one for health data. The latter also goes through some more advanced features of SSG and how to use them, that are relevant beyond health data use cases.

Note

This project will be under active development from Jan - Oct 2023

Note

We do not currently support tables without primary keys. If you have tables without primary keys, some sqlsynthgen functionality may work but vocabulary tables will not.

Contents:

• Installation
• Quick Start
• Introductory Tutorial
  • Default Behavior
  • Vocabulary Tables
  • Specifying Row-based Custom Generators
  • Using Aggregate Statistics from the Source Data
  • Stories Within the Data
• Example: Loan Data
  • Intro
  • Setup
  • Generating Data Uniformly at Random
  • Improving Data Generation with Vocabularies
  • Adding a Foreign Key
  • Marginal Distributions with Differential Privacy
• Advanced Example: OMOP Health Data
  • Dealing with Circular Foreign Keys
  • Vocabulary Tables
  • Configuration for OMOP
• Configuration Reference
• API Reference
  • Submodules
  • sqlsynthgen.create module
  • sqlsynthgen.main module
  • sqlsynthgen.make module
  • sqlsynthgen.providers module
  • sqlsynthgen.settings module
• FAQ
  • Can SqlSynthGen work with two different schemas?
  • Which DBMSs does SqlSynthGen support?
• Glossary

Indices and Tables

• Index

• Module Index