7

On https://portal.azure.com/ - Cosmos DB Data Explorer, I can execute SQL queries. The result output is 100:

SELECT c.email FROM Clients c

screenshot

To reduce the number of network round trips required to retrieve all applicable results, you can increase the page size using x-ms-max-item-count request header to up to 1000: https://learn.microsoft.com/en-us/azure/cosmos-db/performance-tips

Is it possible to use x-ms-max-item-count on that SQL query? Any other way to increase the limit of output results to it maximum?

Related question: How to get more than 100 query results with Azure DocumentDB REST API

chelder
  • 3,819
  • 6
  • 56
  • 90

2 Answers2

12

In fact, there is a Query Explorer in azure cosmos db portal which is similar to Data Explorer mentioned in your question.

enter image description here

As you see,you could set items per page as custom number or unlimited. If it is in REST API, you could follow the case to configure the x-ms-max-item-count header. It it is in SDK,you could set the MaxItemCount property in FeedOptions.

Jay Gong
  • 23,163
  • 2
  • 27
  • 32
  • 3
    Thanks... Hopefully that warning (_This blade will be retired soon. Please use Data Explorer going forward_) will be there long time! – chelder Dec 05 '19 at 01:39
  • 2
    @chelder Haha... i believe the page size setting will also be transplanted into data explorer. – Jay Gong Dec 05 '19 at 01:42
  • It is a shame that there are no decent tools for Azure Cosmos DB. Most things rely on you using the SDK. – Oliver Nilsen May 03 '23 at 08:30
8

There's a setting blade in the upper right corner of the Data Explorer:

enter image description here

There you can specify the Page Options: Query results per page

enter image description here

Markus Meyer
  • 3,327
  • 10
  • 22
  • 35