Applies to: Databricks Runtime
Caches contents of a table or output of a query with the given storage level in Apache Spark cache. If a query is cached, then a temp view is created for this query. This reduces scanning of the original files in future queries.
CACHE [ LAZY ] TABLE table_name [ OPTIONS ( 'storageLevel' [ = ] value ) ] [ [ AS ] query ]
See Automatic and manual caching for the differences between disk caching and the Apache Spark cache.
Only cache the table when it is first used, instead of immediately.
Identifies the Delta table or view to cache. The name must not include a temporal specification. If the table cannot be found Databricks raises a TABLE_OR_VIEW_NOT_FOUND error.
OPTIONS ( ‘storageLevel’ [ = ] value )
storageLevelkey and value pair. A warning is issued when a key other than
storageLevelis used. The valid options for
An Exception is thrown when an invalid value is set for
storageLevelis not explicitly set using
OPTIONSclause, the default
storageLevelis set to
A query that produces the rows to be cached. It can be in one of following formats: