Pedro Martinez explains the idea behind replicated tables in Azure Synapse Analytics dedicated SQL pools:
If you have ever used Azure Synapse Analytics dedicated SQL pool you would know there are multiple table types to choose from, for your workload. You might ask yourself, “when can I use Replicated table type and how I can efficiently use them”?
This blog is going to talk in detail about replicated table type, when to use and what are best practices for its usage. But before that, let’s start by understanding the different table types:
I’ve seen replicated tables get overused, so check out Pedro’s advice on how not to get burned with them.