CODEWITHSUNDEEP
azureazure-cosmosdbazure-cosmosdb-sqlapi
chelder
chelder

Reputation: 3987

How to get more than 100 query results with SQL on portal.azure.com Cosmos DB Data Explorer

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

Upvotes: 9

Views: 7154

Answers (2)

Markus Meyer
Markus Meyer

Reputation: 3937

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

Upvotes: 12

Jay Gong
Jay Gong

Reputation: 23782

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.

Upvotes: 12

Related Questions