How can we improve Microsoft Azure SQL Data Warehouse ?

Allow Unique Index on Columns that intersect the distribution column

If SET tables aren't available, at least allow an UNIQUE INDEX to be placed on a table if the DISTRIBUTION column is found in the columns of the UNIQUE INDEX

For example

Table with location_id and product_id with any number of fact columns. Partition the table by product_id. All the data for any product_id will be on one specific distribution. Allow that distribution to enforce uniqueness on location_id + product_id.

5 votes
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)

We’ll send you updates on this idea

Azure DBA shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base