AdminAzure Cosmos DB Team (Product Manager, Microsoft Azure)

My feedback

  1. 6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Storage » Storage Explorer  ·  Flag idea as inappropriate…  ·  Admin →

    This falls under the Azure Storage Team. Changing category.

  2. 4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Azure Cosmos DB » SQL API  ·  Flag idea as inappropriate…  ·  Admin →

    Hello. Have you seen this article? I think this may be what you are looking for.

    https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-sql-subquery

    Let us know and thanks!

  3. 10 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Azure Cosmos DB » Other  ·  Flag idea as inappropriate…  ·  Admin →

    Hello Daniel.

    Yes, on our Control Plane we are adding a number of improvements that should be coming out over the next few months which should provide this level of control.

    Thanks!

  4. 128 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Azure Cosmos DB » Other  ·  Flag idea as inappropriate…  ·  Admin →
    AdminAzure Cosmos DB Team (Product Manager, Microsoft Azure) commented  · 

    We are still reviewing this as there are a number of dependencies and teams involved. We will update the status here as this progresses.

    Thanks.

  5. 3,842 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    128 comments  ·  Azure Cosmos DB  ·  Flag idea as inappropriate…  ·  Admin →

    Reopening this user voice item as our support for Skip/Take (Offset/Limit) was only limited to single partition queries.

    Update.

    The newly released .NET SDK v3 now includes support for x-partition queries using Offset/Limit. You can learn more about v3 SDK and try it and provide feedback on our github repo here.
    github.com/azure/azure-cosmos-dotnet-v3

    We will also be back-porting this functionality to our .NET v2 SDK. This work will begin shortly and we anticipate it to be released in September.

    Once that is released we will mark this feature as complete.

    Thank you for your patience and votes.

    AdminAzure Cosmos DB Team (Product Manager, Microsoft Azure) commented  · 

    We can't give an exact date but this is actively being worked on now and expect soon.

    Thanks!

    At this time, I can say we are working on some foundational pieces which will light up skip/take in future.

  6. 89 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Azure Cosmos DB » MongoDB API  ·  Flag idea as inappropriate…  ·  Admin →
    AdminAzure Cosmos DB Team (Product Manager, Microsoft Azure) commented  · 

    Pretty much all of $text functionality (and more) has been implemented in Azure Search and we're happy to let you know that it now supports for MongoDB API collections (in private preview). Working with MongoDB collections is very similar to working with SQL Cosmos DB collections as described in https://docs.microsoft.com/azure/search/search-howto-index-cosmosdb

    To create a MongoDB datasource, POST an HTTP request as shown below:

    POST https://[service name].search.windows.net/datasources?api-version=2016-09-01
    Content-Type: application/json
    api-key: [Search service admin key]

    {
    "name": "mymongodbdatasource",
    "type": "documentdb",
    "credentials": {
    "connectionString": "AccountEndpoint=https://<Your Cosmos DB account name>.documents.azure.com;AccountKey=<Your Cosmos DB account key>;Database=<Your database>;ApiKind=MongoDb"
    },
    "container": { "name": "<Your collection>", "query": null },
    "dataChangeDetectionPolicy": {
    "@odata.type": "#Microsoft.Azure.Search.HighWaterMarkChangeDetectionPolicy",
    "highWaterMarkColumnName": "_ts"
    }
    }

    Note:

    1. Use `documentdb` as the data source type.
    2. Do not use a MongoDB connection string that you would use in your MongoDB application. Instead, construct the connection string as shown above. Make sure to add **ApiKind=MongoDb** to the connection string.

    Once you've created the data source, follow the steps in https://docs.microsoft.com/azure/search/search-howto-index-cosmosdb to create a search index, create an indexer, and monitor the indexer execution.

    ## Known issues and limitations

    1. Only the REST API is supported. For now, you cannot create or edit MongdoDB data sources using Azure Portal or Azure Search .NET SDK. However, you **can** monitor execution history of MongoDB indexers in the portal.

    2. Custom queries are not supported: `container.query` parameter must be set to null or omitted. If you need to use a custom query, please let us know at the emails below.

    If you encounter any issues, please contact azscustquestions@microsoft.com

    AdminAzure Cosmos DB Team (Product Manager, Microsoft Azure) commented  · 

    Currently, simple text search is provided through $regex operator. More comprehensive text search is coming shortly through Azure Search that will be able to index MongoDB API collections as well: https://feedback.azure.com/forums/263029-azure-search/suggestions/18861421-documentdb-indexer-should-be-able-to-index-mongodb

Feedback and Knowledge Base