I tried doing like:
CREATE GLOBAL TEMPORARY VIEW table_filtered_cache AS select
 
Got an error

"GLOBAL TEMPORARY VIEW is not supported on a SQL warehouse."