1

Msg 104467, Level 16, State 1, Line 1 Enforced unique constraints are not supported in Azure SQL Data Warehouse. To create an unenforced unique constraint you must include the NOT ENFORCED syntax as part of your statement.

4

If you look at the list of Unsupported Table Features for Azure SQL Data Warehouse, unique constraints is still on that list as at today:

Unsupported Table Features in SQL DW

It may be that they get supported at some point in the future but I wouldn't hold your breath for this MPP system. As a workaround, get your ELT/ETL process to ensure records are unique during ingest for example, or make an assumption where the data has been imported from an upstream system which does have unqiue constraints, that it is valid. Do some validation via reports / queries to check.

  • If azure sql dw does not support primary and foreign keys then how azure calls it a relational since the relationship between tables is established by these keys? – Naresh Joshi Nov 2 '18 at 10:09
  • Relation in this sense is the name for a table (or collection of tuples) as per the original relational theory, not the relationships between them. – wBob Nov 2 '18 at 16:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.