Schedule reload of system.information_schema for external tables in platform

[ossinova]

Probably not feasible, but is there a way to update (via STORED PROCEDURE, FUNCTION or SQL query) the information schema of all external tables within Databricks. Last updated that I can see was when I converted the tables to Unity. From my understanding only managed tables will populate changes in the information_schema. However, is it doable to get the same functionality for external?

[Own]

You can try optimize and cache with the internal tables such as schema tables to fetch updated information.