PostgreSQL Source: cant set set configuration parameters

Connector Questions & Issues
, ,
1
  • Is this your first time deploying Airbyte?: Yes
  • OS Version / Instance: Ubuntu 20.04
  • Memory / Disk: 30Gb/150Gb
  • Deployment: Docker
  • Airbyte Version: * 0.39.37-alpha
  • Source name/version:
  • Destination name/version:
  • Step: Happening during sync
  • Description: In order to make queries on our PostgreSQL database, which has row level security enabled, we need to set a server parameter before each connection. this is done by prepending a SET command before the sql query:
    set rls.a_configuration_key = a_configuration_value; select * from table, etc

How can I do this with a PG AirByte source?

2

Hello and welcome to the community, @rcrafaeldelrey. It’s currently not possible to set additional parameters for the Postgres source, but this is on our roadmap and set as high priority. You can keep an eye on the progress here:
https://github.com/airbytehq/airbyte/issues/9501