Configure the PostgreSQL connection¶
To complete this tutorial, you need to establish a connection between Dataiku and your PostgreSQL database using the instructions given in the reference documentation. However, note that only the Dataiku Administrator has permission to do this.
Log in as the Dataiku Administrator.
From the Applications menu in the top navigation bar, choose Administration.
Navigate to the Connections tab and select New Connection > PostgreSQL.
Fill in the information required for the connection. Don’t forget to give a name to your connection!
You cannot change the connection name afterward.
You can then test and create your PostgreSQL connection.
Import datasets into Dataiku¶
After creating your connection, if you are connecting to a pre-existing PostgreSQL database, you can create a Dataiku dataset for every table in the database.
Click Import tables to datasets.
Select the tables you want to import.
Click Import tables.
Select the project in which the datasets associated with these tables should appear.