PostgreSQL

​
Connection Details

FieldDescriptionExample
HostPostgreSQL server addressdb.example.com
PortPostgreSQL port (default 5432)5432
DatabaseDatabase nameanalytics
UsernamePostgreSQL userreadonly_user
PasswordUser password••••••••

​
Setting Up

1

Go to Connectors → Database

Select PostgreSQL as the database type.
Selecting PostgreSQL
2

Enter connection details

Fill in host, port, database name, username, password, and SSL CA certificate.
PostgreSQL connection form
3

Test connection

Click Test Connection to verify.
Testing PostgreSQL connection
4

Select tables

Choose which schemas and tables to include.
Selecting PostgreSQL tables
5

Save

Your PostgreSQL database is now queryable.
For best results, use a read-only database user to prevent accidental data modifications.