In reality, I did a post a while ago about using Azure Test Plans with GitHub deployments. Plus, I covered it briefly in another post that showed how to use Azure Test Plans for Data Platform deployments.
However, somebody reached out to me after SQLBits and told me they could not find much information about using Azure Test Plans with GitHub deployments online. With this in mind I thought I would provide some more tips.
By the end of this post, you will know some more tips about how to use Azure Test Plans with GitHub deployments. Plus, where you can find a GitHub repository that you can use as a template for CI/CD deployments for Azure Synapse Analytics serverless SQL Pools.
Setup a GitHub connection
To make the most out of using Azure Test Plans for GitHub deployments I strongly recommend that you setup a connection to your GitHub repository in Azure DevOps. You set this up in the Boards section within Project settings in Azure DevOps.
After doing this you can then add relevant links to your work items in Azure Boards. Including any bugs that you raise in Azure Test Plans.
For example, say I connect my Azure DevOps project to a GitHub repository that deployed to an Azure Synapse serverless SQL Pool. Like the GitHub-SynapseServerlessSQLPool that I have made public.
From there I can create a test plan in Azure Test Plans to check that the workflow I have created for use with GitHub Actions works as expected like in the below example.
If there was an issue, I could mark the workflow as failed and then click on Create issue since this Azure DevOps project is based on an Agile process. If it was based on a Scrum process it would tell me to create a bug instead.
In the ‘New issue’ window that appears I can than click on Add link to add a link to a commit that was done in my GitHub repository.
Doing this allows you to easily keep track of which GitHub commit caused the test plan to fail.
Screenshots from GitHub
One thing that can help when testing deployments from GitHub is screenshots of completed workflows. Like I one shown above. Doing so increases the change that the completed workflow is checked properly.
Select correct test suite in Azure Test Plans
When setting up your test plans for GitHub deployments make sure you setup the correct test suite. There are three types of test suites that you can use. I cover them in detail in a post I wrote called ‘Azure Test Plans jargon for Data Platform professionals‘.
Final words about more tips if using Azure Test Plans with GitHub
I hope these additional tips about using Azure Test Plans with GitHub deployments helps some of you. Especially those of you who have found it hard to find more information about this online.
Of course, if you have any comments or queries about this post feel free to reach out to me.