PostgreSQL connection - authentification error

Options
cmolia
cmolia Partner, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1 Partner

Hello,

For the online course 'Integration With SQL Databases', I'm struggling to set up the PostgreSQL connection with DSS.

As guided by the course, on pgAdmin I executed the following queries in the database dku:

CREATE SCHEMA dku_churn;
CREATE USER clara WITH PASSWORD 'Password';
GRANT ALL PRIVILEGES ON SCHEMA dku_churn TO clara;
CREATE SCHEMA dku_tshirt;
CREATE USER dku_tshirt_admin WITH PASSWORD 'Password';
GRANT ALL PRIVILEGES ON SCHEMA dku_tshirt TO dku_tshirt_admin;

In Dataiku DSS, on the Connections tab, I've tried every combination I could think of, see in attachments the settings screenshots. Adding ssl parameters in advanced properties doesn't seem to help.

Error technical details:

  • Error type:org.postgresql.util.PSQLException

Thank you in advance,

Answers

Setup Info
    Tags
      Help me…