Chapter 3 Azure Data Warehouse and Data Integration using ADF or External Tables

In the first two chapters you’ve worked through building out a variety of components. All the components can stand alone on their own, and the data can be queried and reported on. However, to perform complex analysis of data from a variety of disparate sources, especially involving historical data, you’ll need to load all of this data into a data warehouse. An Azure Data Warehouse (ADW) allows for storage of data as well as the dimensional modeling of that data, which utilizes facts and dimensions.

In this chapter we’ll build out a simple data model in an ADW instance and then use an ADF pipeline to populate it with information from the sources that have been developed ...

Get Quick Start Guide to Azure Data Factory, Azure Data Lake Server, and Azure Data Warehouse now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.