Hi everyone. Is there an option on Airbyte for a conditional sync? Say, I want to sync only certain rows that match an expression

Hello @Home Kralych this is not possible today in general. A few connectors like Google Ads allow you to create custom queries which you can add a

where

clause. This is possible because the connector has a

/search

or allow this possibility and the custom query will create a new stream and doesn’t change the default ones. You can apply the filter using a custom dbt transformation after the sync is finished. Probably the best practice today where you first transfer and store all data and start applying your logic to the result, because if you want to change the filter you have all data and don’t need to retrieve it again. I didn’t find any issue in the Github project related to this request feel free to open a feature request!