Data Caterer

Create new plan

Plan name

Plan name required

Define relationships between columns across any task to ensure values remain consistent.

For example, you have a 'create-accounts' task which will create records with column 'account_id' in a CSV file. Another task called 'create-transactions' will also have the column 'account_id' but in a JSON file.
Source: Task: "create-accounts", Columns: "account_id"
Links to: Task: "create-transactions", Columns: "account_id"

With relationship

Accounts

account_id	status	open_date
ACC123	Open	2023-01-01
ACC789	Closed	2023-02-21

Transactions

account_id	amount
ACC123	12.34
ACC789	105.45

For example, we generate transactions with the columns 'account_id,name,date,amount'. We can generate multiple transactions per unique 'account_id,name'.
Below, we set 3 records per unique 'account_id,name' values.

With per unique column values

Transactions

account_id	name	date	amount
ACC123	Peter	2023-01-01	12.34
ACC123	Peter	2023-01-04	67.89
ACC123	Peter	2023-01-15	102.98
ACC789	John	2023-02-01	105.45
ACC789	John	2023-02-12	59.14
ACC789	John	2023-02-25	73.56

Create new plan

Tasks

Relationships

Report

Advanced Configuration