Azure Cosmos DB Table API - used for questions that are using Azure Cosmos DB via the Table API SDK.
Questions tagged [azure-cosmosdb-tables]
59 questions
0
votes
1 answer
How to set TTL value for a table in Azure Cosmos DB?
Does Azure Cosmos DB support setting a TTL for a Table? How can we set that from code while creating the table with CreateIfNotExists call? (I am using Microsoft.Azure.Cosmos.Table) I am not looking for setting it per-item basis (I found in feature…
Sayantan Ghosh
- 998
- 2
- 9
- 29
0
votes
1 answer
Correct way to query a Cosmos DB Table
I am trying to use Cosmos DB Tables. What I am noticing is that if I query on Timestamp property, no data is returned.
Here's the query I am using:
Timestamp ge datetime'2010-01-01T00:00:00'
I believe my query is correct because the same query runs…
Gaurav Mantri
- 128,066
- 12
- 206
- 241
0
votes
1 answer
Azure Cosmos DB (Table API) v/s Azure Cosmos DB (SQL API)
I'm using ADF for reading data from data lake and storing the data to a cosmos db. I'm figuring out whether I should use azure Cosmos DB Table API or SQL API (Core API). How do these two APIs, namely the Azure Cosmos DB (Table API) and Azure Cosmos…
user989988
- 3,006
- 7
- 44
- 91
0
votes
1 answer
How can you dynamically create Azure tablequery in node based on number of attributes?
I have an input that may be 1 attribute or more. with azure tablequery, a query is created like this:
var tableQuery = new TableQuery()
.where('Name == ?', 'Person1');
If I have more than one attribute to query, it looks like…
carpekd
- 99
- 9
0
votes
1 answer
How to debug/troubleshoot metadata DTU throttling on Azure Cosmos DB (Table API)?
We are using Azure cosmos DB for saving state information of a job processing pipeline. We use the table API and the corresponding SDK for this. Recently, we noticed that the system was frequently running into 429 – Request rate is too large error.…
Hari Durairaj
- 25
- 1
- 8
0
votes
1 answer
How to convert Microsoft.WindowsAzure.Storage.Table.TableEntity to Microsoft.Azure.Cosmos.Table.TableEntity
I'm trying to migrate from classic Azure Table Storage to Cosmos DB with Azure Table API. Starting on a particular data I want to start copying the current incoming Microsoft.WindowsAzure.Storage.Table.TableEntity objects to Cosmos DB at the same…
ProfNimrod
- 4,142
- 2
- 35
- 54
0
votes
1 answer
Fetching different row keys from same partition by batching a table in Azure Cosmos DB
I have some time based data in a table which has a schema like this :
Timestamp |id | Name | Marks
Timestamp represents data from a day per week in the year when exams
are held. Example : 5 exam weeks every year for 5 students would have
5…
user5566364
- 173
- 2
- 12
0
votes
0 answers
Azure CosmosDb UpsertDocumentAsync committed vs propagated
I have two endpoints exposed to a client, one that creates a CosmosDb document, and one that reads that same document. Perhaps 2-3 times out of hundreds, I will get an exception from the second endpoint, because the client is trying to access a…
JMax2012
- 373
- 2
- 6
- 24
0
votes
1 answer
CosmosDB Create Table hanging indefinately
I've tried all four variations of the methods that create a table:
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(connectionString);
var tableClient = storageAccount.CreateCloudTableClient();
var table =…
BanksySan
- 27,362
- 33
- 117
- 216
0
votes
1 answer
Update/merge operation can't find Entity in Azure Cosmos DB (Table API)
Data:
In [66]: list(a.table_service.query_entities('Watchlists',filter="RowKey eq '106619222' "))[-1]
Out[66]:
{'PartitionKey': '2019-01-24',
'RowKey': '106619222',
'Timestamp': datetime.datetime(2019, 1, 24, 16, 36, 45, 474017, tzinfo=tzutc()),
…
Josh D
- 794
- 4
- 14
- 31
0
votes
1 answer
azure cosmosdb - disable default secondary indexes
Is there any way to disable the default secondary indexing in azure cosmosdb? My application does not require secondary indexing on addition of every extra field in the collection. Can I disable creation of secondary indexes?
What happens if I…
Aparna Kulkarni
- 23
- 2
0
votes
1 answer
Cosmos DB Tables API Index PartitionKey & RowKey only
Using a TablesDB table in Cosmos DB I'm trying to index only the PartitionKey and RowKey.
My CosmosDB index below compiles correctly but when I run a query on the PartitionKey/RowKey I get the error "An invalid query has been specified with filters…
Francesco
- 594
- 7
- 14
0
votes
1 answer
How to Pass List of Objects as a Parameter to Azure CosmosDB (DocumentDB) Stored Procedures?
I am trying to perform a Bulk Update in One of my collection (say pages). I have created a Stored Procedure for this which is working all fine when I execute from Azure. But the problem comes when I execute that through a REST API.
When I Pass List…
Shunmugam V
- 73
- 1
- 8
0
votes
0 answers
C# API Service not returning RowKey
I am creating an API wrapper for my azure cosmos db table and it is not returning the row keys
List _records = new List();
CloudStorageAccount storageAccount =…
Page F.P.T
- 653
- 4
- 11
- 24