Data Quality rule using two tables(datasources) columns throwing exception with
the second table not found error

Question

Hello,

We have 2 scenarios,

1.In one of our Data quality rule where the rule condition to be checked on the multiple columns of multiple tables of same schema

2.In another of our Data quality rule where the rule condition to be checked on the multiple columns of multiple tables of different schema

In both cases the second table is not identified while the rule is executed, though it is identified while profiling and we can see them in profile findings. But the rules throw exception with the second table not identified.

The rule is a freeform SQL and Sample query in the rule: SELECT a.* FROM TableA a LEFT JOIN Table2 b ON a.attr1 = b.attr2;

The rule throws Table2 b is not found error!

Hazeena Yoosaf · Answer

Addlib is added; mssql is the datasource, pull up connection, both tables are from different schema of the same connection

1	Grant Rollerson SUNCORP CORPORATE SERVICES PTY LTD
2	Tom Friesen Algonquin College
3	SB S Benson Plus3 IT
4	S stefan_busch
5	Brian Lloyd USA TODAY Co.
6	D daverichard

Data Quality rule using two tables(datasources) columns throwing exception with the second table not found error