amirabedhiafi
Contributor

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)

If this answer resolves your question, could you please mark it as “Accept as Solution”? It will help other users quickly find the correct fix.

Senior BI/Data Engineer | Microsoft MVP Data Platform | Microsoft MVP Power BI | Power BI Super User | C# Corner MVP