Questions tagged [cosmos-db]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
34 views

Handling feed and feed subscriptions with document database

I have a data feed that contains channels that users can subscribe to. It's similar to Facebook or LinkedIn where each channel is a topic and users can subscribe to as many channels as they like and ...
Sam's user avatar
  • 113
0 votes
1 answer
14 views

How to connect in case Azure Cosmos DB default force use TLS/SSL?

My case: Client: Windows 10 x64. pgAdmin 4 version 8.4 (latest). Server: Cloud Azure Cosmos DB for PostgreSQL burstable, version 16. My connection string will be likes this jdbc:postgresql://c-...
Vy Do's user avatar
  • 209
1 vote
0 answers
37 views

MongoDB: Queries running 3x slow on Azure Serverless Mongodb compared to MongoDb Atlas Free Tier server

I have a database in MongoDB Atlas using the free tier package. I recently transferred my data to Azure Serverless CosmosDB for MongoDB using mongoexport. After the data transfer, I've noticed that ...
Veli Eroglu's user avatar
1 vote
0 answers
50 views

How to efficiently manage large amount data in Web apps

I am developing an application that needs to store a large amount of product data and display it in a web app. The data is generated every day, and each product will have approximately 100 rows per ...
Flow's user avatar
  • 11
0 votes
0 answers
111 views

Linked service: SQL Server-2019 to Cosmos DB

I have created linked service for importing data from Azure cosmos DB to on-prem MS-SQL-2019. Services created from SSMS and test connection is successful, but query is getting error. Query: select * ...
maverick_1's user avatar
1 vote
1 answer
285 views

Product Object for Ecommerce in NoSQL

I'm working on an ecommerce app that will be using a NoSQL document database. I want to have a general purpose product that can be used for different types of products, ranging from coffee to ...
Sam's user avatar
  • 113
2 votes
1 answer
813 views

How to store and query a tree structure in Cosmos DB?

I'm migrating a relational DB over to Cosmos DB and am unsure about a tree structure. There are several thousand rows of data ("Offerings") where each offering can have child items arranged ...
Krumelur's user avatar
  • 121
2 votes
2 answers
3k views

Choosing values from multiple columns based on latest value of one column

I have an Azure Cosmos DB that contains columns DateTime, userName, temperature, and bloodPressure, plus many other columns. There are several distinct userName values, and each userName has ...
KAE's user avatar
  • 143
3 votes
1 answer
2k views

Getting Nested query result from Cosmos DB with property named "Value"

I have Cosmos Db collection, I am trying to query the "Key" "Value" pair from. Working query: SELECT ed From c JOIN ed IN c.ExtendedData Where ed.Key = "MembershipTypeId" And got result: [ { ...
Kseniya Goloshchapova's user avatar
4 votes
0 answers
857 views

What is the right way to increment like/comment counters on CosmosDB?

I'm currently working on a new app which will use a NOSQL DB (particularly Cosmos DB) for data scalability. I need to implement a way to update counters every time a post receives a like or comment. ...
user246392's user avatar
1 vote
0 answers
167 views

Designing a globally distributed database

We are trying to design a globally distributed Azure Cosmos DB and we’re not sure how to best do that: There is data that should be replicated in every region to improve read performance. This data ...
Tur1ng's user avatar
  • 119
1 vote
1 answer
4k views

Parameter value in Data Factory Triggered pipeline

I have a pipeline configured in azure data factory which basically does create a backup file (JSON) from a cosmosDB dataset and it's saved in a blob storage, my problem comes when I want to schedule ...
user avatar
0 votes
1 answer
766 views

Local Cosmos DB service unavailable

I've installed the azure cosmos db in my local machine but is not loading the explorer pages as shown below: Explicit error: Failed to get authorization headers for offers: {"readyState":4,"...
user avatar
1 vote
1 answer
6k views

Structuring change history data in MongoDB / NoSQL

I have a Chart on which I need to track changes; the Chart has several properties. A Chart also has a long list of items. So in C#, my Chart object looks like this: public class Chart { public ...
Targaryen's user avatar
  • 113
2 votes
1 answer
420 views

Cosmos DB ODBC driver installation problem

We are trying to install Cosmos DB ODBC Driver following the instructions provided in this Microsoft Azure resource and are running into the following error: The setup routines for Microsoft ...
Ben Saunders's user avatar