Forum Discussion
Snowflake - disable cache (USE_CACHED_RESULT = FALSE)?
Hi! I'm trying to test true performance of a report and wondering it it's possible to disable Snowflake cache in Power BI connection -> USE_CACHED_RESULT = FALSE? https://docs.snowflake.net/m...
You can’t change it directly through PowerBI, but as a work-around, you can change the default setting of the user account attached to PowerBI in Snowflake with:
ALTER ACCOUNT SET USE_CACHED_RESULT = FALSE
Make sure you are in the right context as you have to be an ACCOUNTADMIN to change these settings.
Check that the changes worked with:
SHOW PARAMETERS
Be careful with this though, remember to turn on USE_CACHED_RESULT after you’re done your testing.
Hope this helped!