Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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:
Thank you in advance,
I'm getting a similar authetication error in that part of the tutorial although I haven't tried to set any JDBC properties:
FATAL: password authentication failed for user "dku_tshirt_admin"
Also, looking at this page (https://doc.dataiku.com/dss/latest/connecting/sql/postgresql.html), looks like Postgres comes with JDBC drivers installed already in DSS so nothing more is required. Also checked my local DATA_DIR and found the files here: /home/dataiku/dataiku-dss-10.0.2/lib/ivy/jdbc-postgresql