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