Azure Cosmos DB
An Azure NoSQL database service for app development.
Unable to see data on cosmos DB's container
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 74%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAW%3C/text%3E%3C/svg%3E)
Ananta Wakde
1
Reputation point
Hi everyone,
I have established a connection between IoT Hub, Stream Analytics and Cosmos DB. Means, I have set input and output for stream Analytics as IoT Hub and Cosmos DB respectively. I send data from simulator. That data go into IoT Hub then after Stream Analytics then Cosmos DB.
Data are coming to cosmos DB correctly but when I am fire a query i.e. SELECT * FROM TruckContainer
then data doesn't see on Data Explorer tab. It seems like this.
And I have cross checked that data is coming into Cosmos DB or not then I see overview tab's matrix for incoming request then it look like this.
Then I know that data is coming into Cosmos DB.
Then my question is what I am doing wrong so that I can't see data?
Azure Cosmos DB
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SSingh-MSFT 16,461 Reputation points Moderator2022-11-16T09:20:17.297+00:00 Hi @Ananta Wakde ,
Welcome to Microsoft Q&A platform and thanks for using Azure services.
As per you question, Cosmos DB items inside the container are not visible.
Could you please check the below:
1). Check if TTL is enabled in your DB account.
2). If you have added your IP is using Firewall. Refer how-to-configure-firewallPlease try and let us know if this helped. Do let us know if further queries.
-
Ananta Wakde 1 Reputation point
2022-11-16T09:43:58.357+00:00 1) TTL is OFF for DB account.
2) I don't add any IP while configuring my DB account or any other place.
One thing that I want to tell you I am using free tier Azure Cosmos DB account so, they provide me 1000RU/s and 25 GB of storage. -
SSingh-MSFT 16,461 Reputation points Moderator
2022-11-17T06:53:14.293+00:00 Hi @Ananta Wakde ,
Could you please check the Storage metrics to check if quota is reached as it involves IoT Hub, Stream Analytics:
Reference Link: monitor-reference
Let us know your observation.
-
Ananta Wakde 1 Reputation point
2022-11-17T08:45:13.813+00:00 Hi @SSingh-MSFT ,
As you mention, I checked the metrics for Storage and Data Usage. In my Cosmos DB account, here is a screenshot of both metrics
And My account limit is first 1000 RU/s and 25 GB of storage. I think, I reached the limit so I am not able to see the data.My doubt is how to solve this problem? so that I can see the data on Cosmos DB Data Explorer tab.
-
SSingh-MSFT 16,461 Reputation points Moderator
2022-11-21T06:10:39.397+00:00 Hi @Ananta Wakde ,
You should consider changing the tier for larger storage size as per your requirement.
Thanks. Have a good day!
-
Ananta Wakde 1 Reputation point
2022-11-21T06:20:16.76+00:00 Hi @SSingh-MSFT ,
Yes, you are correct but I can't change the tier of my DB account. Because it is a company decision where I am working. So, please can you tell me the other option(s) that I can implement.
Thanks for helping me throughout the process... -
SSingh-MSFT 16,461 Reputation points Moderator
2022-11-22T11:38:24.077+00:00 Hi @Ananta Wakde ,
Please raise support ticket to get assistance on this question. Let us know if you need help. Thanks
Sign in to comment
Sign in to answer