Skip to main content

Overview

This guide expands the PostgreSQL connection flow with visuals. Use it when connecting a new database for the first time.

Open the Explore Page

From your Daymark workspace, go to Explore to start the connection. Explore page with Add data source button

Choose PostgreSQL

Click Add data source and select PostgreSQL from the connector list. Data connectors modal with PostgreSQL selected

Enter Connection Details

You can use either a connection string or manual fields.

Option 1: Connection string

Paste your PostgreSQL connection string into the Connection String field.

Option 2: Manual fields

Fill in the form with your database details:
  • Host
  • Port (default 5432)
  • Database name
  • Username
  • Password
Click Connect Database. PostgreSQL connection form

Select Tables and Fields

Choose the tables and columns you want to include:
  • Use Select all to include every field
  • Or choose only the fields relevant to your analysis
Click Done to finish. Field selection during PostgreSQL import

Connect and Import

Daymark validates the credentials and starts importing. Importing data from PostgreSQL