Setting up a company rule

Company Rules are reusable, centrally managed data quality rules that can be applied across multiple tables, columns, and systems.
They should be used for organization-wide data quality checks that need to be enforced consistently across your entire data landscape.

By defining a rule once and applying it to many tables, you:

  • Ensure standardized logic across data domains

  • Save time by managing updates from a single place

  • Avoid inconsistencies and manual rule duplication

  • Improve governance and traceability of critical rules

How to set up a company rule:

Typical use cases include:

  • Global “Not empty” checks for critical IDs

  • Consistent format validation for customer emails

  • Company-wide PII detection rules

  • Value range checks for shared KPIs (e.g., Net Margin > 0

Short video how to set up Company Rules


Create a company rule from an existing rule

To start, you need to create or open a standard rule that should serve as the basis for your Company Rule. Not every rule type offers this option: it is not available for custom SQL, cross-connector SQL, custom Python, semantic, business partner, unique, outlier, column correlation, two-column, multi-column, and cross-table rules, or for segmented and ruleset-based rules.

🔄 Convert to a company rule:

  1. Go to the Rule Detail View

  2. Click the “...” menu in the top-right corner

  3. Select “Use as company rule”

A small “CR” label will mark rules that are defined at company level.


Apply a company rule to a table

You can apply Company Rules either from the table view or the rule repository.

From the Table:

  1. Open any table

  2. On the Rules tab, click the arrow next to “Add new rule”

  3. Choose “Select company rule”

  4. Select the column

  5. Pick the relevant Company Rule from the list (only Company Rules matching the column are offered) and optionally apply a filter

You can add filters and issue exceptions per table — Company Rules themselves cannot be modified there.


From the rule repository:

  1. Open the Rules repository

  2. Switch to the Company rules tab

  3. Click on a rule to open the Company Rule Detail Screen


Company rule Detail screen overview

This central screen gives you full control over a Company Rule and its applications.

(1) Rule settings

Adjust parameters such as thresholds, operators, or reference logic (if not locked).


(2) Overview of applied rules

See which tables, connectors, and columns the rule is currently applied to.
Click any item to jump directly to its rule detail screen.


(3) Add to new tables

Click “Add table” to apply the Company Rule to new tables:

  1. Select target tables from available connectors and click “Continue”

  2. Choose the ruleset and the column(s) per table

  3. Click “Add” to confirm


(4) Other adjustments (via “...” menu)

From the Company Rule detail screen, you can:

  • 📴 Deactivate all applied rules – Pauses checks without removing them

  • 🔁 Transform all rules to regular rules – Deletes the Company Rule and keeps all applied rules as individual rules

  • 🗑 Delete all rules – Removes all linked applications and the Company Rule itself


💡 Notes