Cosmos DB partial indexes support is currently not enabled - how to enable? (using Mongo DB api for Cosmos DB)

Patrick Gidich 11 Reputation points
2022-04-22T03:55:33.27+00:00

I would like to use partial indexes as noted in the documentation for the MongoDB API on Cosmos DB, however in doing so I'm greeted with the following message:

"partial indexes support is currently not enabled, please reach out to Cosmos DB support to enable this feature."  

I had 2 options with support - pay $29 or post here - hoping this gets me to the solution.

This is the command I was issuing:

db.communities.createIndex(   
   { handle: 1 },   
   { unique: true, partialFilterExpression: { handle: { $exists:true } } }   
)   

Documentation Link:
https://learn.microsoft.com/en-us/azure/cosmos-db/mongodb/mongodb-indexing#unique-partial-indexes

I'm using v4.2 of the MongoDB API

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,901 questions
0 comments No comments
{count} vote

3 answers

Sort by: Most helpful
  1. Hasan Savran 331 Reputation points MVP
    2022-04-22T18:07:36.427+00:00

    Hi @Patrick Gidich
    I have reached to the product team for your question and they realized this is not documented anywhere and they started to work on removing this roadblock for you and all other customer who likes to enable this feature.
    I will keep you updated from here when I have any updates from them.

    Thank you


  2. Hasan Savran 331 Reputation points MVP
    2022-05-17T13:30:10.65+00:00

    @AleksandraPetrova-9546 @Patrick Gidich
    I need your email address to connect you to the team.
    Can you please send me an email. (hasansavran@Stuff .com)

    0 comments No comments

  3. Konrad Dabrowski 0 Reputation points
    2023-01-19T22:22:21.88+00:00

    I would also like this feature to be enabled, I'm trying to deploy rocketchat and get this error:

    MongoError: partial indexes support is currently not enabled, please reach out to Cosmos DB support to enable this feature.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.