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.

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

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