Using MongoDB in Azure DocumentDB with .NET driver throws MongoCommandException
I am using Azure DocumentDB to manipulate a MongoDB collection.
I have a 1000 RU/s limit according to my Azure Standard plan.
The issue I experience occurs when I try filtering and sorting some data from my MongoDB collection.
Here … Read the rest “Using MongoDB in Azure DocumentDB with .NET driver throws MongoCommandException”
Meteor using Azure MongoDB
Is it possible, and if so how, to use an Azure MongoDB as the backend for my Meteor Application.
I have added the connection string from my database into the MONGO_URL variable with no success. I have found some previous threads over Stack Overflow and on … Read the rest “Meteor using Azure MongoDB”
Azure DocumentDB: order by and filter by DateTime
I have the following query:
SELECT * FROM c
WHERE c.DateTime = “2017-03-20T10:07:17.9894476+01:00” AND c.DateTime < = "2017-03-22T10:07:17.9904464+01:00"
ORDER BY c.DateTime DESC
So as you can see I have a WHERE condition for a property with the type DateTimeand I want to sort my result by the same one.
The query ends with the following error:
Order-by item requires a range index to be defined on the corresponding index path.
I have absolutely no idea what this error message is about 🙁
Has anybody any idea?
You can also do one thing that don’t require indexing explicitly. Azure documentBD is providing indexing on numbers field by default so you can
… Read the rest “Azure DocumentDB: order by and filter by DateTime”
how can i index bool property in document db
I’ve read Azure DocumentDb Indexing Policies.
There is no mention of how to index a bool property. Without any Json formatting wizardry the properties get written to doc db like “prop name”: true
Do I need to output as a number?… Read the rest “how can i index bool property in document db”
In documentdb can i join across collections and update partition key for document
I just added a partition key while creating collection which is “/countryId”.
is it possible to update countryId for document ?
can i join across collections in documentdb ?
… Read the rest “In documentdb can i join across collections and update partition key for document”
DocumentDB Permissions on Collections
In my design I want to use DocumentDB as a back-end for my multi tenant SAAS application.
As the data per tenant can be 10gb I want to use a collection per tenant model.
The requirement is how can I ensure data isolation in my application. … Read the rest “DocumentDB Permissions on Collections”
DocumentDB Trace listener
I’m trying register DocumentDB tracing with an existing listener. The code snippet below properly traces a single message to my expected listener but not the actual traces generated by the DocumentDB C# client. Am I missing something?
Snippet from Global.asax:
private static TraceSource DocDBSource;
private static TraceListener … Read the rest “DocumentDB Trace listener”
Azure Functions and DocumentDB triggers
Is it possible to specify the DocumentDB is to fire triggers when writing to DocumentDB?
I have an Azure function that pulls JSON messages off a Service Bus Queue and puts them into DocumentDB like so:
public static string Run(string myQueueItem, … Read the rest “Azure Functions and DocumentDB triggers”
filtering DocumentDb collection from Data Factory using unix-timestamp
I am trying to select some documents from documentDB collection, in an incremental way, so every slice will select based on the “timeCreated” field of the collection.
The problem is that this field (timeCreated) is in seconds since the epoch (1970-01-01) and … Read the rest “filtering DocumentDb collection from Data Factory using unix-timestamp”
How to create composite partition key in documentdb
This is how my document looks, I wanted to choose the partition key as /department/city; which is two different attribute, one form employee and another from address(which is an embedded object to employee). I tried give /department/address as partition key but it’s … Read the rest “How to create composite partition key in documentdb”