Hello everyone.How to configure in config? Only th...
# ingestion
l
Hello everyone.How to configure in config? Only the table or view under the schema can be seen in the dataset. The system table is not required,Thanks in advance for your help! How to add filter conditions??
Copy code
source:
    type: oracle
    config:
        host_port: '10.xxx.xx.xx4:1521'
        database: Qxxx
        username: dxxxxv
        password: Dxxxxm
sink:
    type: databub-rest
    config:
        server: '<http://localhost:8080>'
m
You can use:
Copy code
config:
  ...
  table_pattern:
    allow:
      - regex
    deny:
      - regex
  schema_pattern:
  ...
https://datahubproject.io/docs/generated/ingestion/sources/oracle#config-details
b
Can you help to put the exact syntax to select only required schemas
m
You have to put the regex on the allow section to specify which schemas to chose.
Use the schema_pattern instead of table_patterb
b
Getting error
Copy code
RROR    {datahub.entrypoints:182} - 1 validation error for PipelineConfig\n'
           'source -> allow\n'
           '  extra fields not permitted (type=value_error.extra)\n'
m
You should check the doco, it has details on how to use schema_pattern or table_pattern
b
In doc syntax not mentioned properly