Creating distributed tables and modifying table distribution
A Synapse dedicated SQL pool is a distributed database allowing us to distribute data across multiple nodes and process it in parallel at multiple nodes to make data processing more efficient. To leverage the powers of the distributed database effectively, we need to store the data across the nodes with the correct strategy. A Synapse dedicated SQL pool offers three options while distributing the data, and they are listed as follows:
- Round-Robin distribution – This distributes the data equally across the nodes of the SQL pool.
- Hash distribution – This distributes the data based on the values of a column in the table.
- Replicated – This copies the table to all nodes of the dedicated SQL pool.
The table distribution option is selected at the time of table creation and can’t be modified afterward. In this recipe, we will create a table specifying a distribution option, and we...
