- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2026 03:16 AM
Hello @Abhishek_sinha !
Thanks for sharing this ! very useful 😄
Few things I can add (from my personal XP), it is better to use the PostgreSQL driver and not the DBKS JDBC driver because Lakebase is PostgreSQL compatible so DBeaver should be configured as a standard PostgreSQL connection. OAuth can work but it is inconvenient for desktop clients because Lakebase OAuth tokens expire after one hour. Native Postgres pwd roles do not have that hourly token expiry so they are better for DBeaver, pgAdmin, scripts and other clients that do not automatically refresh tokens.
Last things setting sslmode=require is important and for the PKIX / certificate issue you need to disabling "use Windows trust store" in some envs but in managed corporate machines the cleaner fix may be to import the corporate CA certificate into the Java trust store.m)
Senior BI/Data Engineer | Microsoft MVP Data Platform | Microsoft MVP Power BI | Power BI Super User | C# Corner MVP