🔌Add a PostgreSQL connector

This data connector is supported by our new Data Execution system!

This data connector is compatible with NativeSQL with our current and new data execution system

Configuring a PostgreSQL connection

Fill in the connection information

Field	Format / Type	Description	Example
Name (mandatory)	String	Use it to identify your connection	MyPostGreSQLConnection
Host (mandatory)	String	The domain name or IP address of your database server	"db.example.com" or "192.168.1.100"
Port (mandatory)	Integer	The listening port of your database server	3306
User (mandatory)	String	Your login username	myuser
Password (mandatory)	String	Your login password	secretpassword123
Charset (optional)	String	Character encoding for the connection	"utf8mb4" (default)
Connect Timeout (optional)	Integer	Connection timeout in seconds	30
Retry Policy (optional)	Boolean	Boolean allows to configure a retry policy if the connection is flaky. max attempts: maximum number of retries before giving up max_delay: in seconds, above the connection is dropped wait_time: time in seconds between each retry
Slow Queries' Cache Expiration Time (optional)	Integer	Slow queries' cache expiration time in seconds

• Click on the TEST CONNECTION button then SAVE the connection

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

Create a dataset from a PostgreSQL connection

This data connector is supported in simple and code/SQL mode for our current Data Execution system and new Data Execution systems

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 Create a new dataset from a dataset

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