Some tables are not displayed even though they exist in the destination DB.

Question

In the property settings for the Read Table operation of a database connector, some tables are not displayed even though they exist in the destination DB.
I was tried to select the target table from the list after setting the connection destination. If I enter the table name manually, extraction test succeeds.

Please let me know how to handle this issue.

Answer

The cause may be one of the following:

Limitation on the number of table name displayed

Specification Explanation
In the connection resource settings, there is the maximum number of table lists to be displayed.

Solution
Change the upper limit to the number of tables displayed in the connection resource settings.
*The default setting is 500.

Tables are in another schema

Specifications Description
Tables belonging to the schema of the user specified in User Name of connection resource are displayed in the list. Tables in a different schema are not displayed.

Solution
When using tables in a different schema, specify the table name directly, including the schema name.