Support Questions

Find answers, ask questions, and share your expertise

how to define "Table Name Pattern" for more than 1 table in ChangeCaptureMySql processor configuration file

Contributor

Hi,

how to define "Table Name Pattern" for more than 1 table in ChangeCaptureMySql processor configuration file.  I tried below patterns where "product_types" and "user_subscription" table names. I want to read data only from these tables.

[product_types|user_subscription]_ or [product_types|user_subscription]%

 

Screenshot from 2022-07-07 22-00-00.png

1 ACCEPTED SOLUTION

Master Collaborator

@AbhishekSingh ,

 

The pattern expression must be a regular expression (regex).

The regex equivalent to your LIKE pattern is:

(product_types|user_subscription).*

 

Cheers,

André

 

--
Was your question answered? Please take some time to click on "Accept as Solution" below this post.
If you find a reply useful, say thanks by clicking on the thumbs up button.

View solution in original post

1 REPLY 1

Master Collaborator

@AbhishekSingh ,

 

The pattern expression must be a regular expression (regex).

The regex equivalent to your LIKE pattern is:

(product_types|user_subscription).*

 

Cheers,

André

 

--
Was your question answered? Please take some time to click on "Accept as Solution" below this post.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.