Create a V2 data factory (SQL)

Azure Public Test Date Azure Public Test Result

Azure US Gov Last Test Date Azure US Gov Last Test Result

Best Practice Check Cred Scan Check This template creates a data factory of version 2 with a pipeline that copies data from a folder in an Azure Blob Storage to a table in an Azure SQL database.

Here are a few important points about the template:

Deploy To Azure Deploy To Azure US Gov Visualize

When you deploy this Azure Resource Manager template, a data factory of version 2 is created with the following entities:

  • Azure Storage linked service
  • Azure SQL Database linked service
  • Azure Blob input datasets
  • Azure SQL Datbase output dataset
  • Pipeline with a copy activity

To get the name of the data factory

  1. Click the Deployment succeeded message.
  2. Click Go to resource group.
  3. Search for *datafactory that's created.

The following sections provide steps for running and monitoring the pipeline. For more information, see Quickstart: Create a data factory by using Azure PowerShell.

Run and monitor the pipeline

After you deploy the template, to run and monitor the pipeline, do the following steps:

  1. Download runmonitor.ps1 to a folder on your machine.

  2. Launch Azure PowerShell.

  3. Run the following command to log in to Azure.

    Login-AzureRmAccount
    
  4. Switch to the folder where you copied the script file.

  5. Run the following command to log in to Azure after specifying the names of your Azure resource group and the data factory.

     .\runmonitor.ps1 -resourceGroupName "<name of your resource group>" -DataFactoryName "<name of your data factory>"
    

Tags: Microsoft.DataFactory/factories, linkedservices, AzureStorage, SecureString, AzureSqlDatabase, datasets, AzureBlob, string, TextFormat, LinkedServiceReference, AzureSqlTable, pipelines, Copy, BlobSource, SqlSink, DatasetReference, Microsoft.Storage/storageAccounts, Microsoft.Sql/servers, firewallrules, databases