Hi together, Is there a possibility for an SQL connector to display functions in addition to views and tables and to select them for the extraction of data? Unfortunately, our customer cannot activate CDC and the amount of data in the individual tables is too large to always do a full refresh. I would be very grateful for any help or ideas!

loading...

Using views doesn’t solve the problem? Where updates with a dynamic update window attribution?

I'm not sure how you mean that. I can call the function in the view, but I don't know how to transfer the parameter to the view. I would have a view that calls a function with a parameter (timestamp) that is best entered dynamically by Airbyte and corresponds to the time of the last sync.