The Azure Quickstart templates are currently available in English
This template creates a V2 data factory that copies data from a folder in an Azure Blob Storage to a table in an Azure SQL database.
此 Azure Resource Manager (ARM) 模板由社区的某个成员(而不是由 Microsoft)创建。每个 ARM 模板都根据其所有者(不是 Microsoft)的许可协议向你授予许可。Microsoft 不对由社区成员提供并授予许可的 ARM 模板负责,并且不针对安全性、兼容性和性能进行筛选。社区 ARM 模板不由任何 Microsoft 支持计划或服务提供支持,按“原样”提供,没有任何种类的担保。
参数
参数名 | 说明 |
---|---|
dataFactoryName | Name of the data factory. Must be globally unique. |
dataFactoryLocation | Location of the data factory. |
AzureStorage_connectionString | Connection string for the Azure Storage account. |
blobContainer | Name of the blob container in the Azure Storage account. |
inputBlobFolder | The folder in the blob container that has the input file. |
inputBlobName | Name of the input file/blob. |
AzureSqlDatabase_connectionString | Connnection string for the Azure SQL database. |
sqlTableName | Name of the target table in the Azure SQL database. |
使用模板
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/101-data-factory-v2-blob-to-sql-copy/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/101-data-factory-v2-blob-to-sql-copy/azuredeploy.json