How to clear last run query (Cache) in snowflake
You can clear cache by setting ALTER SESSION UNSET USE_CACHED_RESULT =FALSE;
To get plan of last query Id , you can use below stmt:
select system$explain_plan_json(last_query_id()) as explain_plan;
You can clear cache by setting ALTER SESSION UNSET USE_CACHED_RESULT =FALSE;
To get plan of last query Id , you can use below stmt:
select system$explain_plan_json(last_query_id()) as explain_plan;