How to Fix Table Name in Configuration to Avoid Pattern Matching

ingestion
1

Original Slack Thread

table_pattern:
allow:
- SAPABAP1.BKPF
- SAPABAP1.BSEG
how to fixed table name in this config , not search like

2

Hey there! :wave:

<@U06TM7M40RK> Can you help with the questions in this thread?

:information_source: Please continue to tag RunLLM (e.g <@U06TM7M40RK>) to have it continue generating responses!

3

To ensure that specific table names are fixed and not treated as patterns in your table_pattern configuration, you should use regex patterns that match the exact table names. In regex, the ^ and $ symbols are used to denote the start and end of a string, respectively. This ensures that the pattern matches the entire table name exactly, rather than just a part of it.

Here’s how you can modify your configuration to match the exact table names:

table_pattern:
    allow:
        - '^SAPABAP1\.BKPF$'  # Matches exactly the table name SAPABAP1.BKPF
        - '^SAPABAP1\.BSEG$'  # Matches exactly the table name SAPABAP1.BSEG

Explanation:

  • ^: Asserts the start of the string.
  • \.: Escapes the dot character, which is a special character in regex, to match a literal dot.
  • $: Asserts the end of the string.

This configuration will ensure that only the tables SAPABAP1.BKPF and SAPABAP1.BSEG are included in the ingestion process, matching them exactly by name.

Would you like more detailed steps or further assistance on this topic?

Sources:

4

Hi, how did my answer work out for you? Need any more assistance? You can also tag <@U07FV3UHE4D> to let your fellow community members know you’re still looking for guidance.

5

Hi :slight_smile: ! Did this interaction resolve your issue or do you still require assistance ?

Please tag @ RunLLM if you still need further assistance !

Or tag @Datahub Community Support if you require a person to take a look :slight_smile:

Hope this helps ! ><