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.
  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Permission Query Filter

    I was thinking about the limit on 3 AND/OR options in queries. What if we could put a (Query Filter) Json Document on a permission so the User only has access to documents that match the query. something like {"CompanyId" : 1} or {"CompanyId" : "frog", "SalesRepId" : 1565}
    Then that User can only access documents that have properties and values that match the filter json document. This would simplify our main queries and not have to worry about permissions so much...
    Or just let us have like 30 AND/OR combinations in queries and call it a day.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Query for Fields not defined

    Query documents that don't have fields defined?
    Select * from docs d where d.Foo = Undefined

    This would be useful for querying for past versions of documents that didn't have certain fields.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Please remove the $filter function from the Aggregation Pipeline Compatibility List

    The $$this variable is not supported. Therefore the function is not compatible and in this way, completely useless.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  MongoDB API  ·  Flag idea as inappropriate…  ·  Admin →

    We fixed $filter, along with many other aggregation expression issues, last July.

    This expression below works now:

    db.mycollection.aggregate({$project:{a:{$let:{vars:{a:[1,2,3,4]},in:{$filter:{input:“$$a”,cond:{$gt:[“$$this”,2]}}}}}}})

    Thank you for reporting.

  4. Best practices code sample (starting point)

    It would be really nice to have a best practices code sample for a good starting point of an restful API in ASP.Net 5/MVC6.
    The Code sample would impliment Repository pattern, with latest sdk and Partion strategy (e.g. RangePartitionResolver with dateTime/epoch).

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. To implement sql job agent methods in documentdb

    sql server sql job agent available ...pls provided this method to documentdb automatic execute query particular time

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Please add feature that can check the time when container created, when auto back up stored, when auto back up will be stored.

    Please add feature that can check the time when container created, when auto back up stored, when auto back up will be stored.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
  7. Enable Cosmos Autoscale Throughput settings from the SDK's

    Currently, Cosmos Autoscale is only available through the portal. We would like programmatic access for this feature so the database will use autoscale when we programmatically create a container and perform the initial data load.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  8. javascript function as data source in SQL

    currently the UDF can be used in the WHERE clause

    if it was available in the FROM clause as well as a source of a document collection that would be nice.

    For eg

    select * from mydatasourceFunc( collection, parm1, parm2 ) where someField=1

    then the mydatasourceFunc could add filter() or map() or whatever to generate rows.

    this could help enforcing ACL like the accumulo iterators for eg
    it could help generating aggregates and/or nested aggregates

    it would also be nice for it to have access to the context/request/response objects for this function as documented here

    http://azure.github.io/azure-documentdb-js-server/

    and if internally docdb…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Support for aggregated UDF. Compose a result of an inner query to be the input of the outer query.

    Today when executing a UDF against a collection of documents we get a collection of results but there is no way to write a query that will execute another UDF on those results.

    Let us say we have two UDF functions registered.

    When using the first UDF1 in a query we get a collection of results for example:

    [
    {

    "result": 10
    

    },
    {

    "result": 11
    

    },
    {

    "result": 12
    

    }
    ]
    Today it is impossible to write a query that applies UDF2 on this collection to produce a single value, for example

    {

    "total-sum": 33
    

    }

    In other words:…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Change stream starting point

    Please add these options to change streams startAtOperationTime / startAfter / resumeAfter

    The absence of the opportunity to set a change stream beginning point makes it absolutely useless :(

    https://docs.mongodb.com/manual/reference/method/db.collection.watch/#db.collection.watch

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  MongoDB API  ·  Flag idea as inappropriate…  ·  Admin →
  11. Touch-friendly database deletion

    It would be great to have a touch-friendly version of deleting a database in the portal. Currently that is only possible via a right-click (which is also not intuitive). On an iPad it is not possible to delete a database via the portal.

    Something like a garbage bin at the end of the database entry (see picture) would be great.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Request add document overwrite feature in document DB import tool.

    Hello, Want to request an overwrite document feature in document DB import tool. I am trying to use this tool to be able to export collections and import them to an alternate DC for backup and restore of the document collections just in case an accidental deletion happens on the actual collection. My idea is to use the tool in command mode and replicate data at set interval's to an alternate data center and have a second copy available and able to overwrite the same collection in the next schedule without needing to create another collection

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Documentdb scale configuration does not work

    I am trying to configure the scale of my documentdb database from 2 units to 1. Although the configuration task seems to execute successfully (that's what I get notified), if I refresh the page, the scale of documentdb still shows "2" instead of "1".

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Manage parallel processing server side

    If I run a query like "SELECT * FROM d WHERE d.field = "x" against a parallel database I expect the DBMS to run that query against each partition at the same time and return a set of collated results. As apparent from the REST API, it appears that such a query is only executed against 1 partition at a time. This means that to get proper parallel processing the client has to work out the partitioning, fire multiple queries and do the collation client side. To some extent this appears to have been encapsulated in the SDKs.

    To me,…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL API  ·  Flag idea as inappropriate…  ·  Admin →
  16. ServerError: ALLOW FILTERING queries are not supported yet for the query provided. ServerError: 'MAX' is not supported yet.

    I am stuck at this point because earlier I was using Cassandra then all features are supported now I moved to azure cosmos db and facing these challenges. please provide some alternative.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Support for MongoDB API 3.4 aggregation operators: $arrayToObject, $objectToArray, $reduce ...

    Roughly when will support for these aggregation operators, and any others missing from MongoDB API 3.4.* , be available? We do small scale, in app, reports using the aggregation pipeline and it is quite a pain to work round not using these.

    Also I note that MongoDB server 3.4 is reaching end of life January 2020, https://www.mongodb.com/support-policy. When is the planned upgrade for 3.6?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  MongoDB API  ·  Flag idea as inappropriate…  ·  Admin →
  18. Include stored procedures and udfs and triggers as part of Data Migration export

    Include stored procedures, udf's and triggers as part of Data Migration export for document db

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL API  ·  Flag idea as inappropriate…  ·  Admin →

    This capability will not be built into our Data Migration Tool but there are ways to export and/or preserve these when migration Cosmos resources.

    Cosmos now has support for stored procedures, triggers and UDF’s in it’s resource provider. This means customers can export ARM templates that include these resources. Customers can also create these resources from both ARM templates as well as Azure Management Library. This allows customers to put these into version control and maintain them and deploy them as a part of their regular CI/CD pipelines.

    For samples on creating stored procedures, triggers and UDF’s for Cosmos via ARM templates see, https://docs.microsoft.com/en-us/azure/cosmos-db/manage-sql-with-resource-manager#create-sproc

    For samples on creating stored procedures, triggers and UDF’s using Azure Management Library see here,
    https://github.com/Azure-Samples/cosmos-management-net

    Thanks.

  19. Where can i find documentation for `pydocumentdb` python module?

    In some examples pydocumentdb is used extensively. Where can i find more documentations about it? explaining different methods and some examples too?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Remove the "strict-transport-security" response header for local development

    Remove the "strict-transport-security" response header for local development as this conflicts with other localhost web interfaces such as Azure Service Fabric that doesn't have a HTTPS endpoint.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base