query service connection to external system | Adobe Experience League Community
Skip to main content
Pradeep-Jaiswal
Level 6
February 6, 2026
Solved

query service connection to external system

  • February 6, 2026
  • 2 replies
  • 42 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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Pradeep-Jaiswal

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

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
Pradeep-JaiswalAuthorAccepted solution
Level 6
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