source-postgres support azure entra authentication for service principal #57561
vpipkt
started this conversation in
Connector Ideas and Features
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
In my environment, most of our teams using Postgres run
Azure Database for PostgreSQL flexible server
. One of the attractions to this is we can use Entra for passwordless authentication in many more settings. However when we want to replicate from these database with source-postgres today (v3.6.30), we have to use local database authentication. Our dba's don't like this. They would rather Airbyte authenticate via an Entra application registration. This means generating a short-lived token from service principal client id and client secret, which is used to connect to the database.This is basically the same as in #50398, but toward Postgres. My goal with this issue is to get some involvement from the airbyte core team and community, as the Postgres connector is
ab_internal.sl: 100
ab_internal.ql: 100
.I do have a draft PR of a working implementation, and very happy to have any feedback at all there.
Beta Was this translation helpful? Give feedback.
All reactions