Project settings for data quality
For consistent setup of data quality rules, you can configure default settings that can be applied to any data quality rule in the project.
- Required permissions
- To configure data quality default settings, you must have the Admin role in the project. Any project collaborator can view the settings.
To access the default settings, go to the project's Manage page and select Tools > Data quality.
Output tables
For consistent setup of output tables for data quality rules, you can define a default configuration.
Output type and location
Define a new output table or select an existing table to write rule output to. For supported database types, see Supported data sources for curation and data quality.
When you define a new table, the table name can be a user-defined name, a parameter for dynamically creating a name, a combination of user-defined name and parameter, or a combination of parameters.
User-defined table names must follow this convention:
- The first character for the name must be an alphabetic character.
- The rest of the name can consist of alphabetic characters, numeric characters, or underscores.
- The name must not contain spaces.
For dynamic name creation, you can use these parameters:
#rule_id##rule_name##project_id#
Additionally, you can select these options:
-
Create table only when issues are found
This option avoids that empty tables are created in cases where a rule doesn't produce output records. However, if a table with that name already exists because it was generated for an earlier rule run, the table remains unchanged.
-
Import generated output table as project asset
To enable easy access to the rule output, add new rule output tables as data assets to the project. Instead of running a database query, you can view the data by opening the data asset from the Assets page in your project or from the rule's run history.
This option is enabled by default.
To make this configuration available for use in data quality rules, save it. The configured table is then shown as Current.
You can update this configuration at any time. These updates are then applied to new rules and new runs of existing rules that are configured to inherit project settings.
Learn more
Parent topic: Managing data quality