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.

Steps

  1. Log in as the Dataiku Administrator.

  2. From the Applications menu in the top navigation bar, choose Administration.

    The Administration menu is located in the Admin Tools menu.

  3. Navigate to the Connections tab and select New Connection > PostgreSQL.

    Many different SQL database connections are available in the New Connection menu.

  4. Fill in the information required for the connection. Don’t forget to give a name to your connection!

Warning

You cannot change the connection name afterward.

Create a SQL connection on the new PostgreSQL connection screen.

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.

  1. Click Import tables to datasets.

  2. Select the tables you want to import.

  3. Click Import tables.

  4. Select the project in which the datasets associated with these tables should appear.

You can mass import tables after creating the SQL connection.

What’s next?

Now that you have configured a connection between Dataiku and a PostgreSQL database, learn how to transfer data to your database with the Sync recipe.