Skip to main content
KelvidPa
Level 2
October 3, 2024
Solved

Query service increase the number of records showing

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 ?

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.

View in thread

4 replies

Parvesh_Parmar
Community Advisor
Parvesh_ParmarCommunity 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

 

Translate
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?

    Translate
    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.

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...