Basically I'm worried about the scenario where data that gets cached on Databricks SQL endpoints becomes out of sync with the source Delta table. If that were to happen and data was read from the cache it would be out of date/incorrect.

Is this a concern? Is there a way that the Databricks SQL endpoint will know the cache needs to be refreshed?