Managing data and decision tables
The Tables panel contains three table types.
| Table type | Purpose | Typical use |
|---|---|---|
| Lookup table | Small reference mappings | Translate codes or enrich records |
| Data table | Mutable operational records | Store and update workflow data |
| Decision table | Governed business rules | Evaluate inputs and return rule-based outputs |
Create a data table
- Open Tables, then select Data Tables.
- Create a blank table or import a CSV file.
- Define column names, data types, and key behavior.
- Save the table and add or import rows.
- Select the table from a compatible activity field or drag it into the configuration.
Use Data Tables activities for runtime CRUD operations. Restrict truncate and broad update operations to workflows with an explicit recovery plan.
Create and publish a decision table
- Open Tables, then select Decision Tables.
- Create a table or import an existing definition.
- Define input columns, output columns, and ordered rules.
- Use Evaluate to test representative and boundary inputs.
- Save reusable cases in a Test Suite and rerun them after rule changes.
- Submit the table for review when approval is configured.
- Approve or reject the table with a useful comment, then publish the approved version.
Review the changelog before publishing. The Metrics panel reports total evaluations, average and percentile latency, no-match rate, and rule hit rates when ClickHouse-backed telemetry is available.
Change controls
- Define deterministic rule ordering and an intentional no-match result.
- Test overlapping ranges, null values, boundaries, and unexpected enum values.
- Check references before renaming or deleting a table.
- Export before high-risk structural changes.
- Assign approvers who own the underlying business policy.