Skip to content

Instantly share code, notes, and snippets.

@SqlWaldorf
Last active November 15, 2024 08:31
Show Gist options
  • Save SqlWaldorf/fb121052076fb216c50f20d83517571d to your computer and use it in GitHub Desktop.
Save SqlWaldorf/fb121052076fb216c50f20d83517571d to your computer and use it in GitHub Desktop.
ARM template for u2u Purview class
{
"$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