Questions tagged [azure-cosmosdb]

Azure Cosmos DB is Microsoft's fully managed and serverless distributed database with support for NoSQL and relational workloads. It offers global distribution across all Azure regions transparently replicating your data wherever your users are. Develop applications using open-source database engines, including PostgreSQL, MongoDB, and Cassandra. Get automatic scalability, enterprise-grade security, and cost-effective consumption-based pricing.

Azure Cosmos DB is a fully managed, distributed NoSQL and relational database for modern app development. Get single-digit millisecond response times and up to 99.999-percent availability, backed by SLAs. Build cloud-native apps quickly and easily using your preferred tools with support for open-source PostgreSQL, MongoDB and Apache Cassandra. Enjoy automatic and instant scalability, and fast writes and reads anywhere in the world with turnkey data replication and multi-region writes. Gain insight over real-time data with no-ETL analytics using Azure Synapse Link for Azure Cosmos DB.

7404 questions
30
votes
2 answers

WHERE clause on an array in Azure DocumentDb

In an Azure Documentdb document like this { "id": "WakefieldFamily", "parents": [ { "familyName": "Wakefield", "givenName": "Robin" }, { "familyName": "Miller", "givenName": "Ben" } ], "children": [ { "familyName": "Merriam", …
Avinash Gadiraju
  • 723
  • 1
  • 7
  • 16
29
votes
2 answers

Implications of using /id for the partition key in CosmosDb

In the scenario where we have 1000 entries (unique keys) entering cosmos per minute, is it safe to use /id as the partition key? In particular, there is the concept of Logical Partitions…
user2770791
  • 553
  • 1
  • 5
  • 11
29
votes
3 answers

What are the differences between CosmoDB and DocumentDB

As far as I can work out, CosmoDB has the ability to make Graph queries using the Gremlin query language. Apart from that the pricing, marketing etc. all seem the same. It seems strange that they came up with a new product to add Gremlin when they…
Muhammad Rehan Saeed
  • 35,627
  • 39
  • 202
  • 311
29
votes
1 answer

ResourceType Document is unexpected at UpsertDocumentAsync()

I'm new to Azure DocumentDB, and I've immediately run into a problem while trying it out. On the first save in an empty collection, I get the following error: ResourceType Document is unexpected. ActivityId: 29619975-e55a-4f31-a3d1-73d180ba3932 My…
Carvellis
  • 3,992
  • 2
  • 34
  • 66
29
votes
3 answers

How to do a Case Insensitive search on Azure DocumentDb?

is it possible to perform a case insensitive search on DocumnetDb? Let's say I have a record with 'name' key and value as "Timbaktu" This will work: select * from json j where j.name = "Timbaktu" This wont: select * from json j where j.name =…
Codehelp
  • 4,157
  • 9
  • 59
  • 96
28
votes
2 answers

Schema Migration Scripts in NoSQL Databases

I have a active project that has always used C#, Entity Framework, and SQL Server. However, with the feasibility of NoSQL alternatives daily increasing, I am researching all the implications of switching the project to use MongoDB. It is obvious…
jth41
  • 3,808
  • 9
  • 59
  • 109
28
votes
1 answer

Does DocumentDB support the LIKE keyword in queries?

Can we use the LIKE keyword to filter out records as we use it in T-SQL?
Joker_37
  • 839
  • 2
  • 8
  • 20
26
votes
1 answer

DocumentDB Query documents where Array_Length > 1

I have sets of documents that looks like this: [ { "Name": "Document1", "Properties": { "Property1": [ "Value1", "Value2", "Value3", ] }, "Tags": null }, { "Name": "Document2", …
INNVTV
  • 3,155
  • 7
  • 37
  • 71
25
votes
5 answers

Is Azure DocumentDB being renamed?

I've created this post following the indications of the @AzureSupport Twitter account. This morning (May 10th, 2017), while I was managing my Azure Resources I couldn't find my DocumentDB resources anymore. But I noticed this: I was wondering if it…
FabriceMk
  • 385
  • 3
  • 10
25
votes
5 answers

Fastest way to insert 100,000+ records into DocumentDB

As the title suggests, I need to insert 100,000+ records into a DocumentDb collection programatically. The data will be used for creating reports later on. I am using the Azure Documents SDK and a stored procedure for bulk inserting documents (See…
Mark Clancy
  • 7,831
  • 8
  • 43
  • 49
25
votes
3 answers

Single or Multiple Entities Per Collection in DocumentDB

Should there be one entity per collection in document DB? Consider I have foreign key relationship in below diagram: Should I create two collections one for employee & other for company. Or should I store them into a single collection? I read here…
Abhijeet
  • 13,562
  • 26
  • 94
  • 175
25
votes
1 answer

Key differences between Azure DocumentDB and Azure Table Storage

I am choosing database technology for my new project. I am wondering what are the key differences between Azure DocumentDB and Azure Table Storage? It seems that main advantage of DocumentDB is full text search and rich query functionality. If I…
SoftwareFactor
  • 8,430
  • 3
  • 30
  • 34
23
votes
5 answers

Azure Cosmos DB SQL API UPDATE statement - don't replace whole document

Can I write an UPDATE statement for Azure Cosmos DB? The SQL API supports queries, but what about updates? In particular, I am looking to update documents without having to retrieve the whole document. I have the ID for the document and I know the…
Scotty H
  • 6,432
  • 6
  • 41
  • 94
22
votes
10 answers

Azure Cosmos DB input binding for an Azure Function doesn't work

I was following a walkthrough from microsoft learning on how to add an input binding with CosmosDb for an azure function, however when calling the function it keeps returning internal server error (500 http code). The configuration of the azure…
csg
  • 2,047
  • 2
  • 22
  • 35
22
votes
2 answers

How to (should I) mock DocumentClient for DocumentDb unit testing?

From the new CosmosDb emulator I got sort of a repository to perform basic documentdb operations, this repository gets injected to other classes. I wanted to unit test a basic query. public class DocumentDBRepository where T : class { //Details…
Ernesto
  • 1,523
  • 1
  • 14
  • 32