Cache Table

CACHE [LAZY] TABLE [db_name.]table_name

Cache the contents of the table in memory using the RDD cache. This enables subsequent queries to avoid scanning the original files as much as possible.


Cache the table lazily instead of eagerly scanning the entire table.

See Delta and Apache Spark caching for the differences between the RDD cache and the Databricks IO cache.