Create an Azure SQL Datastore

Last updated: 10-07-2020

This template creates a SQL datastore in Azure Machine Learning workspace.

This Azure Resource Manager (ARM) template was created by a member of the community and not by Microsoft. Each ARM template is licensed to you under a licence agreement by its owner, not Microsoft. Microsoft is not responsible for ARM templates provided and licensed by community members and does not screen for security, compatibility or performance. Community ARM templates are not supported under any Microsoft support programme 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 deployment
New-AzResourceGroupDeployment -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/101-machine-learning-datastore-create-sql/azuredeploy.json
Install and configure Azure PowerShell

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 deployment
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
Install and Configure the Azure Cross-Platform Command-Line Interface