Prerequisites for SQL Integration¶
DSS Admin permission is required in order to configure a database connection as described below.
The instructions below refer to a local installation of PostgreSQL. If you’re using Dataiku Online, rather than connect to a local PostgreSQL connection, you might consider starting a free trial using Snowflake Partner Connect, following these instructions.
If it isn’t already available, install PostgreSQL version 9 or above. Take note of the host on which PostgreSQL is installed.
Tip: On macOS, we recommend using the Postgres App.
Create and Configure Your PostgreSQL Database¶
At a minimum you need a user and a database, as explained in the PostgreSQL guide. As a best practice, we recommend using schemas in order to administer multiple projects within a database.
psql -h localhost CREATE DATABASE dku; \c dku CREATE SCHEMA dku_churn; CREATE USER matthieu WITH PASSWORD 'Password'; GRANT ALL PRIVILEGES ON SCHEMA dku_churn TO matthieu; CREATE SCHEMA dku_tshirt; CREATE USER dku_tshirt_admin WITH PASSWORD 'Password'; GRANT ALL PRIVILEGES ON SCHEMA dku_tshirt TO dku_tshirt_admin; \q
This sample code creates the user
matthieu, with password
Password, and grants this user all privileges (can create and delete tables) in the
dku_churn schema in the
dku_tshirt_admin has been granted all privileges on the
dku_tshirt schema in the