Skip to main content

Managing data and decision tables

The Tables panel contains three table types.

Table typePurposeTypical use
Lookup tableSmall reference mappingsTranslate codes or enrich records
Data tableMutable operational recordsStore and update workflow data
Decision tableGoverned business rulesEvaluate inputs and return rule-based outputs

Create a data table

  1. Open Tables, then select Data Tables.
  2. Create a blank table or import a CSV file.
  3. Define column names, data types, and key behavior.
  4. Save the table and add or import rows.
  5. 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

  1. Open Tables, then select Decision Tables.
  2. Create a table or import an existing definition.
  3. Define input columns, output columns, and ordered rules.
  4. Use Evaluate to test representative and boundary inputs.
  5. Save reusable cases in a Test Suite and rerun them after rule changes.
  6. Submit the table for review when approval is configured.
  7. 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.