Which of the below commands will use warehouse credits?

Which of the below commands will use warehouse credits?
A . SHOW TABLES LIKE ‘SNOWFL%’;
B. SELECT MAX(FLAKE_ID) FROM SNOWFLAKE;
C. SELECT COUNT(*) FROM SNOWFLAKE;
D. SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;

View Answer

Answer: D

Explanation:

Try this your self

CREATE TABLE SNOWFLAKE (FLAKE_ID INTEGER, UDEMY_COURSE VARCHAR);

INSERT INTO SNOWFLAKE VALUES(1111, ‘SNOWFLAKE’);

INSERT INTO SNOWFLAKE VALUES(2222, ‘SNOWFLAKE’);

SHOW TABLES LIKE ‘SNOWFL%’;

SELECT MAX(FLAKE_ID) FROM SNOWFLAKE;

SELECT COUNT(*) FROM SNOWFLAKE;

SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;

After running this, please go to query profile for each of the queries . You can go to query profile, by going to HISTORY and then clicking on the relevant query id.

You will see all the queries except the one using GROUP BY has used the metadata repository to retrieve the results. Any query which uses metadata repository does not consume any compute credit.