Unique list of PartionKey's in Azure Table Storage Account

drewbyty 1 Reputation point

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.
162 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ErikEJ 341 Reputation points MVP

    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.


    1 person found this answer helpful.
    0 comments No comments