Query service increase the number of records showing

[KelvidPa]

From the dropdown of the query service, I can see maximum is displaying 500 records.

From the documentation, it shows that it able to return maximum 50,000 from the UI, how can I make the changes ?

[Parvesh_Parmar]

Hello @KelvidPa , 

The Query Service can display a maximum of 500 records.

Please refer to the documentation below for more details:

URL: https://experienceleague.adobe.com/en/docs/experience-platform/query/ui/user-guide#result-count

Kr, 

Parvesh

[KelvidPa]

Hi @Parvesh_Parmar , thanks for the reply. Do you know if there is possible way to download the result of the query above 500 records and up to 50k records?

[SubeAEP · Accepted solution]

Yes this can be achieved by using a SQL client or a database tool like to fetch records and download the result. You need the expiring credentials(Postgre) that is present under Queries > Credentials tab to connect to AEP database.