Query service increase the number of records showing | Community
Skip to main content
Level 2
October 3, 2024
Solved

Query service increase the number of records showing

  • October 3, 2024
  • 1 reply
  • 1109 views

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 ?

Best answer by SubeAEP

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.

1 reply

Parvesh_Parmar
Community Advisor
Community Advisor
October 3, 2024

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

 

Parvesh Parmar – Adobe Community Advisor https://www.linkedin.com/in/parvesh-parmar/
KelvidPaAuthor
Level 2
October 4, 2024

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?

SubeAEPAccepted solution
Level 2
October 4, 2024

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.