what is cache concept in snowflake @TechLearningHub-bs4sg

@TechLearningHub-bs4sg
Cache in Snowflake:
We have cache mechanism in Snowflake to speed up query performance.
We have different types of Cache available in Snowflake

Metadata Cache
Query Result Cache
Warehouse Cache

Metadata Cache:
Metadata caching is maintained in Cloud Service Layer(metadata layer)
Snowflake automatically collects and manages Metadata about Tables and micro-partitions

Metadata cache contains metadata of Tables and Micro partition such as Row count, size of table, MIN, MAX, Count Distinct and NULL count of every column.

Snowflake does not use warehouse to run these queries, This information will be served from metadata.
ex :
Select min(quantity) from sales;
Select max(price) from sales;
Query Result Cache:

Result cache is maintained in Cloud Service Layer.
This contains query results of every query executed in past 24 hours
Query results returned to one user is available to any other user on the system who executes the same query
If the user fires the same query that has already been run, snowflake will return the same result
Virtual Warehouse/Data Cache/SSD Cache:
When the user runs a query in Snowflake, the data is red from the database storage layer into the Virtual warehouse and then operations are performed.
The data which was retrieved from Storage layer will get cached in the SSD disk
Whenever a query is processing, SSD scanned first if the data is not available then Virtual Warehouse pull the data from storage layer
Data in this layer remains active until the warehouse is active and cache get cleared along with warehouse suspension.
How to disable the cache in Snowflake

To disable Result cache you can use below
alter session set use_cached_result = false;

To disable Warehouse or Local Disk cache either you can shut down virtual warehouse from Web UI or you can use below:

alter warehouse COMPUTE_WH suspend

Видео what is cache concept in snowflake @TechLearningHub-bs4sg канала Tech Learning Hub