LogicApp that returns newly generated ID back to original source
Hello I am trying to create a LogicApp that first: Extracts data from CosmosDB, using a query Loops over the results Pushes the results data into CRM Sidenote: Once this data is pushed into CRM, CRM automatically generates an ID for each…
Create mongo collection in cosmos with shared throughput with mongodb .net driver
I have an application which uses a cosmosdb with a mongoAPI. The application connects to the db with the MongoDb .net driver to create collections programatically, however it creates the collections without shared throughput. Is there a way to create a…
Azure Cosmos DB mongo db api: attribute wise count for the records
Hi, I have my data stored in azure cosmos db (Mongo db API), sample of the data is as shown below: currently, i query based on the apptype, my requirement is to show the count of each attribute as well. eg: in the example below, there are two…
Azure Cosmos DB - Portal - Error 449 Retry on container creation
Hi there, I try to create a CosmosDB container on my Azure portal. For each attempt, an error 449 is thrown.. We have been adding containers frequently in the last months to this Database. With the API, same result. What could causing this ? …
DDL opertaions against Azure Cosmos DB Cassandra API from Spark
Hi, I'm having very strange behavior on DDL operations against Cosmos DB w/ Cassandra API from Spark running in Databricks. When creating a keyspace and table as the following, it does execute the create statements with no errors, BUT it really…
Logic App Twitter Connector and Multiple User Names with CosmosDB
Is there a way to have a Logic App or something similar trigger when a tweet is posted by a list of users from Cosmos DB? So many choices and articles, they all show hardcoded search terms. I need some guidance :-)
Cosmos DB. Why it is getting stuck?
Hi there In my Blazor Server the following code line just get stuck: container = await database.CreateContainerIfNotExistsAsync(typeof(T).Name, partitionId); T is my business class, partitionId is "/FacilityId". It just release the main…
How to write a Json file from a csv file
Hello I have got a csv file with an array inside, I need to create a sink data file(json) to be loaded within Cosmos DB, any idea about how to do it? With the csv files i dont have any problem to upload within cosmosDb because I didn't have any…
Azure portal cosmos db page layout problem
Hello, this morning i have gone into the azure portal for viewing the contents of cosmos db containers. There now appears to be a large blank panel on the right of the screen which means that the area for viewing the data is now squashed to a few…
Cosmos DB Migration Tool - SQL Database to Cosmos DB
Hi there, I have data saved in SQL Database, which I'm migrating. I used to save Lat and Lon into a separate column, but for the new implementation, I'm saving lat and lon as GeoJSON point. While migration, I want to save Lat and Lon as GeoJSON on…
Can't connect to CosmosDB using Cqlsh
Following is the configuration I have In cassandra.yml file content client_encryption_options: require_client_auth: false protocol: TLSv1.2 cqlshrc.sample.ssl file content [authentication] username = username password = password …
Is Apply Free Tier Discount valid when creating an Azure Cosmos DB account with the Azure CLI?
I would like to create an Azure Cosmos DB account with Apply Free Tier Discount enabled using the Azure CLI. However, I didn't find any information that could be set as a parameter, even when I looked at the latest Azure CLI documentation. Is Apply…
CosmoDB Handling Request Throttling
Hi there, I'm wondering, how can I properly handle a throttled request, I have forever tried in my Polly, But I'm still getting throttled requests. https://pasteboard.co/Jev0xcQ.jpg Thanks
Cosmos DB Group By
Hi there, We have a requirement, where each of our equipment are sending data and we have to get the first data point of each day and we have to compare it with some other data. So when we are calling the SDK for data I want group the all the equipment…
CosmosDB NodeJS SDK query Timeout
Hello, I am having an issue with a timeout using the Cosmos NodeJS SDK within an async Azure function (HTTP Trigger). I followed the tutorial found here to build the same example. Is this an issue with the async flow or the Cosmos connection? My code…
List Usage API for DB Account is not working Properly
Hi Team , I was using below API to fetch the usages of the DB Account, I was not really successful for fetching the Document Count and other custom filter parameters (Index Size,Storage Capacity)... It is working only for Storage Metric which is…
Azure Data Factory Data Copy from Cosmos
We have one scenario, where we have to transfer/copy newly added/updated data from cosmos dB to a SQL Server every 2 hours. Currently, data copy copies all the files, can I configure to only copy the newly added/updated ? Thanks
Logic Apps and CosmosDB - Partition Key Troubles
Hello and thanks for reading! I am trying to migrate from an Azure Table Storage instance to CosmosDB as the backing store for my logic app. The logic app is a webhook from Azure DevOps that records selected release information into a table. I've…
Composite index on nested field
I'm having an issue creating a composite index on a nested field in our collection. Is this even possible? { "indexingMode": "consistent", "automatic": true, "includedPaths": [ { "path":…
Status code 449 on read-only workload
I am running a batch process using version 3.8 of the .Net core client SDK to access Cosmos DB with an entirely read-only workload; no write operations are occurring on the cosmos account at the time this process is running. In the metrics reports in…