My question is about database user permissions. I have a existing postrges db that I am connecting airbyte to. Currently airbyte is using the root db user and I would like to create a new user with minimal permissions for airbyte to use. Is there a document somewhere that lists the minimum permissions a postgres db user would need so airbyte will run correctly? My first attempt at trying this wasn’t successful.
11/05/2021, 4:48 PM
Is postgres your source or your destination? If it’s a destination, the user must have create schema privs, which is a fairly broad permissions level; it uses it to write _airbyte staging tables before finishing data normalization. If postgres is your source, it can probably get by with fewer permissions. I’m not sure on docs, if those details aren’t already in the postgres connector docs.
11/05/2021, 5:48 PM
It is my destination, I am pretty sure that I messed up the create schema privileges and probably some other stuff as well. I just found the postgres connector docs so thanks for helping me search for the right stuff.