Fabricate is used create a full relational data

Take sql script to create the whole datbase

Can update the column types

Can set cardinality for orders per customer

Can help to choose some enum values for percentage of columns together

No limit on number of records

An api for automating the data

Can upload data into fabricate

Can freeze columns so the data will remain static

If you need to calculate from other columns

Can you create case statements between tables

Kind of like excel to hide columns that you may want to include

Grab a column from another table

For order items, we can use a view to grab items

Is there a way to maintain consistency. Denormalize to take care of that.

From Karim: How can to replicate crappy data?

You can insert typos in the data

Can Use Views to create a materialize it?

Price

Fabricate is part of Tonic

$500 dollars a year

100k rows per table

How to handle with order items → orders → customer

Can you generate a duplicate a database? Yes, you can

Up to 5 teammates

Can use json, by putting period before the name

Create the raw tables and then you can put a view on top of it

Do you have a common library for typical formats?

Can use AI for describing a facebook format and use that in fabricate

Fabricate can create a mock api to read the database

More crap data

• Can we deliberately not fulfill a proper format
• Can we can the characters sets?
• Fabricate does not have a random garbage generator?
• Not at the moment
• Can get Mark in the app
• Can do a rank and sum over in rows

Creating the data via the api

The api

There is an unlimited free tier to play with the data

From Mark, start with the schema and then go from here.