Postgres

    Connecting to your Postgres instance to onverre is simple.

    Step 1. Visit your onverre warehouse connection

    After logging in to app.onverre.com, click on the account dropdown -> Warehouse Connection.

    Step 2. Edit your warehouse connection

    Once on that page select "Add Connection" (or "Edit Connection")

    Step 3. Add your connection details to your onverre warehouse connection

    Choose the Postgres integration option and fill out that form with your warehouse connection details.

    Form Fields:

    • Name: This can be any name you choose. Typically this is the url of the website you are tracking data from.

    • Host: This is the hostname for your Postgres instance i.e <postgres-url>.postgres.render.com

    • Database: This is the Postgres database which onverre will connect to.

    • Schema: This is the database schema which onverre will connect to i.e. WEBSITE.

    • Username: This is the username that onverre will use when connecting to your Postgres database.

    • Password: This is the password that onverre will use when connecting to your Postgres database.

    • Port: This is the network port that onverre will use when connecting to your Postgres database.

    • Namespace: This is the database namespace to use when querying your Postgres database

    Updated at: Aug 10 2023