Query caching

Preview

This feature is in Public Preview. Contact your Databricks representative to request access.

Databricks SQL supports the following types of query caching:

  • Databricks SQL UI caching: Per user caching of all query and dashboard results in the Databricks SQL UI.

    During Public Preview, the default behavior for queries and query results is that both the queries results are cached forever and are located within your Databricks filesystem in your account. You can delete query results by re-running the query that you no longer want to be stored. Once re-run, the old query results are removed from cache.

  • Query results caching: Per cluster caching of query results for all queries through SQL endpoints.

  • Delta caching: Local SSD caching for data read from data storage for queries through SQL endpoints.

    The query results caching and Delta cache affect queries in the Databricks SQL UI and BI and other external clients.