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:
- 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.
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:
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.