murggu/azure-synapse-terraform

An example repo for provisioning a complete Azure Synapse Analytics environment through Terraform

Azure Synapse Terraform Example

This repo shows an example for rolling out a complete Azure Synapse Analytics enterprise environment via Terraform.

This includes rollout of the following resources:

• Azure Synapse Analytics Workspace with Private Endpoints
• Azure Synapse Analytics Private Link Hub with Private Endpoint
• Azure Storage Account with Private Endpoints for blob and dfs
• Azure Key Vault with Private Endpoint
• Virtual Network
• Jumphost (Windows) with Bastion for easy access to the VNet

Instructions

Make sure you have the Azure CLI and Terraform installed.

1. Copy terraform.tfvars.example to terraform.tfvars
2. Update terraform.tfvars with your desired values
3. Run Terraform

   $ terraform init
   $ terraform plan
   $ terraform apply

Notes

See notes below for additional info:

• A public IP is added to Azure Storage Account and Azure Synapse Analytics firewall rules to enable the deployment. That rule could be removed once the deployment is finished, only limiting jumphost access.
• Change enable_syn_sqlpool and enable_syn_sparkpool values if you wanna deploy any of those pools.
• The deployment was tested on wsl (ubuntu).

azure-synapse-terraform's Issues

Local exec provisioner --

Hi Aitor,

I am getting below error while deploying synapse environment using this repo
error: Please run 'az login' to setup account.

I am using microsoft hosted agent(windows) to run this setup

Can you please help

Guidance needed to have Azure synapse workspace on Hub and Spoke model

Hi Aitor,

Thanks for this wonderful repo to start with. I need some guidance like, we have architecture in our environment, we have one hub and multiple spokes which all peer back to each other, each spoke will have multiple subscriptions (ie. dev,test,prod). so idea to have synapse workspace configured on each on each spoke. some sort of Azure private dns resolver.

can you please help me how to do this from terraform, any idea ?