Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

Azure Cosmos DB

Have feedback for Azure Cosmos DB product? Submit your idea here or upvote other ideas. All feedback is monitored and reviewed by the Azure Cosmos DB team. 

This site is for feature suggestions only. For technical questions or issues, please submit them to StackOverflow,where we and the community can better help you.

Please use the following categories when submitting your idea.

SQL API: Query language features, syntax using SQL API, indexing, any other core features in Azure Cosmos DB.

Gremlin API: Graph features and capabilities using Gremlin API.

Cassandra API: Features and capabilities using Cassandra API.

MongoDB API: Features and capabilities using MongoDB API.

Table API: Features and capabilities using Table API.

Etcd API: Features related to using etcd as a configuration store for Kubernetes.

Azure Synapse Link: Features related to Azure Cosmos DBanalytical store and Azure Synapse Analytics run-time support

Built-in Notebooks: Features related to built-in Notebooks in Azure Cosmos DB.

SDK: Features related to Azure Cosmos DB SDKs for SQL API.

Change Feed: Features related to Change Feed.

Management: All management features, backup/restore,monitoring, ARM, PowerShell and CLI.

Portal: All features for Azure Portal and Cosmos DB Explorer.

Emulator: Features related to the Azure Cosmos Emulator.

Other: Features not related to any other category.

Security:
Authentication, authorization,permissions and encryption features.

Monitoring:
Metrics, monitoring, alerts,and diagnostics features.

Server-side: Stored procedures, Triggers,and User-Defined Functions.

Managed Apache Cassandra: Featuresand capabilities related to Azure Managed Instance for Apache Cassandra.
  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Use Order By with Group By

    In the documentation for group by (https://docs.microsoft.com/en-us/azure/cosmos-db/sql-query-group-by) you state:

    You currently cannot use GROUP BY with an ORDER BY clause but this is planned.

    Adding here so we can hopefully get some feedback on its progress and to communicate its importance to the community.

    In all my use cases for using group by, I am only interested in returning a subset of the results which without order by I cannot. I must return all results and then order & filter them in the client which is poor from a performance and cost perspective or completely unfeasible depending on…

    112 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  SQL API  ·  Flag idea as inappropriate…  ·  Admin →
  2. Efficient case-insensitive search

    At the moment, STRINGEQUALS with the case-insensitive flag requires a linear index scan over the property, so it is cardinality dependent, resulting in extremely high RU charges in large collections. Please implement a (perhaps optional) index that supports cardinality independent case-insensitive STRINGEQUALS. At the moment, the ugly workaround is to manually store duplicates of the property values in lower case. See also https://stackoverflow.com/questions/66024029/high-ru-charge-with-case-insensitive-search/66249495#66249495

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  SQL API  ·  Flag idea as inappropriate…  ·  Admin →
  3. Group By should use the Index

    Group By performance is really bad.
    It is unusable without Index support.

    Please please please add Index support.

    24 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL API  ·  Flag idea as inappropriate…  ·  Admin →
  4. Support key name search

    We would like to search key name base on value. For example, we would like to search based on key name such as "data1".

    Query example

    select c.? from c where c.? = "data1"

    {
    { "data1" : {

      id : 001,
    
    name : sample

    },
    { "data2" : {

      id : 002,
    
    name : sample2,

    }
    }

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL API  ·  Flag idea as inappropriate…  ·  Admin →
  5. Use index for NOT ARRAY_CONTAINS

    When you do queries with ARRAY_CONTAINS, it uses the index.

    But if you want to do an excluding query with NOT ARRAY_CONTAINS it does not and the query becomes very expensive.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL API  ·  Flag idea as inappropriate…  ·  Admin →
  6. Provide Spring Client for Cosmos DB

    Unable to add dependencies for Cosmos DB client, Please provide easy client for spring, not with spring data

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL API  ·  Flag idea as inappropriate…  ·  Admin →
  7. SQL API: Allow ORDER BY on the results of a GROUP BY

    Allow ORDER BY on the results of a GROUP BY. This would also facilitate doing a TOP n on the GROUP BY results

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL API  ·  Flag idea as inappropriate…  ·  Admin →
  8. Recommend the best composite indexes.

    I'd like to know the best composite indexes for my queries.

    For example, when I execute a query by a SDK or portal, Cosmos DB returns results and the best index for it.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL API  ·  Flag idea as inappropriate…  ·  Admin →
  9. Order by string to number in cosmosdb

    Currently order by string to number is not working in cosmosdb

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL API  ·  Flag idea as inappropriate…  ·  Admin →
  10. Cross-partition group by support

    Group By should support cross-partition queries.

    13 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL API  ·  Flag idea as inappropriate…  ·  Admin →
  11. STDEV

    Please implement the standard deviation aggregate function.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL API  ·  Flag idea as inappropriate…  ·  Admin →
  12. Transaction across multiple containers by SDKs.

    Currently, Cosmos DB doesn't have transactions across multiple containers.
    It's very useful to do atomic writing or updating documents.
    And, I'm using the Node.js SDK, so I'd be happy if I could do it with it.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL API  ·  Flag idea as inappropriate…  ·  Admin →
  13. Linq keyword ALL is not supporting.

    We are using Linq to connect CosmosDB. While fetching Data from Cosmosdb we have to use Linq ALL keyword but we are getting error like ALL method is not supported. Is there any way to implement same functionality of ALL. Waiting for your response.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL API  ·  Flag idea as inappropriate…  ·  Admin →
  14. Built-in functions for calculating distance metrics

    It would be great to have built-in functions for calculating distance metrics like Euclidean Distance and Hamming Distance.

    These metrics are widely used e.g. in ML-flavored applications and it would be very useful to have optimized built-in functions.

    See https://stackoverflow.com/questions/64416618/how-to-calculate-hemming-distance-in-cosmosdb/

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL API  ·  Flag idea as inappropriate…  ·  Admin →
  15. Built-in functions for bitwise operations

    Since Cosmos DB doesn't support bitwise operations on 64-bit numbers (due to lack of support of it in JS), it would be great to have built-in functions like AND, OR, XOR.

    Bitwise operations are widely used e.g. in the calculation of Hamming Distance, one of the most used distance metrics in Machine Learning.

    See https://stackoverflow.com/questions/64416618/how-to-calculate-hemming-distance-in-cosmosdb/

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL API  ·  Flag idea as inappropriate…  ·  Admin →
  16. Improve "OFFSET LIMIT" RU.

    "OFFSET LIMIT" improves client performance for pagination.
    But it doesn't reduce RU.
    It's also important to improve back-end performance.

    15 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL API  ·  Flag idea as inappropriate…  ·  Admin →
  17. Remove or drastically increase the limit of 4096 points per polygon in cosmos spatial data

    Remove or drastically increase the limit of 4096 points per polygon in cosmos spatial data

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL API  ·  Flag idea as inappropriate…  ·  Admin →
  18. Support for a random item return in Cosmos DB

    It would be nice to have the ability to get a random set of items from a container in the same way you can with SQL. It would also be nice to have a seed ID for the purpose of being able to pull the same random set again in the future.

    Simple example of current functionality:

    SELECT TOP 10 *
    FROM [table]
    ORDER BY newid()

    11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL API  ·  Flag idea as inappropriate…  ·  Admin →
  19. Add HAVING clause

    Now that group by is supported, if you add having clause functionality, it would be helpful.

    24 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL API  ·  Flag idea as inappropriate…  ·  Admin →
  20. Cosmos DB SQL API should support ORDER BYon computed fields.

    Cosmos DB SQL API should support ORDER BYon computed fields.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL API  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3
  • Don't see your idea?

Feedback and Knowledge Base