https://linen.dev logo
#feedback-and-requests
Title
# feedback-and-requests
a

Alexandru Manolache

07/21/2021, 1:33 PM
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?
u

user

07/21/2021, 1:35 PM
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?
n

Nils de Bruin

07/21/2021, 1:35 PM
Hi Chris! Unfortunately the database is out of our control and managed by a third party, so that is not an option!
u

user

07/21/2021, 1:36 PM
Great suggestion anyways!
n

Nils de Bruin

07/21/2021, 1:44 PM
This would be easy to do if we implement the ability to manually edit a connections state
u

user

07/21/2021, 1:53 PM
This would be a great feature to have. IMO, one should be able to define such filters in the source, similar to
request_params
.
j

Jeff Crooks

07/21/2021, 3:57 PM
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
2 Views