Edit

Share via


Templates for Data Factory in Microsoft Fabric

Templates are predefined pipelines that allow you to get started quickly with Data Factory. These templates help to reduce development time by providing an easy way to create pipelines for common data integration scenarios.

Screenshot showing the templates browser in [!INCLUDE [product-name](../includes/product-name.md)].

How to build a pipeline from a template

You can build a Data Factory pipeline from a template in two ways:

  • the Pipeline template gallery
  • import your own template

There are two ways to access the Pipeline template gallery. You can either start by using a template or choose to add a template to your pipeline solution.

Get started with a template

  1. To get started with a template, start by selecting New and then Data pipeline.

    Screenshot showing the new data pipeline button.

  2. Set a name for your new pipeline and select Create. The pipeline editor window opens.

  3. Select Templates.

    Screenshot showing the pipeline editor window with the Template button highlighted.

  4. The template browser appears. Select the Copy data from ADLS Gen2 to Lakehouse Table template, and then select Next.

    Screenshot showing the pipeline templates browser and the Copy data from ADLS Gen2 to Lakehouse Table template selected.

  5. Select from the drop-down list your source and destination connections or use +New to create a new connection.

    Screenshot showing the template source and destination connections configuration and the New button to create a new connection.

  6. After making your selections or creating new connections, select the Use this template button to generate a new pipeline directly.

  7. The pipeline is created using the connections you set. You can view the newly created pipeline in the pipeline editor, where you can use the Run and Schedule buttons to control its execution.

    Screenshot showing the pipeline editor with the Run and Schedule buttons highlighted in the toolbar of the Home tab.

  8. Initially the new Copy activity is highlighted on the editor canvas, and its properties shown in the properties pane at the bottom of the editor.

  9. When you select the background of the pipeline canvas, you can see the general pipeline properties in the properties pane, where you can add or edit existing parameters.

    Screenshot showing the pipeline properties with the Parameters tab selected and several parameters added.

  10. When you're done, save your edits by selecting the save button on the toolbar of the Home tab.

Screenshot of the Home tab of the pipeline editor with the Save button selected.

  1. Now you can run your pipeline, providing values for any parameters as required.

Screenshot showing the Pipeline run dialog with parameters specified.

Add a template to your solution

You can also choose to add a template to your solution or get started with a template using the Use a template on the Home tab of your pipeline editor.

  1. Click Use a template.

    Screenshot showing the Pipeline template gallery button on the Home tab of the pipeline editor.

  2. The same template browser appears. Select the template you want to use and click Next.

    Screenshot showing the Pipeline template gallery fly-out.

Save your solution as a template

You can save a pipeline as a template by selecting the Export button on the Home tab of the pipeline editor.

Screenshot showing the Export button on the Home Tab.

A pop-up appears. To continue, click Export. A .zip file with the name of your pipeline will be saved.

Import your solution as a template

You can import your own pipelines two different ways.

Import from the Home tab

You can import a pipeline with the Import button on the Home tab.

Screenshot showing the Import button on the Home Tab.

This pops up a file browser. Select your pipeline .zip file and click Open. Your template will be imported and a preview of the pipeline will show.

Select your connections and click Use this template to finish importing your pipeline.

You can also choose to import a pipeline from the Pipeline template gallery.

From the Pipeline template gallery, click Import template.

Screenshot showing the Import template button from the Pipeline template gallery.

This opens a file browser and allow you to select your pipeline .zip file. Select your file and click Open. Your template will be imported and a preview will open. Once you've selected your connections and click Use this template to finish importing your pipeline.