Skip to content

Verification filters

The Verification Filters tab allows you to create universal filters that can be applied to the entire fact table for data validation and verification.

Purpose of filters

Filters define data selection conditions (for example, Year = 2023 AND Region = 'Central'). They are used for:

  • Testing and verifying the correctness of data in data marts
  • Limiting data during previews
  • Creating verification scenarios

Creating a filter

Click "Add filter" and fill in the parameters:

Parameter Requirements
Filter Name Must be unique within this fact table. Case-sensitive. 1–64 characters. Allowed: letters, digits, space, ., -, _.
Filter Description Optional. Up to 255 characters.
Filter Conditions Required. At least one condition is required.

Managing the filter list

For each created filter, the following is displayed:

  • Name
  • Description
  • Conditions

Available actions:

  • Edit: Modify the parameters of an existing filter
  • Make a copy: Quickly create a duplicate of the filter
  • Delete: Delete the filter after confirmation

Important notes

  • Scope: Filters are saved for a specific fact table within its project version. Filters from different tables are independent
  • Copying: When a project version is copied or an entire project is cloned, filters are copied along with their fact table
  • Validation: If an error occurs in the conditions of a saved filter (for example, a used field is deleted), it is marked as invalid but not deleted