It is possible to have multiple unique constraints in an Azure search index?

Question

Below is the data I'm putting into Azure search:

Id is the unique key on the index.

I'd like to put an additional unique constraint on EntityName + Key.

I wondered whether this possible in Azure search?

question from:https://stackoverflow.com/questions/65840893/it-is-possible-to-have-multiple-unique-constraints-in-an-azure-search-index

Answer 1

In your example, the SQL database is the source of truth and you can only put unique constraints on your SQL, not on Azure Cognitive Search.

You can check the details about adding unique constraints to SQL Server databases here.

Also, please, excuse me for the offtopic, but the EntityName seems more like an EntityType, as it is not unique.