Query caching

Preview

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

Databricks SQL Analytics supports the following types of query caching:

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

    Note

    During Public Preview, the default behavior for queries and query results is that both the queries results are cached forever and are located within the Databricks control plane. 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 SQL Analytics UI and BI and other external clients.