Which of the below commands will use warehouse credits?

Question

Options

• ASHOW TABLES LIKE 'SNOWFL%';
• BSELECT MAX(FLAKE_ID) FROM SNOWFLAKE;
• CSELECT COUNT(*) FROM SNOWFLAKE;
• DSELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;

• A
  6% (1)
• B
  94% (17)

Explanation

In Snowflake, virtual warehouse credits are consumed only when compute is required to process a query against actual table data. SHOW TABLES LIKE 'SNOWFL%' (option A) is a metadata operation served directly from Snowflake's metadata layer - it does NOT require a running warehouse and costs no credits. Options B, C, and D are all SELECT statements that query table data (MAX, COUNT, COUNT with GROUP BY), which require an active virtual warehouse to execute, thus consuming credits. The key distinction is metadata operations vs. data operations: metadata queries are free; any query touching table rows uses warehouse compute.

No community discussion yet for this question.