Stack Overflow
Stack Overflow

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
0 answers

Double data type is returned as int32 in Azure cosmos table api using @azure/data-tables sdk

I am trying to list the entities in an Azure Cosmos table API table. I have an entity whose property is of data type double when it is created using the node sdk @azure/data-tables. But when I try to list it using the same sdk, the data type of that…
Ranjith Eswaran
  • 333
  • 2
  • 12
1
vote
1 answer

Can I create dynamically a table for a serveless Azure CosmosDB (Azure Table)?

i'm making a migration from Table Storage to Cosmos DB. I've created a serveless Cosmos DB (Table Azure) When i execute the below code CloudTable table = _client.GetTableReference(tableName) await table.CreateAsync(); i'm getting an error…
Fly_federer
  • 206
  • 1
  • 2
  • 12
1
vote
2 answers

Method not found: 'System.Threading.Tasks.Task`1

Getting below error when trying to insert into CosmosDb. Document is being inserted but throwing this error. I'm using .net core 5.0, Microsoft.Azure.Cosmos 3.17.0. Please advise. Method not found:…
Raj
  • 21
  • 4
1
vote
0 answers

Cosmos db Table API SSIS component or ODBC connector?

I have a Cosmos DB Table API entity and i can't figure out how to export the data whether I use SSIS or an ODBC connector. I want to export into a datawarehouse and connect to tables in the on prem DW. I see one can setup a linked server but that…
jps
  • 11
  • 1
1
vote
1 answer

Cosmos DB : Faster Search Options

We have huge cosmosDB container with billions of rows and almost 300 columns. Data is partitioned and modeled in a way we query it most of the time. For example : User table is partitioned by userId thats why below query works fine. Select * from…
user837593
  • 337
  • 1
  • 5
  • 25
1
vote
1 answer

How do I filter specific rows in Azure Tables using python SDK

I have data in a Azure storage table with the following schema: PartitionKey TimeStamp Name .. ... ... I want to return all entities with name starting with mem. I am trying to achieve this in python. I…
Sam Radhakrishnan
  • 681
  • 1
  • 5
  • 19
1
vote
1 answer

CosmosDB per item ttl setting throwing exception: Cannot deserialize the current JSON object

I am following this documentation to set per item ttl to a CosmosDB table entries. But when I add a field name ttl in the entity class I am facing the below error while making Insert/Replace calls: Cannot deserialize the current JSON object (e.g.…
Sayantan Ghosh
  • 998
  • 2
  • 9
  • 29
1
vote
1 answer

How to compare default Timestamp property in a cosmos DB table

The cosmos DB table entry manages a default Timestamp property for each table operation. While I am trying to query last updated entries based on the same time stamp field the result is not behaving as expected. The TableQuery looks like…
Sayantan Ghosh
  • 998
  • 2
  • 9
  • 29
1
vote
1 answer

Cost associated with Azure Cosmos DB

What is the cost associated with Azure Cosmos DB? Does the bill depend upon the database or containers we create? Also, does the bill depend on when we read/write data to containers or starts billing from the time we create Azure Cosmos DB? If…
user989988
  • 3,006
  • 7
  • 44
  • 91
1
vote
1 answer

How To Update Record in Cosmos Db using python?

I want to read record from cosmos db and update same record in cosmos db using python. example: { "id":"id-1", "name":"mohit" } I want to read the above record and update it to. { "id":"id-1", "name":"Mohit Singh" } I find few link but…
Mohit Singh
  • 401
  • 1
  • 10
  • 30
1
vote
1 answer

Microsoft.Azure.Cosmos.Table - How could I retrieve an item operation status if it is inserted or merged using insertOrMergeOperation?

I'm recently using the Microsoft.Azure.Cosmos.Table API and I noticed there was a great method called InsertOrMergeOperation, however, I am wondering if there is any way that the return result could tell me whether my entity just did an insert or a…
Drex
  • 3,346
  • 9
  • 33
  • 58
1
vote
1 answer

How to connect to the CosmosDB Emulator's table storage using python?

I'm running the Azure CosmosDB Emulator locally, and I wish to use the Table interface from Python. Microsoft provides the azure-cosmosdb-table python sdk for connecting to the Table API [1]. I cannot get connections working successfully to the…
josteinb
  • 1,892
  • 2
  • 18
  • 32
1
vote
1 answer

How to log RequestCharge for Cosmos DB CountAsync and MaxAsync operations when we don't get metrics for the respective functions?

There doesn't seem to be a metric for CountAsync and MaxAsync operations of Cosmos DB. Does anyone know a better way to log Request Charge for these operations?
veenu aggarwal
  • 11
  • 3
1
vote
1 answer

How to avoid startup latency for Azure Table Storage/Cosmos DB Table API on .Net Core

Microsoft documentation here suggests to use await client.OpenAsync(); to avoid startup latency to Cosmos DB. This seems to be only applicable to SQL API. I try to use Table API and could not manage to do the same. My first request executes in 1500…
Ilya Chernomordik
  • 27,817
  • 27
  • 121
  • 207
1
vote
2 answers

Provision throughput on Database level using Table API in cosmos db

I have come across the requirement where I have to choose the API for Cosmos DB. I have gone through with all API's like SQL,Graph, Mongo and Table. Since my current project structure is based on Table storage where I am storing IoT Device data. In…
JARVIS
  • 765
  • 1
  • 8
  • 28
1
2
3 4