Getting StartedConnect Your Warehouse
Postgres
Connect a PostgreSQL database to Levered.
What you need
| Item | Description |
|---|---|
| Host | The hostname or IP of your PostgreSQL server |
| Port | The port PostgreSQL is listening on (default 5432) |
| Database | The database containing your event tables |
| Username | A PostgreSQL user with read access |
| Password | The password for that user |
Create a read-only user (recommended)
CREATE ROLE levered_reader WITH LOGIN PASSWORD 'a-strong-password';
GRANT CONNECT ON DATABASE analytics TO levered_reader;
GRANT USAGE ON SCHEMA public TO levered_reader;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO levered_reader;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO levered_reader;Connect via the dashboard
- Navigate to Settings > Warehouse in the Levered dashboard.
- Select Postgres as the provider.
- Enter your Host, Port, Database, Username, and Password.
- Click Test Connection to verify Levered can reach your database.
- Click Save.
Troubleshooting
Connection test fails
- Make sure your PostgreSQL server is accessible from the internet (or from Levered's IP range if you use allowlisting).
- Verify the hostname, port, and credentials are correct.
- Check that the user has
CONNECTon the database andUSAGEon the schema.
Permission errors at training time
Levered runs SQL queries during model training. If training fails with permission errors, check that the PostgreSQL user has SELECT access on the specific tables referenced in your metric queries.
Next step
Now that your warehouse is connected, set up your data pipeline -- create the tables Levered reads during training.