Filter rows at source for historic table data

[pidanou]

Hi,

I have a table that has a lot of data, I need to sync this table to a new database but I don't require the historic data only the new data from the point I create the connection.
The source is OracleDB and the destination is Postgres

Now to make things worse, since my app is a multi tenant SaaS app, there is an undefined number of OracleDB that I need to connect to.

I saw this question here: https://discuss.airbyte.io/t/filter-data-at-source/4239
It is basically the same use case (+ the fact that I need to make things dynamic to address the multi tenant related issues).

I also saw there was the filter feature here: https://docs.airbyte.com/connector-development/config-based/understanding-the-yaml-file/record-selector
So I should create my custom connector? And have the filter be a dynamic value that will be the connection creation date (if that is even possible)

Is there any simpler way? Using only the API for example?

Thanks a lot!

[pidanou]

Maybe the question wasn't clear and too complex at first.
Simply put:
Is it possible to only sync data from a specific date (using for example a date column) when using INCREMENTAL APPEND?