We’re trying to a subset of our input tables for testing before implementation the full table(s) in Production.
We looked at using Data Slices, but we found that the ROWNUM feature of SQL met our purpose better:
select * from (select * from dbname.tblname) where ROWNUM <=10000
Our primary question is how do we link/connect the SQL View and/or the Data Slice to the DQ Rule. We believe that it occurs in the Monitoring Project.
I looked thorough the Ataccama online documentation, and the Community, but I can’t find the options to make these either of these connections.
Any ideas!
Thanks!
Tim
Best answer by anna.spakova
Hi @TimBrown74, if I understand your question correctly, you are creating an SQL Catalog Item using the SQL query above instead of data slices. The SQL CI behaves like a standard new catalog item so to link it to a DQ rule, you have two options:
via a Monitoring project as you mention (under Configuration tab, you will just add this new SQL catalog item and add a DQ rule to it - see the documentation below)
apply a DQ rule to the Catalog Item directly in the Catalog Item DQ rule tab (see details below)
Hi @TimBrown74, if I understand your question correctly, you are creating an SQL Catalog Item using the SQL query above instead of data slices. The SQL CI behaves like a standard new catalog item so to link it to a DQ rule, you have two options:
via a Monitoring project as you mention (under Configuration tab, you will just add this new SQL catalog item and add a DQ rule to it - see the documentation below)
apply a DQ rule to the Catalog Item directly in the Catalog Item DQ rule tab (see details below)
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
