I'm unsure if this is the right place to post my question. I am evaluating Oracle tap to retrieve data from an Oracle database into parquet file for change data capture . The parquet file will be loaded into Databrick via auto loader. The data in oracle we need involves some system-built API or function, so we can't extract the data directly from a database table but instead have to use an Oracle view. However, based on my research, it appears that the incremental replication method only works with tables and not views.
The issue is that we can't to recreate those system APIs or functions in Databricks. How should we proceed with CDC for data from an Oracle view?