Creating data for related tables

Can we create data for related tables, example parent and child tables.

First, create your schema for the parent table and generate some data in csv format. Then upload the csv file back into Mockaroo as a new Dataset. If the file is particularly large, you may want upload a csv file containing just the primary key column instead (or any other columns you plan to reference in your child table). Finally, create the schema for your child table, and pull in the primary key column from your parent table using the “Dataset Column” field type.

Here’s a video tutorial: https://youtu.be/XATDlwG1azU?list=PLKMZcxOsC3u0Y-4CHg5SDpVjTcrvGttTt

1 Like

Hey thank you so much… Shall definitely try that !!!

If there are many related tables, you can use mockaroo APIs and postman to do this in bulk. Refer this blog post for details.

I was hoping to find that blog post to read more, but:

404

Sorry, the page you’re looking for doesn’t exist.

updated blog link

1 Like

thanks! Also, thanks for the super quick response! :slight_smile:

I just launched Fabricate, which is a data generation tool aimed at large scale relational databases. Creating CSV files related by fk-pk relationships has always been tedious in Mockaroo. Fabricate solves this and much more. If you’ve been using Mockaroo to generate data for relational databases, I suggest you check out Fabricate. It should make your life a lot easier.

hey , can anyone tell about the pricing of fabricate ?