14 data flows: These contain the logic to load from the source system and land the data into the target database.17 pipelines: These are scheduled to ensure the data loads into the target tables correctly, and include one pipeline per source table plus the scheduling ones.You'll find the below components of the template: You'll get a notification that all 31 resources in the template have been created, and can review these before committing or publishing them. From the template overview page you can see a preview of the initial starting configuration of the pipeline, and select Open pipeline to create the resources in your own workspace. The template is designed to require minimal configuration. These steps open the template overview page. Select the AdventureWorks template, and then select Continue. Select Pipelines, and filter the results with the keyword "AdventureWorks." You can search for datasets, scripts, pipelines, and more to install in your workspace. From the home page, select Knowledge Center and then select Browse gallery. Create an Azure Synapse Workspace if you don't have one already.įollow these steps to locate the template. If you don't have an Azure subscription, create a free Azure account before you begin. In this case, they're being used as an example for how to use Synapse Pipelines to map retail data to the Retail database template for further analysis within Azure Synapse. OverviewĪdventureWorks is a fictional sports equipment retailer that is used to demo Microsoft applications. This document explains how to setup and use Microsoft's AdventureWorks pipeline template to jump start the exploration of the AdventureWorks dataset using Azure Synapse Analytics and the Retail database template.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |