Unique list of PartionKey's in Azure Table Storage Account

drewbyty 1 Reputation point
2020-02-24T12:48:54.147+00:00

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
Azure Table Storage
An Azure service that stores structured NoSQL data in the cloud.
128 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ErikEJ 331 Reputation points MVP
    2020-05-22T05:59:35.91+00:00

    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

    1 person found this answer helpful.
    0 comments No comments