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