tsukashusan/bicep-synapse

Bicep sample (Azure Synapse Analytics workspace)

Preparation

1. Install az cli
   https://docs.microsoft.com/ja-jp/cli/azure/install-azure-cli

2. bicep install https://github.com/Azure/bicep/blob/main/docs/installing.md#windows-installer

3. Install Azure Synapse Powershell Module
   Install-Module -Name Az.Synapse

4. bicep install (for Powershell)
   Setup your Bicep development environment

5. Edit parameter File

• azuredeploy.parameters.dev.json
  
  • require
    xxx.xxx.xxx.xxx -> Your IP Address.
    xxx(sqlAdministratorLoginPassword)(At least 12 characters (uppercase, lowercase, and numbers))
    xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx -> Your ObjectId of Azure AD

{
    "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentParameters.json#",
    "contentVersion": "1.0.0.0",
    "parameters": {
        "ipaddress": {
            "value": "xxx.xxx.xxx.xxx"
        },
        "sqlAdministratorLogin": {
          "value" : "adminuser"
        },
        "sqlAdministratorLoginPassword": {
          "value": "xxx"
        },
        "storageAccountType":{
          "value": "Standard_LRS"
        },
        "sqlpoolName":{
          "value": "販売管理"
        },
        "bigDataPoolName": {
          "value": "etlexecuter"
        },
        "nodeSize":{
          "value": "Small"
        },
        "sparkPoolMinNodeCount":{
            "value": 3
        },
        "sparkPoolMaxNodeCount":{
          "value": 3
        },
        "defaultDataLakeStorageFilesystemName":{
          "value": "dl2"
        },
        "collation":{
          "value": "Japanese_CS_AS_KS_WS"
        },
        "userObjectId":{
          "value": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
        }
    }
}

(Option)

If you use powershell(or pwsh)

1. Install Module Az or Update Module Az (Az Version >= 5.8.0)

 Install-Module Az

or

Update-Module Az

Usage

STEP 1

1. Execute PowerShell Prompt
2. Set Parameter(x)

Write-Host "hello world"
set-variable -name TENANT_ID "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx" -option constant
set-variable -name SUBSCRIPTOIN_GUID "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx" -option constant
set-variable -name BICEP_FILE "main.bicep" -option constant

$parameterFile = "azuredeploy.parameters.dev.json"
$resourceGroupName = "xxxxx"
$location = "xxxxx"

2. Go to STEP2 (Azure CLI or PowerShell)

STEP 2 (PowerShell)

1. Azure Login

Connect-AzAccount -Tenant ${TENANT_ID} -Subscription ${SUBSCRIPTOIN_GUID}

2. Create Resource Group

New-AzResourceGroup -Name ${resourceGroupName} -Location ${location} -Verbose

3. Deployment Create

New-AzResourceGroupDeployment `
  -Name devenvironment `
  -ResourceGroupName ${resourceGroupName} `
  -TemplateFile ${BICEP_FILE} `
  -TemplateParameterFile ${parameterFile} `
  -Verbose

STEP 2 (Azure CLI)

1. Azure Login

az login -t ${TENANT_ID} --verbose

2. Set Subscription

az account set --subscription ${SUBSCRIPTOIN_GUID} --verbose

3. Create Resource Group

az group create --name ${resourceGroupName} --location ${location} --verbose

4. Deployment Create

az deployment group create --resource-group ${resourceGroupName} --template-file ${BICEP_FILE} --parameters ${parameterFile} --verbose