How will you monitor how much credit is getting burnt for the auto clustering in the past week for a specific table?

You have turned on auto clustering in your table.

How will you monitor how much credit is getting burnt for the auto clustering in the past week for a specific table?
A . Run the below query select * from
table(information_schema.automatic_clustering_history(date_range_start=>dateadd(d, -7, current_date), date_range_end=>current_date, table_name=>’mydb.myschema.mytable’));
B. SHOW AUTO CLUSTERING INFO
C. SHOW CLUSTERING INFO

View Answer

Answer: A

Explanation:

Learn this not just for the certification purpose but for the actual work you will do. It is very important to

monitor how much credit is being consumed by auto clustering. This is the query you can run to find that

out. Ideally, you should output the result of this query and feed it to TABLEAU or any other BI reporting

tool to monitor this cost metrics.

https://docs.snowflake.com/en/sql-reference/functions/automatic_clustering_history.html#automatic-clust

ering-history