View Navigation
Product Overview
Account Overview
Integrations   ->

Pull from PostgreSQL

The Pull from PostgreSQL step connects to and pulls from a PostgreSQL database. PostgreSQL is an open-source object-relational database management system.

Connect your PostgreSQL database

Double-click on the Pull from PostgreSQL step and click Authorize. These are the following fields required to connect:

  • Hostname
  • Username
  • Password
  • Database
  • Port (Optional)

If no port is specified during authorization, this step will default to port 5439.

You can leave fields blank (like password) if they are not needed for the database to authorize connection.

Custom settings

Once you are successfully connected to your PostgreSQL server, you'll first see a dropdown option to select a table from your server. By default, Parabola pulls the whole table using the query:

select *

If you'd like to be able to pull in more specific, relevant data by writing your own SQL statement, you can do so by clicking into "Advanced Settings" and input your query into the Query (optional) field.