How to get top n entities from azure table storage

Yugesh KC 21 Reputation points
2022-08-30T08:39:40.243+00:00
  • I followed the long tail design pattern to sort the entities in descending order as shown in this 85245919390
  • Its mentioned that we could retrieve top n values using $top query operator 85245919390
  • Is $top query operator available in python sdk
Azure Table Storage
Azure Table Storage
An Azure service that stores structured NoSQL data in the cloud.
171 questions
0 comments No comments
{count} votes

Accepted answer
  1. ShaktiSingh-MSFT 15,501 Reputation points
    2022-08-30T12:02:54.223+00:00

    Hi @Yugesh KC ,

    Welcome to Microsoft Q&A platform and thanks for using Azure services.

    As I understand your ask, you want to get top n entities from azure table storage and possibility to do using python sdk.

    This is possible through LINQ queries which is documented at this writing-linq-queries-against-the-table-service link.
    Additional helpful links with discussion: retrieve-top-n-records-from-azure-table-storage-with-net-core

    As per this link azure-data-tables, there is no existing direct method or operator like $top. Instead, we may try to use pandas head method while querying entities described in the same link.

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you.
      Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Yan Xie 40 Reputation points Microsoft Employee
    2024-07-30T02:57:00.5233333+00:00

    Thanks for your answer!

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.