Unit Testing on Data Warehouse · Learn Microsoft Fabric

Unit Testing on Data Warehouse

Is anyone familiar with running automated unit tests inside of a data warehouse?

At the moment I have some SQL scripts in a data warehouse to update and insert records in response to changes in the source system. At the moment I am making changes in a test data set, running the scripts and then manually checking to see if they expected outputs have been produced.

This is time consuming, error prone and I don't want to manually test each time I update the scripts so was wondering if there is a testing framework that I could use to create unit tests that I can run each time I update the scripts.

Thanks!

7 comments