Power internal tools, in-app experiences, and more
Hightouch requires a unique identifier in the destination Postgres table in order to add, remove, and update rows. The main identifier column in your sync config must match on a
UNIQUE column within postgres.
If you're unsure whether your mapping includes a compatible column, just try it! Hightouch will error if you need to change your mappings.
Hightouch works out of the box with all standard column types, including:
If you see type errors, it may be because your SQL query is producing the wrong format. Message us on Intercom if you need help!
Your Postgres credentials must be able to:
Add/update/delete rows from the destination table.
INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGEtables. This is used for
gathering metadata needed for the sync.
The minimum supported Postgres version is
9.5 (Hightouch relies on
ON CONFLICT for updating rows).
Your settings for the PostgreSQL destination should look similar to this:
- Host: The URL or IP address for your PostgreSQL host. You do not need to include the
- Port: Your PostgreSQL port. The default- as is typical for PostgreSQL - is 5432.
- Database: The name of your database. This is different than the host, but your host address might contain your database name.
- Username: The user that has access through Hightouch to the database and tables you want to sync to. You should create a new user specifically for Hightouch access; do not use the root user.
- Password: The user's password.