After my ETL process is done, I would like to run a few queries and validate its results, throwing an error if something is not as expected. For example, running a
SELECT COUNT(*) FROM Product WHERE CalculatedPrice IS NULL
and if the result is different than zero, throws an error.
Thanks in advance.