How to get the table reference of cached query results?

whleeman
New Contributor III

Databricks caches query results for 24 hours. I would like to access the query results as if it is a table so that I can post process it. For example, do another query against it.

The ask is similar to Snowflake RESULT_SCAN https://docs.snowflake.com/en/sql-reference/functions/result_scan

Do Databricks have something equivalent?

Anonymous
Not applicable

Hi @MAN LI​ 

Great to meet you, and thanks for your question!

Let's see if your peers in the community have an answer to your question. Thanks.