After you publish a dimension table to the production environment, Data Modeling automatically generates data quality rules based on the column properties you configured. This topic describes how to publish a dimension table, generate data quality rules from your data standards, and set up a quality monitor to enforce compliance on an ongoing basis.
How it works
The workflow has four stages:
-
Publish the table — Configure column properties (primary key, Not Null, Associated Standard Code) and publish to the production environment with auto rule generation enabled.
-
Generate quality rules — Review the suggested rules and create them in one click on the Data Standards page.
-
Create a quality monitor — Attach the rules to a monitor and define how and when checks run.
-
Maintain rules — Update rules by modifying the table model and republishing.
Prerequisites
Before you begin, ensure that you have:
-
Published the table to the production environment. For more information, see Materialize Logical Model.
Usage notes
Data Modeling automatically generates data quality rules for columns in the Column Management section that meet either of the following criteria:
-
The column is a Primary Key or is set to Not Null.
-
The column is configured with an Associated Standard Code.
Columns that do not meet these criteria are excluded from auto rule generation.
Publish a dimension table
-
Go to the Data Modeling page. Log in to the DataWorks console. In the top navigation bar, select a region. In the left-side navigation pane, choose Data Development and O\&M > Data Modeling. Select a workspace from the drop-down list and click Go to Data Modeling.
-
In the top navigation bar, click Dimensional Modeling. Find the table and double-click its name to open the details page.
-
In the Field Management section, set the Primary Key, Not Null, and Field Association properties for the columns to monitor.
-
Click the
icon to save the table, then click the 
icon to commit it as a new model version. -
Click the
icon to publish the table. In the Publish dialog box, set the following parameters: Leave all other parameters at their default values and click Publish.-
Effective Environment: Select Production and Development.
-
Automatic Rule Generation Based on Field Standard: Select Yes.
-
View and generate quality rules
Rules generated from data standards
Click 
Quality Rules in the top navigation bar to open the Data Quality Rule page. The page lists all rules that Data Modeling has suggested based on your column properties.
To create all suggested rules at once, go to the Data Standards page and click Generate Data Quality Rule.
Manually configure a rule
To create a rule outside of the auto-generation flow, click Configure Monitoring. This takes you to Rule Management > Data Quality > Rule Configuration > Configure by Table. Click Create Rule.
For more information, see Configure rules for a single table.
Create a quality monitor
A quality monitor defines which rules to run, when to run them, and how to handle issues. After generating your quality rules, set up a monitor to run checks automatically.
From the rule list, click a rule name in the ID/rule name column. Go to Rule Management > Rule Configuration > Configure by Table. Click the Monitor tab, then click Create Monitor. Configure the following parameters:
| Module | Parameter | Description |
|---|---|---|
| Basic configurations | Monitor Name | Enter a name for the quality monitor. |
| Data range | — | Depends on the table type. For partitioned tables, the data range defaults to partitions. Select a partition range such as ds=$[yyyymmdd-1]. |
| Running settings | Trigger Method | Choose how the monitor runs: Triggered by Node Scheduling in Production Environment (recommended for ongoing compliance) or Triggered Manually. |
| Running settings | Associated Scheduling Node (for production schedule) | Click Add Node and select the target workspace and node. The periodic scheduling task in the DataWorks Operation Center automatically triggers the quality rules in this monitor when the task completes. |
| Running settings | Select Execution Resources | Specifies the computing resources for running quality checks. Defaults to the data source of the monitored table in the current workspace. If you select a different data source, make sure it can access the table. |
| Handling policies | Issue Policy | You can keep the default setting. |
| Select quality rules | — | Click Batch Select. In the panel, select the rules to include by ID/rule name, Template, or Association Range. |
Enabling and running quality rules incurs charges. For more information, see Billing of data quality instances.
After you create the monitor, go to Quality O\&M > Monitor to view the Latest Run Record and update the Alert Subscription method and recipients.
Modify or delete rules from data standards
Rules generated from data standards are tied to your table model. To update them, modify the model and republish:
-
Change a column property — for example, change a Column Name, remove a Not Null constraint, or update the Associated Standard Code.
-
Add or remove columns.
-
Delete the table model entirely.
After modifying columns in the table model, click the 
icon to republish the table and apply your changes.