Hi guys
I have 3 queries in total. Query 1 decompresses a .ZIP file from a website containing several .CSV files. Queries (2) and (3) filter Query (1) to isolate the appropriate CSV and then perform some ETL.
However, it appears that the website is queried more than once upon refresh. This results in long query time and server load. Is there a way to cache Query (1) so the following two queries which reference it run against a buffered .ZIP?
Thanks,
Simon