Configure global rules settings

You can control global rule settings, such as rule limits, SQL AI, and primary column requirements.

Prerequisites

Steps

  1. On the main toolbar, click Products icon → Settings.
  2. Click the Data Quality tab.
  3. Click Rules.
  4. Update the limits and switches, as needed.
    5. Limit Description
    Rule run time limit

    Allows you to set the maximum time a data quality job can attempt to execute a rule before the rule activity is automatically canceled to save resources.

    The default is 30 minutes. You can adjust it by entering a value between 1 and 90.
    Rule preview limit

    Allows you to limit the number of rows shown when previewing rules in the rule workbench. This can help limit resource usage and improve performance.

    The default is 100 rows. You can adjust it by entering a value between 1 and 500.
    Break records preview limit

    Allows you to limit the number of rows shown in the rule details drawer of the on the Job Details page set the maximum number of rule breaks to display in the rule drawer.

    The default is 30 rows. You can adjust it by entering a value between 1 and 500.
    SQL AI

    Activates the SQL AI chat assistant in the rule workbench to help generate SQL queries.

    SQL AI is enabled by default.
    SQL exception details

    When enabled, if a SQL exception is detected after validating or previewing the rule results, the full error message from the rule is shown beneath the SQL editor on the rule workbench. Additionally, if a SQL exception is detected when the rule runs, the Query tab in the rule details drawer on the Job Details page shows the full error message.

    When disabled, if a SQL exception is detected after validating or previewing the rule results, a generic "SQL is invalid" error message is shown on the rule workbench.

    For security purposes, SQL exception details is disabled by default.
    Require primary column

    When enabled, the primary column option on the rule workbench must be set to a column. This setting requires an integration with Data Catalog.

    Require primary column is disabled by default.
    Primary column mapping

    Maps a rule to the Column asset that directly relates to the column selected as the primary column of the rule. This ensures that rule results apply only to the data quality score for the primary column only, not to every column in the rule query.

    Primary column mapping is enabled by default.

    Important When primary column mapping is enabled, you must also enable require primary column.
  5. Click Save changes.