🔌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
andSAVE
the connectionAfter 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