https://community.databricks.com/t5/data-engineering/schedule-reload-of-system-information-schema-for-external-tables/m-p/20067#M13544 <P>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?</P> Tue, 29 Nov 2022 12:27:04 GMT ossinova 2022-11-29T12:27:04Z https://community.databricks.com/t5/data-engineering/schedule-reload-of-system-information-schema-for-external-tables/m-p/20067#M13544 <P>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?</P> Tue, 29 Nov 2022 12:27:04 GMT https://community.databricks.com/t5/data-engineering/schedule-reload-of-system-information-schema-for-external-tables/m-p/20067#M13544 ossinova 2022-11-29T12:27:04Z https://community.databricks.com/t5/data-engineering/schedule-reload-of-system-information-schema-for-external-tables/m-p/20068#M13545 <P>You can try optimize and cache with the internal tables such as schema tables to fetch updated information.</P> Tue, 29 Nov 2022 21:28:35 GMT https://community.databricks.com/t5/data-engineering/schedule-reload-of-system-information-schema-for-external-tables/m-p/20068#M13545 Own 2022-11-29T21:28:35Z