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

Query service increase the number of records showing

  • October 3, 2024
  • 1 reply
  • 1107 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
New Participant
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
New Participant
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
New Participant
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.