The Rule Workbench is a SQL IDE rule builder that lets you create, edit, and preview SQL conditions to help verify that your data adheres to your organization's business requirements. The Rule Workbench has built-in auto-complete functionality, allowing you to generate more complex SQL such as rules with multi-part conditions. You can also update the settings of your rule, such as applying custom scoring weights, tagging DQ Dimensions and Categories, and other options to reflect the specifics of your data models.
This section shows how you can design and build a SQL rule on the Rule Workbench.
Known limitations
| Workbench Component | Limitation |
|---|---|
| Result Preview | Rule Result Preview is not yet available for Pushdown. This will be addressed in an upcoming release. |
| Result Preview | Native rules for Pullup jobs are currently not supported. |
| Result Preview | Stat rules, @runId, and secondary datasets are currently not supported for Pullup jobs. |
| Result Preview | Secondary datasets are currently not supported for Pushdown jobs. |