KaranamS
Contributor III

Hi @dkxxx-rc ,

You can try to create a temp view and cache it. Caching will materialize it in memory.

CREATE TEMP VIEW temp_view AS

SELECT * FROM some_table WHERE condition

CACHE TABLE temp_view

View solution in original post