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.

SQL API:
With the SQL API, Azure Cosmos DB provides rich and familiar SQL query capabilities with consistent low latencies over schema-less JSON data. In this article, we provide an overview of the Azure Cosmos DB’s SQL API, and how to best use the API.

Gremlin API:
Azure Cosmos DB provides the Gremlin API for graph modeling and traversal, along with turn-key global distribution, elastic scaling of storage and throughput, and low latency.

Cassandra API
Azure Cosmos DB supports the Cassandra API. This means that by using existing drivers, your application written for Cassandra can now communicate with Azure Cosmos DB instead of Apache Cassandra/Datastax Enterprise databases, and gain benefits like global distribution and elastic scale.

MongoDB API:
Azure Cosmos DB supports the MongoDB API. This means that by using existing drivers, your application written for MongoDB can now communicate with Cosmos DB instead of MongoDB databases, and gain benefits like global distribution & elastic scale.

Table API:
Azure Cosmos DB provides the Table API for key-value workloads. This provides a premium experience for Azure Table storage with secondary indexes, global distribution, low latency, and dedicated throughput.

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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Pin the Graphs from the Metrics Page to Azure Portal Dashboards

    I would love to be able to pin the graphs on the Metrics tab of the Azure Portal blade for Cosmos DB to my Azure Dashboard. Many other services allow this and it's great to get an overview of health, status and usage. Also great for Ops dashboards, sharing, etc.

    Right now the work around is to manually point the diagnostic logs to an OMS workspace and recreate the query in Log Analytics, and then pin it. It kinda sucks and your graphs are way better.

    62 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  2. Configure RU per region

    For a database/collection that is made available in several regions, make it possible to provision RU capacity independently in each region. Use case: Secondary backup region that exists only as an up-to-date mirror of data in case the primary becomes unavailable, not to offload read operations under normal operation. Currently this means provisioning unused RU capacity, at a high cost, in the secondary region.

    46 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

    Hi Magnus. This is currently unplanned by us for our road map. Some context and feedback for you on this.

    First, to do the replication itself to the secondary region you need RU/s sufficient to support the request rates for the primary region itself. Replication and writing to the secondary region itself is not free so there needs to be sufficient throughput provisioned to do that.

    Second, for the secondary region to be able to function as the primary should a fail over occur, the replica region itself needs sufficient throughput to function as the primary.

    Thanks again for your suggestion. Will mark as unplanned for now in case circumstances ever do change.

  3. Better documentation on integration with Logic Apps (or bugfix?) - We have serious difficulties with an error on "PartitionKey"

    We are trying to do serverless with logic apps and have connected the Logic App to an Event Grid Topic. Our intent is to store events in Document DB, but we are unable to get it to work because of errors regarding the Partition Key. We have tried all possible strings in the partition key field and created a number for collections with different partion keys. We don't know what black magic spells we need to use and cannot really find good documentation with examples of such operations on the docs for either Cosmos DB or Logic Apps.:

    One of…

    33 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  4. Bug: emulator's Data Explorer stops working if left inactive for 15 minutes

    Steps to reproduce:

    1) Install Cosmos DB
    2) Open Data Explorer in a browser tab
    3) Make a query
    4) Wait for > 15 minutes
    5) Execute another query
    Expected: it works
    Actual result: the following error pops up:

    {"code":403,"body":"{\"code\":\"Forbidden\",\"message\":\"The authorization token is not valid at the current time. Please create another token and retry (token start time: Mon, 09 Jul 2018 08:22:30 GMT, token expiry time: Mon, 09 Jul 2018 08:37:30 GMT, current server time: Mon, 09 Jul 2018 08:46:19 GMT).\\r\\nActivityId: 1bb68cc4-6bae-4e94-83ab-445da191c8e2, Microsoft.Azure.Documents.Common/1.22.0.0\"}","activityId":"1bb68cc4-6bae-4e94-83ab-445da191c8e2"}

    This is extremely annoying, as a multiple times a day I have to open a new…

    31 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

    This was a bug we saw reported back in November. We released a fix for this issue back in late December.

    Can one of you reporting here confirm whether this is still an issue? If so, can you email us at askcosmosdb at microsoft dot com. We want to gather more information so we can identify and fix if this is a separate issue from the one above.

    Thanks.

  5. Azure Cosmos DB: HBase API

    Add support to Azure Cosmos DB for HBase API. This will open up many Big Data use cases.

    15 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  6. 12 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  7. Faster resource deletion

    CosmosDB resources take a very long time to delete. Make this faster please!

    6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  8. improve cost calculator to include real storage costs

    Currently the cost calculator only shows the costs for storage. However, there is a hidden cost which is only mentioned in one place in the documentation; a minimum throughput of 40 RU's per gigabyte in the database. This increases the storage costs about tenfold.

    Unfortunately, this cost is not mentioned in any of the cost calculators that microsoft offers. This made our usage of cosmosdb unfeasible and cost us a few weeks of prototype development down the drain.

    6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  9. Make Throttled Request metric (Cosmos DB) available for configuring a unified alert

    When looking to migrate our alerting (deployed in ARM templates) to the new alerting platform the throttled request metric is not available when configuring an alert for Cosmos DB resources, we currently have a classic alert using this metric. I have attempted to use an alert based on 'Total Requests' filtering for response code 429 but this doesn't seem to behave the same as the existing Classic alert (maybe due to the only available setting for 'timeAggregation' being 'Count'). Having logged a support request it was suggested I make a request here.

    5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  10. Allow Activity Log Alert on Control Plane operations

    To be notified if someone deletes a collection unintended, i think it would be great to have an activity entry for collection removal. Right now, I only can set an event if the database is removed.

    5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  11. Please add role that has permission [Read Collection],[Read Document],[Delete Document].

    As far as I know, there is just 2 role "Reader" and "Contributor".
    But this is not enough in my use-case.
    I want to create and assign custom role that has permission [Read Collection],[Read Document],[Delete Document].
    And I want to use Azure Portal to operation [Read Collection],[Read Document],[Delete Document].

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  12. Trigger updates to related information

    One of the biggest challenges in Document stores is having the same data repeated and being able to update it if there is a change to the actual document.

    For instance if you have a G/L structure that has an Account property that has values like this:

    {
    Debit: 100,
    Credit: 0,
    Account: {
    AccountId: 132432353234
    AccountNo: 1234,
    Name: "Checking Account"
    }
    }

    When the root account with AccountId = 132432353234 is updated with any relevant properties that are also in the g/l entry you have to update every g/l entry that now needs to reflect the change.

    It would…

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  13. Change (emulator's)explorer favicon.

    The browser-based cosmos db (emulator's) explorer has favicon looks the same as that of Microsoft's doc site.
    It is difficult to distinguish when multiple tabs are open.

    How about changing favicon?
    from
    images/favicon.ico
    to
    images/CosmosDB_20170829.svg or.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  14. whitelist ip - include a description

    Can we include a short text description for each white listed ip in the cosmos firewall settings - similar to azure sql server white listed ip settings

    It would make auditing so much easier, currently we have to maintain a seperate document showing which IP corresponds to what

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  15. Include Wildcard or "LIKE" search in azure cosmos db with Gremlin Graph API

    It is really frustrating implementation experience when working with Azure Cosmos gremlin. No support or concrete solution is available or provided even by Microsoft Support team. Charges are very high for Cosmos, but there is no full support for all Tinkerpop query methods. Query performance is very slow even when searching a collection which contains 33000 users data only. We're not able to implement auto-complete enable functionality using Azure Cosmos Gremlin Query API. The API is taking too much time to return JSON output. If we're getting such performance bottleneck then what is the benefits of using Azure Cosmos DB…

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  16. Option in UI to change localhost (127.0.0.1) binding in Cosmos Emulator

    Currently the only way to allow network access is through the command line with the /AllowNetworkAccess flag.

    Adding the ability to control this from the UI would be really useful, since localhost binding is the default.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  17. Open the Data Explorer instead of throwing an error in case the CosmosDB emulator is already running

    When the Azure CosmosDB emulator is started for the first time, it shows two notifications (starting, started) and then opens the Data Explorer automatically.

    When it is already running and a user starts it again (because they weren't sure it was running or thought it wasn't) we get an ugly error message instead - I've attached a screenshot of it.

    There is an understanding that users do not start the emulator just because, but to interact with it. This is as evidenced by the fact that the Data Explorer page opens upon the emulator start. This is good behavior, it…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  18. Better documentation and examples for Azure Cosmos DB Data Migration tool

    I would like better documentation for the Azure Cosmos DB Data Migration tool to ease migration to Cosmos DB from other data sources as these impedes migration of brownfield developments.

    If you are mapping LEFT joins from sql to arrays or collections of objects this documentation is missing from instructions. The below post is the only starting point for some

    https://stackoverflow.com/questions/45981322/how-to-import-documents-that-have-arrays-with-the-cosmos-db-data-migration-tool/45994471#45994471

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  19. Select network interface for Cosmos DB emulator to allow network access

    When the client SDK connects to the emulator it connects to the URL https://<myemulator DNS>:8081/.

    The emulator returns back the writeableLocations and the readableLocations in the JSON response and these URIs are used for subsequent access. It appears that the IP address returned are the first in the list of LAN network interfaces (e.g. in IPCONFIG). If you have multiple IP addresses (for example you have a DockerNAT virtual switch installed) then it might not be the best IP Address returned to allow network access.

    Why am I connecting to my emulator across the network you might ask? I'm…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  20. Godrej Azure Virtual Machines

    Find new and under construction projects by Godrej Group - Find furnished or unfurnished flats/apartments at an affordable price

    https://www.weplanithk.com/project/godrej-properties/11/

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

Azure Cosmos DB

Feedback and Knowledge Base