Hi all! I just installed Airbyte on AWS and I am now extracting data from an on-prem Postgres database over a VPN connection, working smoothly! I am now looking for a way to extract a table from postgres and also include certain filter options (where statement) as I am required to not pull all data from the tables. Is it possible to include a where filter before capturing the data?

Is it OK for you to create view tables in your source database with the appropriate

WHERE

statements and you would only replicate data from these view tables in your connection settings?

Hi Chris! Unfortunately the database is out of our control and managed by a third party, so that is not an option!

Great suggestion anyways!

This would be easy to do if we implement the ability to manually edit a connections state

This would be a great feature to have. IMO, one should be able to define such filters in the source, similar to

request_params

.

hey @Nils de Bruin just curious did you depoy on EC2? Trying to figure mine out as well but was recommended to deploy on Lightsail