December 2018
Beginner to intermediate
116 pages
2h 22m
English
Having explored the basic approach to copying data to an Azure SQL instance using an ADF pipeline in the previous chapter, we’ll now expand our data storage options by working with Azure Data Lake Server (ADLS) storage. With ADLS, just about any type of data can be uploaded, such as spreadsheets, CSV files, database dumps, and other formats. In this chapter, we’ll look at uploading CSV and database extracts containing simple sales information to ADLS. This sales information will be related to the customer data that was used in the previous chapter. For example, the CSV file will contain the customer ID that can be related to the record in the Azure SQL database. This relationship will be made ...