Last active
November 15, 2024 08:31
-
-
Save SqlWaldorf/fb121052076fb216c50f20d83517571d to your computer and use it in GitHub Desktop.
ARM template for u2u Purview class
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#", | |
| "contentVersion": "1.0.0.0", | |
| "metadata": { | |
| "_generator": { | |
| "name": "bicep", | |
| "version": "0.31.92.45157", | |
| "templateHash": "6365270700785926130" | |
| } | |
| }, | |
| "parameters": { | |
| "containerName": { | |
| "type": "string", | |
| "defaultValue": "datacontainer" | |
| }, | |
| "dbName": { | |
| "type": "string", | |
| "defaultValue": "purviewsampledb" | |
| }, | |
| "sku": { | |
| "type": "string", | |
| "defaultValue": "Standard_LRS" | |
| }, | |
| "administratorLogin": { | |
| "type": "string", | |
| "defaultValue": "sqladmin" | |
| }, | |
| "administratorLoginPassword": { | |
| "type": "securestring" | |
| } | |
| }, | |
| "resources": [ | |
| { | |
| "type": "Microsoft.Storage/storageAccounts", | |
| "apiVersion": "2023-05-01", | |
| "name": "[format('mystore{0}', uniqueString(resourceGroup().id))]", | |
| "location": "[resourceGroup().location]", | |
| "sku": { | |
| "name": "[parameters('sku')]" | |
| }, | |
| "kind": "StorageV2", | |
| "properties": { | |
| "accessTier": "Hot", | |
| "allowBlobPublicAccess": false, | |
| "minimumTlsVersion": "TLS1_2", | |
| "supportsHttpsTrafficOnly": true | |
| } | |
| }, | |
| { | |
| "type": "Microsoft.Storage/storageAccounts/blobServices", | |
| "apiVersion": "2023-05-01", | |
| "name": "[format('{0}/{1}', format('mystore{0}', uniqueString(resourceGroup().id)), 'default')]", | |
| "dependsOn": [ | |
| "[resourceId('Microsoft.Storage/storageAccounts', format('mystore{0}', uniqueString(resourceGroup().id)))]" | |
| ] | |
| }, | |
| { | |
| "type": "Microsoft.Storage/storageAccounts/blobServices/containers", | |
| "apiVersion": "2023-05-01", | |
| "name": "[format('{0}/{1}/{2}', format('mystore{0}', uniqueString(resourceGroup().id)), 'default', parameters('containerName'))]", | |
| "properties": { | |
| "publicAccess": "None" | |
| }, | |
| "dependsOn": [ | |
| "[resourceId('Microsoft.Storage/storageAccounts/blobServices', format('mystore{0}', uniqueString(resourceGroup().id)), 'default')]" | |
| ] | |
| }, | |
| { | |
| "type": "Microsoft.Sql/servers", | |
| "apiVersion": "2023-08-01-preview", | |
| "name": "[format('sqlsrvr{0}', uniqueString(resourceGroup().id))]", | |
| "location": "[resourceGroup().location]", | |
| "properties": { | |
| "administratorLogin": "[parameters('administratorLogin')]", | |
| "administratorLoginPassword": "[parameters('administratorLoginPassword')]", | |
| "version": "12.0" | |
| } | |
| }, | |
| { | |
| "type": "Microsoft.Sql/servers/firewallRules", | |
| "apiVersion": "2023-08-01-preview", | |
| "name": "[format('{0}/{1}', format('sqlsrvr{0}', uniqueString(resourceGroup().id)), 'AllowAllIps')]", | |
| "properties": { | |
| "startIpAddress": "0.0.0.0", | |
| "endIpAddress": "255.255.255.255" | |
| }, | |
| "dependsOn": [ | |
| "[resourceId('Microsoft.Sql/servers', format('sqlsrvr{0}', uniqueString(resourceGroup().id)))]" | |
| ] | |
| }, | |
| { | |
| "type": "Microsoft.Sql/servers/databases", | |
| "apiVersion": "2023-08-01-preview", | |
| "name": "[format('{0}/{1}', format('sqlsrvr{0}', uniqueString(resourceGroup().id)), parameters('dbName'))]", | |
| "location": "[resourceGroup().location]", | |
| "sku": { | |
| "name": "Basic", | |
| "tier": "Basic" | |
| }, | |
| "dependsOn": [ | |
| "[resourceId('Microsoft.Sql/servers', format('sqlsrvr{0}', uniqueString(resourceGroup().id)))]" | |
| ] | |
| }, | |
| { | |
| "type": "Microsoft.DataFactory/factories", | |
| "apiVersion": "2018-06-01", | |
| "name": "[format('copyCustomersPL{0}', uniqueString(resourceGroup().id))]", | |
| "location": "[resourceGroup().location]" | |
| }, | |
| { | |
| "type": "Microsoft.KeyVault/vaults", | |
| "apiVersion": "2024-04-01-preview", | |
| "name": "[format('KeyVault{0}', uniqueString(resourceGroup().id))]", | |
| "location": "[resourceGroup().location]", | |
| "properties": { | |
| "sku": { | |
| "name": "standard", | |
| "family": "A" | |
| }, | |
| "tenantId": "[subscription().tenantId]", | |
| "accessPolicies": [] | |
| } | |
| } | |
| ], | |
| "outputs": { | |
| "location": { | |
| "type": "string", | |
| "value": "[resourceGroup().location]" | |
| }, | |
| "storageAccountName": { | |
| "type": "string", | |
| "value": "[format('mystore{0}', uniqueString(resourceGroup().id))]" | |
| }, | |
| "containerName": { | |
| "type": "string", | |
| "value": "[parameters('containerName')]" | |
| }, | |
| "serverFQDN": { | |
| "type": "string", | |
| "value": "[reference(resourceId('Microsoft.Sql/servers', format('sqlsrvr{0}', uniqueString(resourceGroup().id))), '2023-08-01-preview').fullyQualifiedDomainName]" | |
| }, | |
| "db": { | |
| "type": "string", | |
| "value": "[parameters('dbName')]" | |
| } | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment