AppsSynthetic Data

Quality and variety · Autessa Synthetic Data

Ranges, lengths and allowed values

Autessa Synthetic Data enforces the rules on every column. Required columns are never empty, numbers stay inside the table’s minimum and maximum, text respects length limits, and select columns only ever use the values you allow.

A core synthetic data capability, done properly
Start free
Column rules, checked on every rowSAMPLE
seatsInteger · 1 to 200240 → rejected, out of range
planSingle Select · Starter, Team, Business"team" → Team
tagsMulti Select · Mobile, API, SSO"Desktop" → rejected, not allowed
companyShort Text · requiredempty → rejected, required
bioLong Text · max 280312 chars → truncated to 280
activeBoolean"yes" → true

The problem

Data that breaks the rules breaks the test

A seats value of 240 when the plan allows 200, a status that is not in your enum, or an empty name all cause failures that have nothing to do with what you are testing.

What you get

  • Required columns are never null.
  • Integer and decimal columns honor the table’s minimum and maximum.
  • Short and long text honor minimum and maximum lengths, trimming over-length text.
  • Single select uses exactly one allowed value; multi select uses only allowed values.
  • Select values are matched regardless of case and stored in their canonical spelling.
  • Column descriptions add softer guidance, such as typical ranges or proportions.

How it works

How does ranges, lengths and allowed values work?

  1. Set the rules

    In a table, rules come from its schema. In the editor, mark columns required and add allowed values.

  2. Guide the mix

    Use the column description for proportions, such as "about one in ten is Urgent".

  3. Generate

    Every row is checked; rows that break a rule are repaired once or dropped.

Every option

Rules by column type

OptionWhat it does
RequiredAny type. The value must be present.
Integer / DecimalMinimum and maximum from the table schema; numeric strings are converted.
Short / Long textMinimum and maximum length; over-length text is trimmed.
Booleantrue or false; common words like "yes" are converted.
Single / Multi selectOnly allowed values, matched without regard to case.
DatesGenerated as short text holding a UTC ISO-8601 value.

Permissions

Who can do what?

WhoCan
People in your companyCreate datasets, see the company list of jobs, open any job and review, approve, append, cancel or discard it.

Connected

How ranges, lengths and allowed values connects to the rest of Autessa

FAQ

Questions about ranges, lengths and allowed values

Can I control the proportion of each value?

Describe it in the column description or the dataset description, such as "80% insured". The generator follows that guidance across every batch.

Where do number ranges come from?

From the table schema’s minimum and maximum settings. For dataset files, describe the range in the column description.

What about unique values?

Near-duplicate rows are removed across the job based on their main text columns, so every row stays distinct.

Try ranges, lengths and allowed values in Autessa Synthetic Data

Autessa Synthetic Data enforces required columns, number ranges, text lengths and allowed select values on every row it generates.

Start free

Describe it · review it · write it · or download JSONL and CSV

100% customizable, code and all

Make Autessa Synthetic Data fully your own.

Use it out of the box, then change anything. Ask Autobot, Autessa’s AI builder, for a new field, screen, report, workflow or agent and it builds it into your copy of the app. Or open the code and edit it yourself. Nothing is locked: the app, its data and its code are yours.

Start free and make it yours