Implementing a data model in your Data Lake
You can argue that this should already be done in your Data Lake Storage. But if you examine the capabilities of the services when it comes to interconnectivity and the options to query data directly from the Data Lake without loading it into a database, we can set up a hybrid data model and not only use these functionalities to save a lot of money, but also reduce complexity and loading time windows in your data warehouse.
The rising data volumes that you might face can impact your loading and query strategy heavily. And even with the Azure backbone network, you will come to a point where the latency for loading your data into your data warehouse will no longer be sufficient.
Understanding interconnectivity between your data lake and the presentation layer
Later in this book, we will dive into the Synapse SQL pools (Chapter 4 and Chapter 11) and Synapse SQL on-demand (Chapter 11). These databases – or better, SQL services...
