Cache Select on Temp Table?

[auser85]

How might I cache a temp table?

The documentation suggests it is possible: https://docs.databricks.com/spark/latest/spark-sql/language-manual/delta-cache.html

Consider the following on DBR 10.5 and Spark 3.2.1:

```

%python

df.createOrReplaceTempView("changeset");

```

```

CACHE SELECT * from changeset

```

`CACHE supports only SELECT queries with optional WHERE clause, e.g. CACHE SELECT <columns> FROM <table> [ WHERE <predicate> ]`

[Prabakar · Accepted solution]

@Andrew Fogarty​ , Please check if the doc helps you.

https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-syntax-aux-cache-cache-ta...

[auser85]

Thank you! The newer documentation does indeed work for me.