Session

Table Distribution in Dedicated Pool: That is not "a simple table"

Dedicated Pool refers to the enterprise data warehousing features that are available in Azure Synapse Analytics.

Its engine is based on SQL Server's one and working with it will be very familiar for SQL Server people.

Do you need a table? You can start with CREATE TABLE command but, be aware that Dedicated Pool is a distributed engine and that table could be Replicated or Distributed over multiple nodes.

Distribution, Data Skew, Data Movement are "new concepts" you must be familiar with to get better performance in a Dedicated Pool.

Riccardo Perico

BI & Power BI Engineer @ Lucient Italia | Microsoft Data Platform MVP

Bergamo, Italy

View Speaker Profile

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top