Minimal test framework to test Azure Synapse pipelines with MSTest (CI included). The framework is build with Synapse in mind, but with a little modification it would also be able to support ADF.
To get started quick, copy the entire folder structure and use the example in ExampleTests.cs to get started.
Run dotnet test or use Visual Studio's Test Explorer.
The Azure.Identity library is being used for authentication using Managed Identities. This will use the current users identity to connect. Use Native Visual studio integration or otherwise the az login command to authenticate, more info here.
The tests can run in CI using GitHub Actions. You can find the GitHub Workflow YAML here: .github/workflows/ci.yml
The authentication used here to make GitHub Actions connect to Azure is using federated credentials: Configure App Service with Federated Credentials. You can also use a service principal secret: Configure App Service with Service Principal Secret
The GitHub Action will publish a test report: 
The tests can also run in CI with Azure DevOps. You can find the Azure DevOps YAML here: AzDevOps/ci.yml
Make sure you replace [ServiceConnectionHere] with your service connection name. The tests will run on the Service Connection Service Principal's identity.
