https://community.databricks.com/t5/data-engineering/how-to-get-the-table-reference-of-cached-query-results/m-p/2698#M26 <P>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. </P><P></P><P>The ask is similar to Snowflake RESULT_SCAN <A href="https://docs.snowflake.com/en/sql-reference/functions/result_scan" target="test_blank">https://docs.snowflake.com/en/sql-reference/functions/result_scan</A></P><P></P><P>Do Databricks have something equivalent?</P> Thu, 22 Jun 2023 22:01:39 GMT whleeman 2023-06-22T22:01:39Z https://community.databricks.com/t5/data-engineering/how-to-get-the-table-reference-of-cached-query-results/m-p/2698#M26 <P>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. </P><P></P><P>The ask is similar to Snowflake RESULT_SCAN <A href="https://docs.snowflake.com/en/sql-reference/functions/result_scan" target="test_blank">https://docs.snowflake.com/en/sql-reference/functions/result_scan</A></P><P></P><P>Do Databricks have something equivalent?</P> Thu, 22 Jun 2023 22:01:39 GMT https://community.databricks.com/t5/data-engineering/how-to-get-the-table-reference-of-cached-query-results/m-p/2698#M26 whleeman 2023-06-22T22:01:39Z https://community.databricks.com/t5/data-engineering/how-to-get-the-table-reference-of-cached-query-results/m-p/2699#M27 <P>Hi @MAN LI​&nbsp;</P><P></P><P>Great to meet you, and thanks for your question! </P><P></P><P>Let's see if your peers in the community have an answer to your question. Thanks.</P><P></P> Fri, 23 Jun 2023 07:08:43 GMT https://community.databricks.com/t5/data-engineering/how-to-get-the-table-reference-of-cached-query-results/m-p/2699#M27 Anonymous 2023-06-23T07:08:43Z