In a previous post, I gave an overview to regression tests. In this post, I will give a practical example of developing and performing regression tests with the Pester framework for PowerShell. The code for performing regression tests is written in PowerShell using the Pester Framework. The tests are run through Azure DevOps pipelines and are designed to test regression scenarios. The PowerShell scripts, which contain the mechanism for executing tests, rely upon receiving the actual test definitions from a metadata database. The structure of the metadata database will be exactly the same as laid out in the Integration Test post.
Regression Tests
The regression tests will need to be designed so that existing functionality isn’t regressed by any changes made to the code. In an analytics system, the functionality is typically going to be aligned to the target schema that’s used for reporting and analysis. If we change the cleaning transformation logic in the source tables which make up our customer dimension, we’ll want to ensure that the customer dimension itself doesn’t change expected outcomes, for example row counts or a specific value.
For this example, we’ll be putting in some data into the data lake, run it through the various layers until it ends up in the CURATED layer. Because the majority of the processing is orchestrated using Azure Data Factory V2 (ADF), we only really need to ensure that the pipeline(s) run successfully and some valid data appears in all the layers of the lake, as well as logged into the metadata database.
Because we’re deploying some data, we’ve got elements of setup and teardown in the script. Setup and teardown in the metadata database, so that ADF knows what to process. Setup and teardown in the data lake, so that there is data to process.
This should give you enough to start using Pester for testing your own Azure data platform implementations.
Meet the Team – Zach Stagers, Senior Consultant
Up next in our series of Meet the Team blogs is Zach Stagers, Senior Consultant.
Nov
A Cost Comparison between PaaS and IaaS Cloud Architectures
Introduction This aim of this blog is to do a cost comparison between two cloud
Nov
Providing Careers at Adatis
At Adatis, we believe in developing and training our employees which aligns with 2 of
Nov
Meet the Team – Donna Bavin, People Operations Lead
We couldn’t achieve all the great work we do without our amazing team, so in
Nov
Deep Dive into the Common Data Model Video Presentation
At SQLBits last month some of our team gave fantastic sessions on a variety of
Oct
The Adatis Values – No is OK and Listen & Challenge
Our nine company values are super important to us and are at the heart of
Oct
Optical Character Recognition (OCR) using Tesseract and Databricks
The topic of Optical Character Recognition (OCR) is not an unexplored field to the Adatis
Oct
An experiment with Azure Custom Vision
An experiment with Azure Custom Vision Azure Cognitive Services is a comprehensive family of APIs,
Oct