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.
Gremlin API: Graph features and capabilities using Gremlin 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.
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.
-
[DocumentDB] Allow Paging (skip/take)
Allowing paging would be huge. Btw, Thank You for rolling out this feature at all! It looks wonderful! Can't wait to try it! However, I won't be able to use it for actual work projects until it supports paging and sorting.
3,865 votesWork on making this feature available in all SDK’s as well as cross-partition is now available so marking this as complete.
The team has seen your feedback regarding performance for queries with especially large OFFSET values and is currently working on optimizing these by better utilizing the index and further improving performance. These optimizations will be released shortly.
For more information on Offset/Limit please see, https://docs.microsoft.com/en-us/azure/cosmos-db/sql-query-offset-limit
Thank you.
-
Standalone local instance
I would be great to have a standalone version for offline development and unit testing. Something like Storage Emulator.
3,787 votesWe’re excited to announce the public preview of the DocumentDB Emulator (https://azure.microsoft.com/blog/documentdb-emulator-for-local-development-and-dotnet-core-support/), which provides a local development experience for the Azure DocumentDB service. Using the DocumentDB Emulator, you can develop and test your application locally without an internet connection, without creating an Azure subscription, and without incurring any costs.
This has long been the most requested feature on the user voice site, so we are thrilled to roll this out everyone that’s voted for it. Please let us know if you have any feedback, questions or suggestions.
Thank you,
Aravind Ramachandran
Azure DocumentDB -
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.
2,833 votesThank you everyone for your feedback. We are marking this as complete.
-
Add support for aggregate functions like Count, Sum, and Avg along with Grouping
It would be great to have some baseline aggregation functions support without having to return all the records and then perform aggregates on them in code.
2,611 votesWe’re excited to announce that with the last major service update, we have added support for aggregate functions in SQL. Support for aggregates is the most requested feature on the user voice site, so we are thrilled to roll this out everyone that’s voted for it.
Please see https://docs.microsoft.com/en-us/azure/documentdb/documentdb-sql-query#Aggregates for details.
-
Autoscale Throughput (RU/s)
Depending on the average amount of incomming requests/ required RU's, (or other parameters,)
I would like to autoscale the througput(RU/s) of a collection.1,851 votesWe have now released autoscale for general availability.
Thank you everyone for your comments and votes. We are very excited to release this feature for all of you.
https://devblogs.microsoft.com/cosmosdb/autoscale-serverless-offers/
Thanks.
-
Provide support for DISTINCT
Need to provide support for SELECT DISTINCT xyz FROM c.
1,621 votesAs noted by some comments below, support for DISTINCT is now available. We are working on updating our documentation for this to provide examples and more information. The updated documentation will be published in our SQL query doc here, https://docs.microsoft.com/en-us/azure/cosmos-db/sql-api-sql-query. Stay tuned, this will be updated soon.
Thanks.
-
Transaction support in client SDKs
it would be useful if documentdb transactions are supported in .net, rather than just storedprocs and triggers.
using trans = newtrans()
try
db.addsomething()
db.save() //ok
db.addother()
db.save() //fail
catch
trans.rollback
end try
end using1,305 votesThanks again everyone for your patience.
At this time we are going to mark this items as complete as it appears it meets the needs for the original poster as well as a plurality of others who added reactions to our previous status.
For those where this feature does not meet your needs there are User Voice items for Mongo transaction support, please vote those up. For those who are looking for this support for our JS SDK, please create a new User Voice and vote it up.
Thanks again.
-
Backup Solution for DocumentDB
It seems that there is no backup for DocumentDB. You should provide a backup solution for DocumentDB.
1,261 votesTwo automatic backups are retained for 8 hour. Please see more here
https://docs.microsoft.com/en-us/azure/cosmos-db/online-backup-and-restore
-
Batch Operation Support
Document DB should support batch operations in REST API and SDK level. It would be very useful to insert 1000 entities in one transaction.
1,210 votesWe released the bulk executor library for .NET and Java this past March that provides support for batch operations. For more information on this feature go to, https://docs.microsoft.com/en-us/azure/cosmos-db/bulk-executor-overview.
-
DocumentDB Free Tier
DocumentDB offering should provide a free tier for dev/testing.
I'm maintaining the MongoDB provider for NEventStore (https://github.com/NEventStore/NEventStore.Persistence.MongoDB) and would try to build a DocumentDB Persistence Provider.Would be even better to have an "open source" subscription for oss projects on azure (dev/testing)!
1,118 votesYes, CosmosDB is available free. Please check https://azure.microsoft.com/en-us/try/cosmosdb/
-
Manage Azure DocumentDB using PowerShell
We need a PowerShell module for managing Azure DocumentDB
1,117 votesCosmos DB now provides support for PowerShell for all resources including account, database, container and throughput.
For more information see the article below for samples.
Thank you for your suggestion and votes.
https://docs.microsoft.com/en-us/azure/cosmos-db/powershell-samples
-
Allow me to set JsonSerializerSettings
Today I have to use JsonProperty or JsonConverter attributes to decorate my objects one property at a time.
This is painful when dealing with large objects and error prone.
It would be a much better idea to support the use of JsonSerializerSettings to set global behavior for JSON.NET ... just like WebApi and ASP.NET does today.1,073 votes -
Allow Database Level Pricing
I am looking to convert an application from MongoDB to DocumentDB as I would prefer a managed solution but the collection pricing is absurd. The current model has 1 or 2 collections with 10+ GB of data that will grow at high rates but there are another 30 collections or more with most of them having only 10-20 records. Paying a minimum of $25 per collection is out of the question especially for dev workloads. The pricing model would change your development behaviour to just stuff everything in the same collection but then you loose a lot of the ability…
976 votesDatabase level pricing is now generally available. Learn more about it here, https://docs.microsoft.com/en-us/azure/cosmos-db/request-units
-
"Order By" in queries
I cannot find any documentation on what order the data from a query will return.
I would love to be able to explicitly specify an "order by" clause to dictate that order945 votes -
Partitioned Collections with < 10k RU/s
Please allow partitioned collections with fewer than 10k RU reserved.
I really would like to use partitioned collection but according and the pricing model $6/month for each 100 RU seems fair. But the minimum RU/s for partitioned collections are > 10.000 RU/s which is min $600 a month.
752 votesWe are pleased to announce that partitioned collections have an entry point 75% cheaper than before. Instead of provisioning 10,100 RU/sec as a minimum, you can now provision a partitioned collection at 2,500 RU/sec and scale in increments of 100 RU/sec. Partitioned collections enable you to dynamically scale your provisioning from as low as 2,500 RU/sec to millions of RU/sec with no limit on storage consumption.
Please download SDK 1.12.0+ or use the Azure Portal to provision these collections.
-DocumentDB team
-
Support OData Protocol
Since OData is a standard API supported by Microsoft and intrinsically supports JSON, and DocumentDB is JSON-based, it's a good fit. A standard protocol would also greatly increase interop potential, like SQL, which you are supporting.
707 votesThe Table API for Azure Cosmos DB uses ODATA as the primary protocol for querying. See
https://docs.microsoft.com/en-us/azure/cosmos-db/table-introduction
https://docs.microsoft.com/en-us/azure/cosmos-db/tutorial-query-table
https://docs.microsoft.com/en-us/azure/cosmos-db/tutorial-develop-table-dotnetApplications written for Azure Table storage can take advantage of premium capabilities like provisioned throughput, single-digit millisecond latency, global distribution, and automatic secondary indexing.
-
Positional array update via '$' query support
I have posted a question in stackoverflow (https://stackoverflow.com/questions/45057385/azure-cosmosdb-mongodb-update-fields-of-an-specific-element-of-an-object-in-an) related to this issue.
668 votesThis feature is now available. For more information on this feature and our current supported features for MongoDB API, please see, https://docs.microsoft.com/en-us/azure/cosmos-db/mongodb-feature-support.
Thank you for your suggestion.
-
Have DocumentDB in Brazil datacenter
Enable DocumentDB in Brazil Datacenter
670 votesWe’re excited to announce the availability of Azure DocumentDB in the Brazil South region.
Thank you,
Aravind Ramachandran
Azure DocumentDB -
Transparent Data Encryption (TDE)
DocumentDB should support Transparent Data Encryption.
650 votesWe’re excited to announce that Azure Cosmos DB is now always encrypted in rest. See https://docs.microsoft.com/en-us/azure/documentdb/documentdb-nosql-database-security
Thank you,
Aravind Krishna R.
Azure Cosmos DB -
Unique constraint on document properties
While document ID's are unique, I would like a unique constraint on a given property as well. Today, the only ways I see to accomplish this is either with a client-side query or a pre-trigger (also requiring a query).
I'd like a "unique" constraint to be applicable for given property names within a collection.
619 votesPlease check details here https://docs.microsoft.com/en-us/azure/cosmos-db/unique-keys?view=azure-dotnet
- Don't see your idea?