Are there best practice around caching of tables on newly started endpoints to ensure more performant querying in DBSQL?

Anonymous
Not applicable
 

User16783853906
Databricks Employee
Databricks Employee

DBSQL supports the following types of query caching which can help with the query performance -

1). Databricks SQL UI caching

2). Query results caching

3). Delta caching

Please check here for details -

https://docs.databricks.com/sql/admin/query-caching.html#query-caching