Documentation

Heroku PostgreSQL

Updated on

Apr 12, 2024

IMPORTANT: This article covers setup of warehouse for load data from Improvado, not customer data warehouse from which data is being extracted. This article doesn't cover setup of customer data warehouse for Data Prep as well.

We support PostgreSQL 10 or newer.

Required information

  • Title
  • Host
  • Port
  • User Name
  • ~User Name cannot be any of the following: ```admin```, ```root```, ```postgres```
  • Password
  • Database Name
  • Schema
  • ~Specify the schema of your database
  • SSL Certificate (optional)
  • ~You can find more information about it here
  • Use static IP
Use static IP

Select Yes for Use static IP option if you allow Improvado to connect your database by the static IPs mentioned on the Destination connection page.

Select No if you have permitted access to your database from any IP. In this case, Improvado will connect your database using dynamic IPs not listed on the Destination connection page.

Table partitioning

A table loaded into the PostgreSQL database consists of data blocks called partitions, making it easier to manage and query your data. All these partitions form a Partitioned table that aggregates all data.

Learn more about table partitioning in PostgreSQL.

{%docs-informer info title="Important"%}

By default, Improvado uses Daily partitioning - one partition contains data for a certain day.

{%docs-informer-end%}

How to connect

Required permissions:

  • ```CREATE```
  • ```ALTER TABLE```
  • ```SELECT```
  • ```INSERT```
  • ```DELETE```

Schema information

Setup guide

Settings

No items found.

Troubleshooting

Troubleshooting guides

Check out troubleshooting guides for
Heroku PostgreSQL
here:

Limits

Frequently asked questions

No items found.
☶ On this page
Description
Related articles
No items found.
No items found.

Questions?

Improvado team is always happy to help with any other questions you might have! Send us an email.

Contact your Customer Success Manager or raise a request in Improvado Service Desk.