Add a Check

  1. Navigate to the Alation Data Quality application or catalog table page and click Add Monitor.

  2. In the Scan Assets section, choose the data source or BI report for scanning. For more information, see Add a Monitor.

  3. In the Select Checks section:

    1. To apply checks on the entire table, click Add Table Check.

    2. Expand each table attribute and click Add Check.

  1. Choose a category type to apply checks:

    1. To add numerical checks, follow steps in Add Accuracy Checks.

    2. To add uniqueness checks, follow steps in Add Uniqueness Checks.

    3. To add completeness checks, follow steps in Add Completeness Checks.

    4. To add validity checks, follow steps in Add Validity Checks.

    5. To add custom checks, follow steps in Add Custom Checks.

  2. (Optional) To filter rows with a specific value to compare against a column, click Add Filters to select a column and add a comparative operator and a corresponding value. This helps find rows that match the filter, then executes the check on those rows. For example, you may wish to use a filter to support a use case in which Column A must be filled in for all rows that have value B in column C. For more information, see Understanding Row-Level Filtering.

    1. Select from available table columns.

    2. Select from available comparison operators:

      • Basic: =, !=, <, >, <=, >=.

      • List: IN, NOT IN.

      • Pattern: LIKE, NOT LIKE.

        Note

        The pattern-based filters LIKE and NOT LIKE are not supported in this release.

      • Null: IS NULL, IS NOT NULL.

    3. Enter filter values or value lists.

    4. Use AND / OR operators for multiple conditions.

    5. Test and validate filter logic before applying to checks.

  3. Click Save.