Postgres Integration
Connect to Postgres
Add a Postgres datasource from the new datasource page.
Fill in the fields and click the Add Datasource
button.
Datasource Name
is a human-readable display name for this datasource.Details
is for your own notes, and supports markdown formatting. We suggest recording the relevant tables and schemas here for later reference.Database Address
is a public address for your postgres db.Username
is auser
created on your postgres db. We suggest creating a dedicated user with read permissions only.-
GRANT SELECT ON my-table TO thorntale-user
-
Password
is the corresponding password.
We’ll test the connection, and if we can reach your database, we’ll add the datasource.
Troubleshooting
If you’re hitting permission issues, make sure your database is publically accessible. Sometimes, firewalls can prevent Thorntale from connecting to your Postgres.