Credit usage monitoring in Snowflake - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is credit usage in Snowflake?

Credit usage in Snowflake measures the amount of compute resources consumed. Credits are used when warehouses run queries or perform tasks.

beginner

How can you check credit usage for your Snowflake account?

You can query the ACCOUNT_USAGE schema, especially the WAREHOUSE_METERING_HISTORY view, to see credit usage details over time.

intermediate

What SQL command shows credit usage for warehouses in the last 7 days?

SELECT WAREHOUSE_NAME, SUM(CREDITS_USED) AS TOTAL_CREDITS FROM SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY WHERE START_TIME >= DATEADD(day, -7, CURRENT_TIMESTAMP()) GROUP BY WAREHOUSE_NAME;

beginner

Why is monitoring credit usage important in Snowflake?

Monitoring credit usage helps control costs, optimize warehouse sizes, and avoid unexpected charges by understanding resource consumption.

intermediate

What is a practical way to automate credit usage alerts in Snowflake?

You can create scheduled tasks that query credit usage and send notifications (e.g., email) when usage exceeds thresholds.

Which Snowflake view provides detailed credit usage per warehouse?

A WAREHOUSE_METERING_HISTORY

B QUERY_HISTORY

C LOGIN_HISTORY

D DATABASE_STORAGE_USAGE_HISTORY

The WAREHOUSE_METERING_HISTORY view shows credit usage details for warehouses.

What does one Snowflake credit represent?

A One user login session

B One gigabyte of data stored

C One hour of compute usage on a single credit unit warehouse

D One query executed

One credit equals one hour of compute on a 1-credit warehouse.

Which SQL function helps calculate credit usage over the last 30 days?

A DATEADD

B DATEDIFF

C CURRENT_DATE

D TO_TIMESTAMP

DATEADD is used to subtract days from the current date to filter recent usage.

Why should you monitor credit usage regularly?

A To create more warehouses

B To avoid unexpected billing and optimize resource use

C To backup data faster

D To increase query speed automatically

Regular monitoring helps control costs and optimize warehouse performance.

What Snowflake feature can automate credit usage checks?

A Streams

B External Functions

C Materialized Views

D Scheduled Tasks

Scheduled Tasks can run queries periodically to monitor credit usage.

Explain how to monitor credit usage in Snowflake using SQL queries.

Think about querying usage history and grouping data.

Describe why monitoring credit usage is important and how automation can help.

Consider cost management and proactive notifications.