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...

[Kaniz]

Hi @Andrew Fogarty​ , Just a friendly follow-up. Do you still need help, or @Prabakar Ammeappin​'s response help you to find the solution? Please let us know.

[auser85]

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

[Kaniz]

@Andrew Fogarty​ , Awesome!

I'm glad we were able to resolve your problem. Thank you for marking the best answer, though!