Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hue Creates Many Connections to PostgreSQL

avatar
New Contributor

Hi,

I'm using Hue editor to send queries to PostgreSQL  database.
I have configured interpreter in the following way:

[notebook]

    [[interpreters]]

    [[[postgresql-7af1c4ea51]]]

      name=devops-notification

      interface=sqlalchemy

      options='{"url": "postgresql://${USER}:${PASSWORD}@dbname.eu-central-1.rds.amazonaws.com:5432/notification"}'

It works fine.  But every time I send a quiery, new connection to PostgreSQL instance is established. 
Is there a way to use single database connection per user or just close connections right it returned a result?

 

Thanks  in advance. 
Andrii

1 REPLY 1

avatar
Master Guru

@Andrii I doubt if it's possible. Check the document if this helps:

 

https://docs.gethue.com/administrator/configuration/apps/#jdbc


Cheers!
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.