๐Ÿ”ŒSetting up a PostgreSQL Connector

Configuring the PostgreSQL connector in Toucan

Fill in the mandatory connection information:

  • Host/ server name

  • Username

  • Password

  • Port

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

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

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