query service connection to external system | Community
Skip to main content
Pradeep-Jaiswal
Level 5
February 6, 2026
Question

query service connection to external system

  • February 6, 2026
  • 2 replies
  • 3 views

when we use DB viewer or any other external DB which uses AEP dataLake, the postgres credential expires in 24hr. is there a way to automatically refresh the credentials so that we dont have to reconfigure the query service connection in every 24hr?

2 replies

Level 1
February 6, 2026

Hi there.  One option is to create non-expiring credentials, that implies to correctly assign permissions for DB objects to the created user.  Subsequently, this could be also a security risk if is not well managed.  
 

Hope this helps.  

Pradeep-Jaiswal
Level 5
February 6, 2026

I just now found about no-expiry token setup https://experienceleague.adobe.com/en/docs/experience-platform/query/ui/credentials#non-expiring-credentials

 

we can close this ticket