The Azure Quickstart templates are currently available in English
This template creates a SQL datastore in Azure Machine Learning workspace.
此 Azure Resource Manager (ARM) 範本是由社群成員 (而非 Microsoft) 建立。每個 ARM 範本都是由其擁有者 (而非 Microsoft) 依據授權合約授權給您。Microsoft 並不負責社群成員所提供和授權的 ARM 範本，而不會為了安全性、相容性或效能進行篩選。社群 ARM 範本並未依據任何 Microsoft 支援方案或服務提供支援，而且會在沒有任何擔保的情況下依現況提供。
參數
| 參數名稱 | 說明 |
|---|---|
| workspaceName | Specifies the name of the Azure Machine Learning workspace which will hold this datastore target. |
| datastoreName | The name of the datastore, case insensitive, can only contain alphanumeric characters and underscore |
| sqlServerName | The SQL server name. |
| authenticationType | Authentication type |
| userNameOrClientId | The username of the database user or service principal/application ID. |
| passwordOrClientSecret | The password of the database user or service principal's secret. |
| tenantId | This is ignored if SQL Authentication is selected. |
| databaseName | The database name. |
| authorityUrl | Optional : Authority url used to authenticate the user. Defaults to https://login.microsoftonline.com |
| resourceUrl | Optional : Determines what operations will be performed on the database. Defaults to https://database.windows.net/ |
| endpoint | Optional : The endpoint of the sql server. Defaults to database.windows.net. |
| skipValidation | Optional : If set to true, the call will skip datastore validation. Defaults to false |
| location | The location of the Azure Machine Learning Workspace. |
使用範本
PowerShell
New-AzResourceGroup -Name <resource-group-name> -Location <resource-group-location> #use this command when you need to create a new resource group for your deployment安裝和設定 Azure PowerShell
New-AzResourceGroupDeployment -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/quickstarts/microsoft.machinelearningservices/machine-learning-datastore-create-sql/azuredeploy.json
命令列
az group create --name <resource-group-name> --location <resource-group-location> #use this command when you need to create a new resource group for your deployment安裝和設定 Azure 跨平台命令列介面
az group deployment create --resource-group <my-resource-group> --template-uri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/quickstarts/microsoft.machinelearningservices/machine-learning-datastore-create-sql/azuredeploy.json