Questions tagged [azure-cosmosdb-sqlapi]
1222 questions
-2
votes
1 answer
How can this data model be designed that does not hit the 20gb logical partition limit in Cosmos DB?
I am going with a single table design for a chat application in Azure Cosmos db. I have my access patterns setup, just want to check here if I am in the right direction.
Below are the few things that concerns me
I have heard about a hard limit of…
Sumchans
- 3,088
- 6
- 32
- 59
-2
votes
1 answer
Error while creating SQL API container on the Azure portal
I received below error message while creating new SQL API container. It's working last week.
Error creating database: "{\"code\":\"Forbidden\",\"message\":\"Message: {\\"code\\":\\"Forbidden\\",\\"message\\":\\"Message:…
Ravi
- 1
- 1
-2
votes
1 answer
Azure Cosmos DB - How 20 GB data stored in one collection with no Partition key?
As we know there is a 10 GB size limit of each logical partition key in the collection. I haven't created any partition key for my collection but i can see 20GB data stored in that collection.
Rakesh Kumar
- 2,701
- 9
- 38
- 66
-2
votes
1 answer
I need to perform a "ORDER BY", but Azure says it is not supported
Below is my sample:
SELECT f.id as family, c.FirstName AS child, p.GivenName AS pet
FROM Families f
JOIN c IN f.Children
JOIN p IN c.Pets
WHERE p.GivenName =…
pefs
- 59
- 1
- 4
-2
votes
2 answers
How to change throughput value of existing azure cosmosdb collection?
I want to reduce the throughput value of existing azure cosmos db collection using this rest API and it's giving a bad/unauthorized error. Kindly help me calling the API with proper…
Nadhas
- 5,421
- 2
- 28
- 42
-2
votes
1 answer
How do I call a spatial query in CosmosDB for ST_WITHIN
I am trying to write a function which will return if a point is inside a Polygon or not using CosmosDB SQL API
I have tried to write a SQL statement, however that didnt work, so now I would like to use linq to someone write something.
I have Polygon…
bobD
- 89
- 1
- 8
-3
votes
1 answer
Disable Schema Validation for Cosmos DB?
I'm using Cosmos DB in Azure. I recently changed the schema to add more information. However, I'm confused because Cosmos uses SQL to query the database. Further, it seems I can't query based on the new schema because I receive the following error…
Timothy Pulliam
- 132
- 1
- 9
- 25