A Data Engineer needs to know the details regarding the micro-partition layout for a table named Invoice using a built-in function. Which query will provide this information?

Question

Options

• ASELECT SYSTEM$CLUSTERING_INFORMATION('Invoice');
• BSELECT $CLUSTERING_INFORMATION('Invoice');
• CCALL SYSTEM$CLUSTERING_INFORMATION('Invoice');
• DCALL $CLUSTERING_INFORMATION('Invoice');

• A
  86% (56)
• B
  2% (1)
• C
  9% (6)
• D
  3% (2)

Explanation

SYSTEM$CLUSTERING_INFORMATION('Invoice') is the correct Snowflake built-in system function for retrieving micro-partition layout details, and it must be called within a SELECT statement since it returns a result set (scalar function), not a stored procedure. Option B is wrong because Snowflake system functions require the SYSTEM$ prefix - $CLUSTERING_INFORMATION alone does not exist. Options C and D use CALL, which is reserved for stored procedures, not scalar functions - SYSTEM$CLUSTERING_INFORMATION is a function, so CALL is syntactically incorrect regardless of the prefix used.

Memory tip: Think "SELECT SYSTEM$ for Statistics" - all three S's go together. If it starts with SYSTEM$, it's a scalar function you SELECT, not a procedure you CALL.

No community discussion yet for this question.