🔌Setting up a PostgreSQL Connector

Configuring the PostgreSQL connector in Toucan

Fill in the mandatory connection information:

  • Host/ server name

  • Username

  • Password

  • Port

PostGreSQL Connection form
PostGreSQL Connection form
  • Then you can finally hit the TEST CONNECTION and SAVE the connection

  • After testing the connection, you should have something like this :

PostGreSQL Connection Test
PostGreSQL Connection Test

After successfully configuring the connector, you will be able to find it in the Connector section of the DataHub "Datasource" tab

Selecting data from PostgreSQL

To create a dataset from PostgreSQL, click on the "create from icon". You will then be able to:

  • Select the Database

  • Select the Schema

  • Select Table or Views

  • Only keep the columns you need

For more info, see the dedicated section Creating datasets

After selecting data from your connector you will be able to create a dataset thanks to YouPrep using the selection as "source step".

Last updated

Was this helpful?