Implementing tables in Synapse SQL pools
In Chapter 4, Provisioning and Implementing an Azure SQL DB, we started with a section on SQL Server data types, followed by a section on quantifying the data model. We should do the same here. In Chapter 7, Dimensional Modeling, you learned how to create a logical model of a star schema database. You will have to translate the logical model into a physical model before implementing the database. Luckily for us, Synapse Analytics SQL pools are based on SQL Server. That means we have the same data type system. You might want to re-read the section SQL Server data types of Chapter 4, Provisioning and Implementing an Azure SQL DB.
Quantifying the model and understanding how your SQL pool will be used is also important before implementing the tables. With a Synapse SQL pool, there is an additional design step that is very important. As we already said, a SQL pool is implemented by using 60 databases, called distributions. You need to decide for...
