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.

[VirendraPr2]

@KelvidPa 

I was going through this post. I am also looking similar to extract more records to verify. 

Can you please confirm, if you are able to connect and run the query using SQL client?

If yes, can you please guide on the same with steps?

Thanks