This template creates a SQL datastore in Azure Machine Learning workspace.
This Azure Resource Manager template was created by a member of the community and not by Microsoft. Each Resource Manager template is licensed to you under a license agreement by its owner, not Microsoft. Microsoft is not responsible for Resource Manager templates provided and licensed by community members and does not screen for security, compatibility, or performance. Community Resource Manager templates are not supported under any Microsoft support program or service, and are made available AS IS without warranty of any kind.
Parameters
| Parameter Name | Description |
|---|---|
| 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. |
Use the template
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 deploymentInstall and configure Azure PowerShell
New-AzResourceGroupDeployment -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/101-machine-learning-datastore-create-sql/azuredeploy.json
Command line
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 deploymentInstall and Configure the Azure Cross-Platform Command-Line Interface
az group deployment create --resource-group <my-resource-group> --template-uri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/101-machine-learning-datastore-create-sql/azuredeploy.json