Overlap Depth in Snowflake refers to the number of times a specific micro-partition is referenced by different queries or jobs. In simpler terms, it measures the degree of data sharing among concurrent queries.

Average Depth is a metric that calculates the average overlap depth across all micro-partitions in a table. It provides a measure of the overall data sharing efficiency within a table.

Why Overlap Depth Matters:

Query Performance: Higher overlap depth can lead to improved query performance, as data is already cached in memory and can be reused by multiple queries.

Resource Utilisation: Efficient data sharing can reduce the need for additional data transfers and processing, optimising resource utilisation.