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
1
vote
1 answer

Is there a way to set item level TTL(Time-To-Live) with CosmosDb utilizing the Table (azure-storage) client API?

I am using CosmosDb for a project, and was first trying the Document-db java SQL API. With that API I can set item-level TTLs right on the Document itself. Ex. Document document = new Document(new Gson().toJson(testObject)); …
1
vote
2 answers

CosmosDB Table API - CORS rules are not supported for this API

We have some Azure Table storage tables in our subscription and would like to migrate them to CosmosDB table API due to performance reasons. To do this, I started creating cosmos db account by selecting Table API but my deployment failed with the…
AngiSen
  • 915
  • 4
  • 18
  • 41
0
votes
0 answers

Querying Azure Table API - Is there a performance difference in Paged vs Non-paged enumeration?

I am using the Azure.Data.Tables.TableClient to query data from my database. // Create table client var tableServiceClient = new TableServiceClient(connectionString, _tableClientOptions); avr tableClient =…
Nikhil Girraj
  • 1,135
  • 1
  • 15
  • 33
0
votes
1 answer

Azure Cosmos DB interaction works from WinForms, but fail from Azure Cloud Service in C#

When I interact with CosmosDB from Azure Cloud Service I am getting 'Forbidden' on each call that deals with data in the table. Even creating a table is 'Forbidden' from inside the service. The same code works perfectly from the WinForms…
Kajko
  • 23
  • 7
0
votes
0 answers

Create a new entity in Azure cosmosDB Table API using postman

I am able to get the list of collection from my cosmosdb by postan via api like: https://mycosmosdburl/dbs/TablesDB/colls I get the list, but I am not able to find end point for creating a new entry in my table. When I try to post my entry in the…
PM.
  • 1,735
  • 1
  • 30
  • 38
0
votes
0 answers

Reading data from Cosmos Table API into Pandas dataframe

I am using the below code to read the data from CosmosDB table API into a dataframe. import pandas as pd from azure.cosmosdb.table.tableservice import TableService CONNECTION_STRING = "" SOURCE_TABLE = "table_name" def set_table_service(): …
0
votes
1 answer

Azure CosmosDB write latencies for different APIs

We have a low-latency use case for Azure CosmosDB (eg. adding extra 100ms will be sensitive to the application). Are there any implications on write latency when choosing an Azure CosmosDB API -- Core SQL is default, but perhaps there are some…
0
votes
1 answer

How to migrate data from local storage to CosmosDB Table API?

I tried following the documentation where I'm able to migrate data from Azure Table storage to Local storage but after that when I'm trying migrating data from Local to Cosmos DB Table API, I'm facing issues with destination endpoint of Table API.…
0
votes
1 answer

Using Cosmos DB Table API to query for a datetime range

I am using Cosmos DB Table API to manage my data(Using SQL API is not an option). I have used "Creation DateTime Ticks" as the "PartitionKey". The idea is to retrieve data in every half an hour. To get the new data in half an hour range, I wrote a…
0
votes
1 answer

Type DocumentClient exist in both Microsoft.Azure.DocumentDB.Core and Microsoft.Azure.Documents.Client

I have installed NuGet package Microsoft.Azure.Cosmos.Table in my existing project, then few errors occured like "the type DocumentClient exist in both Microsoft.Azure.DocumentDB.Core Version 2.11.2.0 and Microsoft.Azure.Documents.Client version…
0
votes
1 answer

How to: Azure python function triggered by Azure CosmosDB Table updates (new item/modified item/delete item)

I'd like to get an Azure Function working where the function gets triggered on every new item, modify of an existing item, or deletion of an item in the CosmosDB. The documentation i've been able to find so far is always about CosmosDB functioning…
Marco
  • 525
  • 4
  • 17
0
votes
1 answer

How to call dynamic values in Azure Functions parameter

I have an Azure Function which triggers on service bus topic and its going to copy data from blob storage to Azure Cosmos Db Table Api. Depending on the file name in Azure Blob storage, the file data will be copied as entity to respective table in…
Ankit Kumar
  • 476
  • 1
  • 11
  • 38
0
votes
1 answer

Error while reading data from azure table storage

I'm writing a code to read values from a table storage. The code is similar to printing nodes in a tree level by level. eg: root Level1child1 -> Level1child2 -> Level1child3 string tablename = "; string storageAccountName =…
user989988
  • 3,006
  • 7
  • 44
  • 91
0
votes
2 answers

How to get Connection string of a cosmos DB created for table API in ARM template

I am trying to create a cosmos db account for table APIs and want to upload the connection string to a KV using ARM template. I expect the connection string in this…
0
votes
1 answer

How to write Azure storage table queries for non-existent columns

We have a storage table where we want to add a new integer column (It is in fact an enum of 3 values converted to int). We want a row to be required when: It is an older row and the column does not exist It is a new row and the column exists and…