Adding Synapse Proof-of-Concept

Adding an automated Proof-of-Concept environment to deploy Azure Synapse.

This template deploys the following:

An Azure Synapse Workspace
- (OPTIONAL) Allows All connections in by default (Firewall IP Addresses)
- Allows Azure Services to access the workspace by default
- Managed Virtual Network is Enabled
An Azure Synapse SQL Pool
(OPTIONAL) Apache Spark Pool
- Auto-paused set to 15 minutes of idling
Azure Data Lake Storage Gen2 account
- Azure Synapse Workspace identity given Storage Blob Data Contributor to the Storage Account
- User Object ID specified in parameters during deploying given Storage Blob Data Contributor to the Storage Account
- A new File System inside the Storage Account to be used by Azure Synapse
A Logic App to Pause the SQL Pool at defined schedule
- The Logic App will check for Active Queries. If there are active queries, it will wait 5 minutes and check again until there are none before pausing
A Logic App to Resume the SQL Pool at defined schedule
Both Logic App managed identities are given Contributor rights to the Resource Group
Grants the Workspace identity CONTROL to all SQL pools and SQL on-demand pool

Azure-Samples / Synapse