Configure a SQL connection in Dataiku#
Now that we have credentials for a SQL database, we need to establish a connection between Dataiku and this database.
Important
This walkthrough is for a self-managed Dataiku instance. If using Dataiku Cloud, see the how-to for adding a new connection.
Create a connection#
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!
Warning
You cannot change the connection name afterward.
Test and create your PostgreSQL connection.
Import datasets into Dataiku#
After creating your connection, if you are connecting to a pre-existing SQL 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.

What’s next?#
Congratulations! You now have a SQL connection to use underneath your Dataiku Flows.
Learn more about how to take advantage of this type of connection in Tutorial | Data transfer with visual recipes!