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 | Stat rules, @runId, and secondary datasets are currently not supported for Pullup jobs. |
| Result Preview | Secondary datasets are currently not supported for Pushdown jobs. |
| Pushdown Rule Queries |
In the context of pushdown rule queries, there is a limitation regarding LinkIDs and rules. The use of Insert source break records and LinkIDs is not supported when a rule involves join queries with labels, and the selected LinkID of one table exists in both tables with the same column name and case. This limitation occurs because LinkIDs are assigned at the source level, while query labeling happens at the rule level. As a result, running the final query may cause an ambiguous column error. To address this limitation, Collibra recommends utilizing subqueries. By moving join queries into a subquery within the rule, you can mitigate the issues related to LinkIDs. Another option is to move the join queries to the source query instead of in the rule. |