Chapter 10: Loading the Presentation Layer

Now that you have seen the many modules that you have available on Azure to build your modern data warehouse architecture, let's dive into the Presentation layer in this chapter and the one following, Chapter 11, Developing and Maintaining the Presentation Layer.

In this chapter, you are going to learn how to load data into your Presentation Layer using either PolyBase, the COPY command, or, alternatively, Synapse pipelines.

You will see how you can include Synapse serverless SQL pools and examine the benefits of using this tool, implementing SQL directly in your data lake.

Additionally, we will investigate how you can leverage Spark to extend the functionality of your data loads beyond the SQL language.

Finally, we will examine the options in terms of Synapse regarding metadata exchange between the different compute components and how this will increase developer efficiency.

The topics covered in this chapter are as...