Hi Team, Once we setup source as postgres and destination as s3 and while creating connection we need to select schemas and tables which needs to write in destination. Problem here is if we select 2 tables then in destination it will create two files for each table. Is there any possibility while creating a connection we write a custom query and merge this two table into one file? If not is there any plan for development this functionlity or where in source code I can make changes. Is it possible to make this kind of modification?

Hello @Rahul Borse this is not possible today and I didn’t find any request in Github for this feature. Do you mind creating a Github issue for that?

Hi @Marcos Marx (Airbyte), I have created below issue. https://github.com/airbytehq/airbyte/issues/19866

You can use views to achieve the result you want. I don’t think changing the source connector is something viable.

I am not aware of views, can you please let me know how to achieve it through view? Also can you please let me know why do think changing source connector is not viable, is there any particular reason for the same.

Here you can read about Postgres views: https://www.postgresql.org/docs/current/sql-createview.html