Disable caching in Serverless SQL Warehouse
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-16-2025 12:41 PM
I have Serverless SQL Warehouse claster, and I run my sql code in sql editor. When I run query for the first time I see it take 30 secs total time, but all next time I see in query profiling that it gets result set from cache and takes 1-2 secs total time.
Even when I stop my serverless warehouse cluster and start it again it uses cache.
Even when I create totally new serverless sql warehouse cluster with a new name and cluster id it uses cache from the previous one.
My questions are:
1. Why doesn't it clear the cache when I stop and start my serverless sql warehouse cluster ?
2. Why does it use cache from the previous cluster , even when I create totally new serverless sql warehouse cluster with a new name and cluster id?
3. Why doesn't work this setting SET use_cached_result = false on serverless sql warehouse cluster? And also I think it doesn't work on Classic and Pro I think.
4. Is it possible somehow disable using cache in serverless sql warehouse cluster?