Search code examples
sql-serverazuredata-warehouseazure-synapse

In Azure Synpase, how can I check how a table is distributed

In Azure Synapse, how can I check how a table is distributed. For example whether it is distributed in a round robin manner or with hash keys.

Solution

  • You can use the Dynamic Management View (DMV) sys.pdw_table_distribution_properties in a dedicated SQL pool to determine if a table is distributed via round robin, hash or replicated, eg

    SELECT 
       OBJECT_SCHEMA_NAME( object_id ) schemaName, 
       OBJECT_NAME( object_id ) tableName,
       *
FROM sys.pdw_table_distribution_properties;

    It's the distribution_policy_desc column. Some sample results:

    Results