Which output is provided by both the SYSTEM$CLUSTERING_DEPTH function and the SYSTEM$CLUSTERING_INFORMATION function?

Question

Options

• Aaverage_depth
• Bnotes
• Caverage_overlaps
• Dtotal_partition_count

• A
  88% (23)
• B
  8% (2)
• D
  4% (1)

Explanation

average_depth is the one metric shared by both functions. SYSTEM$CLUSTERING_DEPTH returns a single scalar value - the average depth - representing how many micro-partitions overlap for the given clustering key(s). SYSTEM$CLUSTERING_INFORMATION returns a richer JSON object that includes average_depth alongside additional fields, making average_depth the common denominator.

Options B (notes), C (average_overlaps), and D (total_partition_count) appear only in the JSON output of SYSTEM$CLUSTERING_INFORMATION - they are not returned by SYSTEM$CLUSTERING_DEPTH, which is a focused, single-value function.

Memory tip: Think of SYSTEM$CLUSTERING_DEPTH as the "lite" version - it tells you just the depth. SYSTEM$CLUSTERING_INFORMATION is the "full report" that wraps that same depth value inside a broader JSON object. Whatever the lite version returns, the full report must also contain it - that overlap is average_depth.

No community discussion yet for this question.