There are 3 types of caching.

1-Databricks SQL UI caching,

2-Query results caching ,

3-Delta caching .

(1) does not get invalidated. It's like your BI dashboard. BI dashboard needs to be manually refreshed.

(2) and (3) gets auto invalidation.

pls check for more info

https://docs.databricks.com/sql/admin/query-caching.html?&_ga=2.127387341.1940992691.1634591660-2391...