question

drewbyty-2013 avatar image
0 Votes"
drewbyty-2013 asked azure-cxp-api edited

Unique list of PartionKey's in Azure Table Storage Account

I would like to get a unique list of PrimaryKey's used in an existing Azure Table Storage Account with a large amount of data. In this db there will be more than 20 unique Primary Key's and I would like to get this unique list back. Is there any FilterCondition or API that supports this?

azure-table-storage
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

All of the tags for Azure are active in Q and A now. The questions can be asked here. We hope this was answered on MSDN but going forward, the questions for Azure will be answered here.

Thanks
Navtej S

0 Votes 0 ·

1 Answer

ErikEJ avatar image
1 Vote"
ErikEJ answered

As you may already know that there's no Count like functionality available in Azure Tables. In order to get the total number of entities (rows) in a Partition (or a Table), you have to fetch all entities.
You can reduce the response payload by using a technique called Query Projection.

https://stackoverflow.com/questions/38977896/count-rows-within-partition-in-azure-table-storage

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.