Stack Overflow
Stack Overflow

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
90
votes
8 answers

Azure Cosmos DB - Understanding Partition Key

I'm setting up our first Azure Cosmos DB - I will be importing into the first collection, the data from a table in one of our SQL Server databases. In setting up the collection, I'm having trouble understanding the meaning and the requirements…
Stpete111
  • 3,109
  • 4
  • 34
  • 74
52
votes
8 answers

Get record count in Azure DocumentDb

It seems like 'select count(*) from c' in the SQL queries allowed by documentdb in the azure site and through the documentdb explorer (https://studiodocumentdb.codeplex.com/) is not supported. To date, the only way to get a record count that I have…
ProgramTheWorld
  • 537
  • 1
  • 4
  • 6
50
votes
3 answers

Check if field exists in CosmosDB JSON with SQL - nodeJS

I am using Azure CosmosDB to store documents (JSON). I am trying to query all documents that contain the field "abc", and not return the documents that do not have the field "abc". For example, return the first object below and not the second { …
JDT
  • 965
  • 2
  • 8
  • 20
44
votes
1 answer

Azure Table Storage vs CosmosDB Table API

In Microsoft Build 2017 event, I came across CosmosDB Table API. It looks like Azure Table Storage. Does it mean Microsoft is going to stop supporting Azure Table Storage eventually? Now, Document Db is no more. It has been converted to CosmosDB…
Venkata Dorisala
  • 4,783
  • 7
  • 49
  • 90
43
votes
5 answers

Microsoft Azure DocumentDB vs Azure Table Storage

For several recent years, Microsoft offers a "NoSQL" key/value storage, called "Table Storage" (http://azure.microsoft.com/en-us/documentation/articles/storage-dotnet-how-to-use-tables/) Table Storage offers a high performance, scalability (via…
Illidan
  • 4,047
  • 3
  • 39
  • 49
42
votes
6 answers

Azure DocumentDB Owner resource does not exist

I having the same error icrosoft.Azure.Documents.DocumentClientException: Message: {"Errors":["Owner resource does not exist"]} , this is my scenario. When I deployed my webapp to Azure and try to get some document from docDb it throws this error.…
user1301722
  • 423
  • 1
  • 4
  • 4
40
votes
2 answers

How to write a LIKE query in Azure CosmosDB?

I want to retrieve data from Cosmos DB with the following query: SELECT * FROM c WHERE c.pi like '09%001' (This is a SQL query, which I can use in MySQL) Here, pi is a string value, which can be 09001001 or 09025001. Is there a way to use a LIKE…
arjan kroon
  • 813
  • 2
  • 9
  • 22
40
votes
7 answers

Cosmos DB - Deleting a document

How can I delete an individual record from Cosmos DB? I can select using SQL syntax: SELECT * FROM collection1 WHERE (collection1._ts > 0) And sure enough all documents (analogous to rows?) are returned However this doesn't work when I attempt to…
Ben Mayo
  • 1,285
  • 2
  • 20
  • 37
40
votes
1 answer

.NET - c# - Cross partition query is required but disabled trouble on DocumentDB data access

I have written the following code to fetch a record from the DocumentDB private static void QueryDocuments1(DocumentClient client) { IQueryable queryable…
Prasanth V M
  • 493
  • 1
  • 5
  • 10
34
votes
1 answer

Syntax for Azure Cosmos DB CONTAINS

I have the following JSON Store on Azure Cosmos DB. { "id": "4", "total": 10.46, "tax": 0.55, "soldItems": [ { "item": "CHEESE NIPS 004400001300 F 1.97 D", "price": 1.97 }, { "item": "ROOT BEER 10.46", …
amy8374
  • 1,450
  • 3
  • 17
  • 26
33
votes
4 answers

Query CosmosDb - where array contains item(s) from array

I don't know if there is a word for this, guess there is, but right now I couldn't explain it better than "where array contains item(s) from array". It might sound weird, but actually it not (I think), and I'm having a hard time figuring out how I…
Mads Laumann
  • 833
  • 2
  • 9
  • 16
33
votes
1 answer

Delete all/multiple documents from Azure Cosmos DB through the portal

Is it possible to delete all/multiple documents available in a collection through the azure portal, Azure cosmos SQL Query or a power shell script ?
armadillo.mx
  • 934
  • 1
  • 11
  • 17
33
votes
6 answers

Delete Documents from CosmosDB based on condition through Query Explorer

What's the query or some other quick way to delete all the documents matching the where condition in a collection? I want something like DELETE * FROM c WHERE c.DocumentType = 'EULA' but, apparently, it doesn't work. Note: I'm not looking for any…
GorvGoyl
  • 42,508
  • 29
  • 229
  • 225
31
votes
6 answers

What does it mean that Azure Cosmos DB is multi-model?

Looking at the new Azure cosmos database, I'm a bit confused about the multi-model nature of it. Specifically, does it mean: a) That the same underlying database/store can be queried multiple ways concurrently so that I can use both gremlin graph…
MonkeyBonkey
  • 46,433
  • 78
  • 254
  • 460
31
votes
5 answers

C# LINQ .Any not working on DocumentDb CreateDocumentQuery

I'm trying to query Art that has a product of a certain type. Here is my model for Art: public string Title { get; set; } public string Description { get; set; } public List Products { get; set; } public string PaintedLocation {…
gregwhitworth
  • 2,136
  • 4
  • 22
  • 33
1
2 3
…
99 100