Azure Cosmos DB

Azure Cosmos DB is a globally distributed database service designed to enable you to elastically and independently scale throughput and storage across any number of geographical regions with comprehensive SLAs. You can develop document, key/value, or graph databases with Cosmos DB using a series of popular APIs and programming models.

How can we improve Azure Cosmos DB?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. Make Cosmos DB a opensouce Database

    Why not?, Microsoft now love the opensource too, make Cosmos DB a opensouce database

    6 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • Allow TTL to be set by the Azure Cosmos DB Rest API

      Support the Collection Default TTL to be set by the Azure Cosmos DB Rest API

      1 vote
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • multiple write regions for a single collection

        Support multiple write regions natively in a single cosmos db collection. Currently to build globally distributed apps, the application need to query two separate collections and merge the results. Enable true global distribution with active - active pattern and not just global replication.

        3 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • Compress stored data

          Please compress data in place for more efficient use of storage.

          For example, I recently exported the entire dataset from a collection and gathered the following stats:

          DocumentDB Data Storage: 627 MiB (including hidden fields and other overhead I assume, but not Indexes)
          Exported JSON: 461.72 MiB
          Compressed JSON: 47MiB

          So potentially a 10x saving in data storage size.

          4 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • Create any index right out of Portal

            It needs to be possible to create an index right out of the portal and not only via issueing code as explained here: https://docs.microsoft.com/en-us/azure/documentdb/documentdb-indexing-policies -- this could be a function you can run, similar to fuctions for relational databases.
            As-is working with piles of ingested JSON data requires me to do indexing first and the portal UI could be more helpful with that. Thanks!

            4 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              2 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • 5 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • Support documents up to 16mb

                It's not possible to migrate documents greater than 2mb, please consider increase document size up to 16mb

                31 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • SDK Hooks for all requests

                  There doesn't seem to be a way to log all requests being sent from an application (on the application side). It would be helpful to log the return values and especially the RU consumed for all requests. For instance, with the .NET library the Document Query returns IQueryable and there doesn't seem to be a easy or documented way to determine the RU's of those requests.

                  3 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                  • Bug: Unexpected behaviour of aggregates in Query Explorer

                    When running an aggregate query over a large dataset in Query Explorer the results appear to be arbitrarily grouped. For example the simple query below is expected to return the overall latest processing time. However, it may return a much earlier date and give you the "Next Page" option which, when clicked on, will give you a new result.

                    Setting the "items per page" option to Unlimited makes no difference.

                    SELECT MAX(RawFeed.EventProcessedUtcTime) FROM RawFeed

                    2 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                    • OpenSource DocumentDB .NET SDK

                      Unlike this thread
                      https://feedback.azure.com/forums/263030-documentdb/suggestions/6334154-open-source-documentdb

                      We would like to have only the .NET SDK as opensource
                      https://github.com/Azure/azure-documentdb-dotnet/issues/128

                      I have been programming against docdb with .Net for more than one year now and 80% of my problems come from the .NET SDK. We must be able to step into source code easily and propose pull requests to fix bugs. This will help Microsoft DocDB dev team to speed up corrections and features on this SDK.

                      160 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • Allow nested properties with Resource.SetPropertyValue(string,string)

                        For a given document:

                        {
                        "id": "CDC101",
                        "title": "Fundamentals of database design",
                        "authordetails": {
                        "Name" : "Dave",
                        "Age : "33"
                        },
                        "credits": 10
                        }

                        It would be useful to be able to call:

                        doc.SetPropertyValue("authordetails.Name", "Mike");

                        8 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • Allow DocumentDB Firewall Entries for App Service

                          I can specify IP addresses that can get access to a DocumentDB account on the firewall blade as a single IP or as a CIDR range. I would like to specify that the firewall accept the outbound addresses for an app service by entering the name of the app service. That way, I can easily lock down the DocumentDB instance so that only the specific web app can use it. The important aspect of this is that if Azure changes the outbound addresses for the app service, then the DocumentDB firewall should automatically update for the new addresses. I need…

                          4 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • Aggregate queries fail on x64 builds but work ok on x86

                            When the VALUE keyword is not specified an exception is thrown unless I explicitly target x86 builds.

                            For full details see:

                            http://stackoverflow.com/questions/42907875/document-db-exception-occurs-performing-aggregate-queries-on-x64-platform

                            1 vote
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                            • More granular RU, auto-scale RU, separate read-write RU

                              This is marked as "completed" in some other posts, but it's still very much an issue.

                              We could use DocumentDB in more scenarios if the collections could be smaller and/or assumed lower or highly variable query volume. AWS DynamoDB billing, for example, is more granular and feels more flexible in many scenarios.

                              https://aws.amazon.com/dynamodb/pricing/

                              One use case is pilot projects where we may want to use noSQL DBs for agility. We can't create small collections cost-efficiently on Azure, and partitions aren't viable for this purpose. So we would end up maintaining many small, potentially underutilized, 400RU collections.

                              It would also be…

                              20 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                              • bill

                                Billing should be database level and not collection level

                                2 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                • 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
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Integrate with Azure Active Directory

                                    Really need to be able to set resource level access control integrated with Azure Active Directory. The current built-in user / resource access control is a pain to use and we end up with just using the master key and giving everyone access to everything.

                                    Azure SQL DB already has this, and is a pleasure to work with.

                                    Perhaps you should take a leaf from your sister team on this -

                                    https://docs.microsoft.com/en-us/azure/sql-database/sql-database-control-access-aad-authentication-get-started

                                    51 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Local DocumentDB for Windows Server

                                      I suggest to have DocumentDB to work on local network on Windows Server and not only on Azure just like Microsoft SQL Server

                                      26 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Support including docs that do not contain the property which is being sorted on

                                        When using the ORDER BY clause, if a document does not contain the property which is being sorted on, that document will not be included in the result set.

                                        Would it be possible to treat 'undefined' the same as 'null' when returning results sets that use an ORDER BY clause?

                                        13 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Add Group By support for Aggregate Functions

                                          We're really happy about the new aggregate functions that recently were announced. But without Group By support they fall short and will leave many disappointed. Please add Group By support as well.

                                          676 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            15 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 9 10
                                          • Don't see your idea?

                                          Azure Cosmos DB

                                          Feedback and Knowledge Base