Chapter 6: Implementing Logical Data Structures

I hope you enjoyed learning about the implementation details of storage structures. In this chapter, we will be covering the implementation details of logical data structures. You will learn to implement advanced data loading concepts like slowly changing dimensions, storage based solutions for optimizing query performance and techniques to read external data without having to copy them over to local storage.

We will cover the following topics in this chapter:

  • Building a temporal data solution
  • Building a slowly changing dimension
  • Building a logical folder structure
  • Implementing file and folder structures for efficient querying and data pruning
  • Building external tables

Technical requirements

Get Azure Data Engineer Associate Certification Guide 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.