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

Question

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

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

Lethargy

Answer 1

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

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.

Foetor

Thanks... Hopefully that warning (This blade will be retired soon. Please use Data Explorer going forward) will be there long time! – Lethargy

@Lethargy Haha... i believe the page size setting will also be transplanted into data explorer. – Foetor

It is a shame that there are no decent tools for Azure Cosmos DB. Most things rely on you using the SDK. – Darfur

This does not exist any more – Handmaiden

Answer 2

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

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

Keli

The old accepted answer is not longer the latest Azure version, this is the current correct answer for now – Commentate

Yes, Unlimited option doesn't work for me. I have to choose Custom option and provide a huge number of results in the page. – Darfur