AnsweredAssumed Answered

How do I validate some results from queries and throw error when applicable?

Question asked by Vitor Durante on Apr 25, 2018
Latest reply on Apr 30, 2018 by Ana Gonzalez

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.

Outcomes