@Coffee77 - Managed table, of course, the go-to approach to avoid the lag and cache invalidation etc.

However, if we assume @ChrisHunt has to keep it as external table, then is it a cache which can be manually refreshed in any way? I have not seen this weired behaviour with external tables used in past for several years.