Templates
APPLIES TO: Azure Data Factory Azure Synapse Analytics
Tip
Try out Data Factory in Microsoft Fabric, an all-in-one analytics solution for enterprises. Microsoft Fabric covers everything from data movement to data science, real-time analytics, business intelligence, and reporting. Learn how to start a new trial for free!
Templates are predefined Azure Data Factory pipelines that allow you to get started quickly with Data Factory. Templates are useful when you're new to Data Factory and want to get started quickly. These templates reduce the development time for building data integration projects thereby improving developer productivity.
You can get started creating a Data Factory pipeline from a template in the following two ways:
Select Pipeline templates in the Discover more section of the Data Factory home page to open the template gallery.
On the Author tab in Resource Explorer, select +, then select Pipeline from template to open the template gallery.
Data Factory uses Azure Resource Manager templates for saving data factory pipeline templates. You can see all the Resource Manager templates, along with the manifest file used for out of the box Data Factory templates, in the official Azure Data Factory GitHub repo. The predefined templates provided by Microsoft include but are not limited to the following items:
Copy templates:
Copy from <source> to <destination>
From Google Big Query to Azure Data Lake Store Gen 2
From HDF to Azure Data Lake Store Gen 2
From Netezza to Azure Data Lake Store Gen 1
From SQL Server on premises to Azure SQL Database
From SQL Server on premises to Azure Synapse Analytics
From Oracle on premises to Azure Synapse Analytics
SSIS templates
- Schedule Azure-SSIS Integration Runtime to execute SSIS packages
Transform templates
You can also save a pipeline as a template by selecting Save as template on the Pipeline tab.
After checking the My templates box in the Template gallery page, you can view pipelines saved as templates in the right pane of this page.
Note
To use the My Templates feature, you have to enable GIT integration. Both Azure DevOps GIT and GitHub are supported.
Community members are now welcome to contribute to the Template Gallery. You will be able to see these templates when you filter by Contributor.
To learn how you can contribute to the template gallery, please read our introduction and instructions.
Note
Community template submissions will be reviewed by the Azure Data Factory team. If your submission, does not meet our guidelines or quality checks, we will not merge your template into the gallery.