We need to setup the proper environment for the Hackathon. Thus, we need everyone on the team to have access to the Azure SQL and Synapse Environments. Also, any ancilliaries resources such as the Azure Storage Account and Key Vault.
For this challenge the following resources will need to be setup within your group environment.
- An Azure SQL database is created and configured with either the AdventureWorks or World-Wide-Importers database.
- A Synapse Environment including a SQL Dedicated Pool is created and configured.
- Key Vault is setup and configured and all users can see the secrets in the Key Vault.
- Establish a Linked Service in Azure Synapse Analytics that can connect to the Azure SQL Databases using Key Vault based secrets.
- Setup firewall rules so that only IP Ranges of the team members can access both the Azure SQL and Synapse Analytics envrionments.
- All resources are tagged appropriately.
-
Validate that all resources exist in one Resource Group and are tagged appropriately.
-
Validate that all team members have the proper access to all the assets, including the ability to perform SQL queries in both the Azure SQL and Dedicated Pool environments.
The following links may be useful to achieving the success crieria listed above.
Too comfortable? Eager to do more? Try these additional challenges!
- Create an automated shutdown script/pipeline that will pause the dedicated pool during the non-traditional business hours. Here are some samples: