How to increase the Metadata Cache TTL for the DB Table Selector Node?

Hello.,

Is there a way to increase the Metadata Cache TTL for the DB Table Selector Node? Currently it looks like that Metadata Cache is retained for ~10 mins, after that the Metadata is queried again from the DB.

Refreshing of the Metadata takes a long time in our Datawarehouse, so I am trying to avoid frequent Metadata refreshes.

Please advise.

Thanks.

Hello saqib,
the database metadata has no cache expiration time. It is fetched the first time the metadata browser is opened. Once this is done it is cached in the database session. So as long as you use the same database session e.g same database connector the metadata is reused. If you then want to refresh it you can click on the refresh button at the bottom right corner of the dialog where you also see when the metadata was fetched the last time.
image
Bye
Tobias