Support Questions

Find answers, ask questions, and share your expertise

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.