Hi All, when I run pipeline for oracle getting s...
# troubleshoot
s
Hi All, when I run pipeline for oracle getting system tables as well. Is it possible to add any flag to pull only user tables?
m
You can use allow/deny patterns in your oracle source recipe
s
it will apply for table name not table type. if user and system table have the same pattern this rulle will apply to user table as well
so added schema_pattern with long list of system users
a
You could define two different ingestion runs that target only those specific tables, though it may require configuring service workers with seperate acces rights on the oracle side