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
modern-artist-55754
03/23/2023, 12:19 AM
You can use allow/deny patterns in your oracle source recipe
s
strong-parrot-78481
03/23/2023, 1:47 PM
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
strong-parrot-78481
03/23/2023, 3:48 PM
so added schema_pattern with long list of system users
a
astonishing-answer-96712
03/23/2023, 7:23 PM
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