It is not a good idea to disable the Snowflake Query Cache. However, in some scenarios, it is helpful to be able to do it, for example, during performance testing.

You can achieve this by adding a pre-hook to the model in question, as the following code snippet shows:

{{
  config(
    pre_hook="alter session set USE_CACHED_RESULT  = FALSE",
  )
}}