The Denodo Platform is able to support creating a separate temporary table to store data by creating a materialized table or a temporary table. The difference between the two tables is that the materialized table will persist between sessions and the temporary table will be deleted after 48 hours or if the user logs out of the session. It seems like you will need to make a materialized table, but before creating a materialized table, you must enable the cache engine. To do this, follow the steps in the [Configuring the Cache](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/server_configuration/configuring_the_cache/configuring_the_cache#configuring-the-cache) section of the Virtual DataPort Administration Guide.
After configuring the cache, you can use the CREATE MATERIALIZED TABLE command to create the temporary table. You can refer to [Creating Materialized Tables](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/materialized_tables/creating_materialized_tables/creating_materialized_tables) in the Virtual DataPort VQL Guide for more information.
Hope this helps!