Questions tagged [azure-cosmosdb-tables]

Azure Cosmos DB Table API - used for questions that are using Azure Cosmos DB via the Table API SDK.

59 questions
7
votes
1 answer

Azure Table Get Next Functionality?

What is a good tactic for querying Cosmos DB (Table Storage API) to get the "next" item in Storage? "Next" is defined as the top 1 item that was not returned by the last call. The item that was returned by the last call is being held in memory.…
Snowy
  • 5,942
  • 19
  • 65
  • 119
6
votes
1 answer

Significant performance degration on ExecuteQuerySegmentedAsync between Microsoft.Azure.Cosmos.Table and Microsoft.WindowsAzure.Storage

I've been researching moving from Storage Account table storage to CosmosDB table storage. Currently I am using the WindowsAzure.Storage (9.3.3) library to query data in a .net core 3.1 application. As part of this migration I have switched to the…
Blaine
  • 126
  • 6
3
votes
3 answers

Export Azure Cosmos DB table to CSV

I need to export the data that I have in Azure CosmosDB table to a CSV file. I tried to use ADF but I only found configured for SQL and MongoDB and I am using TABLE STORAGE in COSMOSDB options . Is there an easy or coded way to achieve this?
Cesar Castillo
  • 147
  • 1
  • 4
  • 11
3
votes
1 answer

Azure CosmosDB stored procedure to update all items' field

Let's say we have a container with following items { location:CA, bool: false } { location:CA, bool: false } { location:CA, bool: false } How do we write a stored procedure to query all items and update all item's bool field from…
3
votes
1 answer

The connection string is missing a required property: AccountEndpoint error while using the new CosmosClient(CosmosConnectionString)

I am getting The connection string is missing a required property: AccountEndpoint error while using the new CosmosClient(CosmosConnectionString) constructor for CosmosClient with assembly Microsoft.Azure.Cosmos.Client, Version=3.11.0.0 - How to fix…
3
votes
1 answer

Is it possible to run Comos DB inside docker-compose with Table API option

Azure Cosmos DB has an option called Table API, I'm using it and I really enjoy, but the problem it is that I need to run my environment on docker-compose and I don't know if it's possible. When we are developing, we can use the Azure Comos DB…
2
votes
1 answer

Entity interceptors in Azure.Data.Tables

In the new SDK package - Azure.Data.Tables, how can you intercept the calls done to table storage / cosmos. In the previous package (Microsoft.WindowsAzure.Storage) it could be done through the method IDictionary
2
votes
2 answers

Is there a way to programmatically change TTL on a cosmos db Table

As the title describes, I'm trying to change the TTL of a cosmos db table. I couldn't find anything in c#/powershell/arm templates Here is what I'm trying to achieve The only thing I was able to find is the api call that is triggered in azure…
Kira
  • 1,153
  • 4
  • 28
  • 63
2
votes
2 answers

CosmosDb Partition Key For Nested Java Object/Json (Spring Boot)

I'm trying to partition a collection based on a nested Java object and the corresponding Json. I know it might seem unreasonable to do this, but I am working on a project far into development, and the layout expected by our client team is not…
2
votes
2 answers

Ordering data in Azure Cosmos Table API

Azure Storage Tables have been superseeded by Azure Cosmos Table API at a significantly higher price point but also with new features like automatic secondary indexing. One of the pain points using Azure Storage Tables was, that in order to achieve…
Markus S.
  • 2,602
  • 13
  • 44
1
vote
1 answer

How to alter TBLPROPERTIES in cosmosdb

In cosmosDB, I need to insert a large amount of data in a new container. create_table_sql = f""" CREATE TABLE IF NOT EXISTS cosmosCatalog.`{cosmosDatabaseName}`.{cosmosContainerName} USING cosmos.oltp …
BeGreen
  • 765
  • 1
  • 13
  • 39
1
vote
1 answer

How to update a property in an Entity in Cosmos table API using Python

I have the below table in CosmosDB. PartitionKey Rowkey Group Salary John HR A 100000 Mark DOC B 200000 I want to update the Salary property in the first entity. When I tried to update the salary property in…
SanjanaSanju
  • 261
  • 2
  • 18
1
vote
1 answer

Unable to connect cosmos table api from databricks throws errror

Loaded proper library at cluster level. com.microsoft.azure:azure-cosmosdb-spark_2.4.0_2.11:3.7.0 Gave proper connection strings from cosmos table api cosmosConfig = { "Endpoint" : "https://cosmos-account-name.table.cosmos.azure.com:443/", …
Jaya Prakash
  • 65
  • 1
  • 8
1
vote
0 answers

NotSupportedException using Azure.Data.Tables .NET SDK saving Dictionary

Using Azure.Data.Tables 12.3.0 and trying to save the following sample model I get the error: System.NotSupportedException: Not supported type System.Collections.Generic.Dictionary [System.Guid,System.Guid] at…
Jason Shave
  • 2,462
  • 2
  • 29
  • 47
1
vote
2 answers

Using Managed Identity with Cosmos Db Table Api

I am trying to connect to cosmos db table api using Managed Identity. According to the documentation here, cosmos db supports Managed Identity. I couldn't find any documentation that says anything specific about table api. I am using .Net standark…
1
2 3 4