UNCACHE TABLE

Applies to: Databricks Runtime

Removes the entries and associated data from the in-memory and/or on-disk cache for a given table or view in Apache Spark cache. The underlying entries should already have been brought to cache by previous CACHE TABLE operation. UNCACHE TABLE on a non-existent table throws an exception if IF EXISTS is not specified.

Syntax

UNCACHE TABLE [ IF EXISTS ] table_name

See Disk cache vs. Spark cache for the differences between disk caching and the Apache Spark cache.

Parameters

• table_name

  Identifies the Delta table or view to cache. The name must not include a temporal specification or options specification.

Examples

Serverless compatibility

Databricks recommends moving away from UNCACHE TABLE as it is not compatible with Databricks serverless compute architecture. Serverless compute auto-tunes caching, so manual cache management is unnecessary.

SQL

> UNCACHE TABLE t1;

Related statements

• CACHE TABLE
• CLEAR CACHE
• REFRESH TABLE
• REFRESH CACHE
• REFRESH FUNCTION