Skip to main content

Distribute Round Robin Temporary Tables

Enable to use Round Robin distribution in Azure Synapse temporary tables instead of the default Hash distribution.

For Azure Synapse targets, the generated load SQL creates its temporary tables with HASH distribution on the object's distribution key by default; enabling this setting switches those temporary tables to ROUND_ROBIN.

When to Change This Setting​

Keep the default N so temporary tables share the hash distribution of the target table. Enable it when hash-distributed temporary tables do not suit your load pattern, for example when the distribution key is heavily skewed.

Notes​

  • This setting is part of the Azure settings category.
  • The default value for this setting is N.