Validation Rules
Reseed validates uploads instantly, catching issues before data is saved to your storage database. Learn how to configure validation rules to enforce data quality.
Overview
Reseed validates uploads instantly, catching issues before data is saved to your storage database:
- Missing or unexpected columns — Schema must match the Seed definition
- Data type mismatches — Numbers, dates, and booleans are type-checked
- Constraint failures — Required fields, ranges, patterns, allowed values
- Naming pattern violations — Enforce file naming conventions
Invalid files are rejected with detailed error reports showing exactly which rows and columns have issues.
Reseed validates your file before uploading it to the storage database. This ensures data quality and catches errors early. If validation fails, Reseed shows you exactly what's wrong—which rows and columns have issues—so you can fix your data and try again.
Available Rule Types
Reseed supports the following validation rule types:
| Rule Type | Description | Example |
|---|---|---|
| Data Type | Enforce column data type | Number, Date, Text, Boolean |
| Required | Column must have a value | ID column cannot be empty |
| Min/Max | Numeric range constraints | Amount must be > 0 |
| Length | Text length constraints | Code must be exactly 5 characters |
| Pattern | Regular expression matching | Must start with "INV-" |
| Allowed Values | Must be one of a set of values | Status in (Active, Inactive) |
| Date Format | Enforce date/time format | YYYY-MM-DD |
Configuring Rules
Validation rules are configured when creating or editing a Seed. You can add rules to individual columns in the Seed's column configuration:
- Navigate to the Seeds page and select a Seed (or create a new one).
- Toggle on Seed Admin Mode if you're editing an existing Seed.
- Open the column configuration tab.
- For each column, configure:
- Data type (Text, Number, Date, Boolean)
- Required/optional status
- Validation rules (min/max, length, pattern, allowed values, date format)
- Save your changes.
When configuring validation rules, Reseed provides helper text and expandable sections with examples you can copy and paste. This makes it easy to set up common validation patterns.
The best way to learn validation rules is to explore the sample Seeds that come with Reseed. Clone sample_budget_requests or sample_row_level_security_map and examine their validation rules to see examples in action.