Data workflow guides

Generate the same synthetic table from a seed

·

Use a small synthetic table to reproduce an import test without relying on a production export. A seed repeats the same draws while the column settings control which values your importer sees.

Random Data Table Generator

Build the three-row table with seed 42

Select Load example and Generate table. The example uses seed 42 and four columns. It draws a six-digit text ID, an integer from 1 to 9, a boolean and a text note for each row.

The first row has ID 037913, quantity 5, active false and note Birch. Select Generate table again with the same settings and compare the rows. The values and their order stay the same.

CSV with the original column settings and seed 42
id,quantity,active,note
037913,5,false,Birch
097291,8,true,Dune
060434,3,true,Cedar

RFC 4180, common CSV field rulesRFC 8259, JSON values and data types

Verify a padded identifier in the JSON export

Choose JSON under Export format without drawing new rows. The first ID is the string "037913", quantity is the number 5 and active is the boolean false. Download random-data-table.json and compare that record with the preview.

Choose CSV and download random-data-table.csv for a CSV importer. Set the ID column to text if the importer would drop the leading zero. The CSV format stores field text. A Null column produces empty CSV fields and actual null values in JSON.

RFC 4180, common CSV field rulesRFC 8259, JSON values and data types

Change the seed and keep the fields

Change Seed to 43 and generate again. The first row now has ID 098643, quantity 6, active true and note Dune. Change the seed back to 42 to restore the first dataset.

For a column that must stay in an allowed range, enter minimum and maximum bounds before generating. Preserve the seed and the rest of the settings with the test so someone else can replay it.

RFC 8259, JSON values and data types

Common questions

What happens if I add another column to a seeded table?

A column can consume extra draws, so later cells can change. Save the complete column order and settings with the seed.

Do date fields become JSON date objects?

The date field produces a YYYY-MM-DD string. Decode it as a date in your test harness only when its schema calls for one.

Sources

Put it into practice.

Related guides