Table excluded in the list is added for capture

[sriram venkatasamy]

I have excluded to huge number of tables in the connector configuration. Below is the sample 

table.exclude.list: JIRA.MLOG$_AO_60DB71_LEXORANKBA,JIRA.MLOG$_PRIORITY

But we could see that tables are added for capture and topics are getting created in kafka.

• "Adding table NLGENP.JIRA.MLOG$_AO_60DB71_LEXORANKBA to the list of capture schema tables",

• "Adding table NLGENP.JIRA.MLOG$_PRIORITY to the list of capture schema tables",

Can you suggest why its capturing the excluded tables?

FYI, I have few connectors with table.include.list which is working perfectly.

Thanks,

Sriram V

[jiri.p...@gmail.com]

Hi,

it caputes only the schema, not the cntent. Schema is captured in case you'd add the table into included list later.

Jiri

[sriram venkatasamy]

Thanks Jiri for your response.

To give more clarity on the configuration. To capture all the tables in a given schema excluding few tables. I have added the schema names in the include list and list of tables in exclude list like below.

schema.include.list: JIRA,DBZUSER

table.exclude.list: JIRA.MLOG$_AO_60DB71_LEXORANKBA,JIRA.MLOG$_PRIORITY

As per the understanding it should exclude the tables list and capture all the rest of the tables in the schema. It was never added in the include list later, but we could see in the logs that the table was captured as soon the connector was started first time with this configuration. FYI, in the logs we could notice that the table.exclude.list was also reflecting as per the configuration.

Thanks,

Sriram V

[jiri.p...@gmail.com]

Hi,

are you sure that the content of the tables is really captured? The log messages you posted speak about table structure snapshot, not about data.

Jiri

[sriram venkatasamy]

Yes, Table was there in the capture list. I have deleted and performed a initial load by escaping the $ symbol in the table name like below.

JIRA.MLOG\$_AO_60DB71_DETAILVIEW

Will update if this helped