How to get around errors on external tables?

janp

Any suggestions on how to deal with external tables, for which the data source is missing?
We mostly have no need to have data in some external tables on test and development environments - an attempt to select from them results in an exception.

I have tried to add them to ignore list (Ignore tab), but going to the Tables&Views tab still produces an error:


Any way to get around the error - other than actually populating the tables external sources with some dummy files.

Sergio R

I think that you might need to use the dummy files, however I am going to ask internally and will get back to you soon.