How to get top n entities from azure table storage

Question

• 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

Answer 1

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 or upvote 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

Answer 2

Thanks for your answer!