I am managing testing for a consulting firm, we have a dedicated testing team that performs ETL testing using Microsoft Azure technologies.
We are planning to automate regression testing and wondering if anyone in the club has done something similar before or can give some thoughts/direction??
What we have done:
So far we have managed to automate the regression testing by creating store proc but again it’s time-consuming and bit manually and works on specific cases.
What I am looking for:
I am looking for a solution by which if we provide table schema details, the process should be able to write SQL queries and performs the below checks:
- Record count comparison between source and destination table
- Bit of data reconciliation check between source and destination table