Credit usage monitoring in Snowflake - Mini Project: Build & Apply

Credit usage monitoring

📖 Scenario: You work as a data engineer managing Snowflake cloud data warehouse resources. Your team wants to monitor credit usage by different warehouses to control costs.Snowflake charges credits based on warehouse usage. Monitoring credit consumption helps avoid surprises in billing.

🎯 Goal: Build a simple Snowflake SQL script that queries credit usage per warehouse, filters by a threshold, and displays the results.This will help your team quickly see which warehouses are using the most credits.

📋 What You'll Learn

Create a table variable with sample warehouse credit usage data

Add a threshold variable to filter warehouses by minimum credits used

Write a query to select warehouses exceeding the threshold

Display the filtered results

💡 Why This Matters

🌍 Real World

Monitoring credit usage in Snowflake helps control cloud costs and optimize resource allocation.

💼 Career

Data engineers and DevOps professionals use such queries to build cost monitoring dashboards and alerts.

1

Create sample warehouse credit usage data

Create a table variable called warehouse_usage with columns warehouse_name (string) and credits_used (number). Insert these exact rows: ('WH_A', 120), ('WH_B', 80), ('WH_C', 200).

Snowflake

-- Create table variable warehouse_usage with sample data
-- Your code here

Need a hint?

Use a CTE (WITH clause) to create warehouse_usage with the exact rows.

2

Add a credit usage threshold variable

Create a variable called credit_threshold and set it to 100 to filter warehouses with credits used above this value.

Snowflake

WITH warehouse_usage AS (
  SELECT 'WH_A' AS warehouse_name, 120 AS credits_used
  UNION ALL
  SELECT 'WH_B', 80
  UNION ALL
  SELECT 'WH_C', 200
)

-- Set credit_threshold variable to 100
-- Your code here

Need a hint?

Use a CTE named credit_threshold with a single column value set to 100.

3

Select warehouses exceeding the credit threshold

Write a SELECT query joining warehouse_usage and credit_threshold to return warehouse_name and credits_used where credits_used is greater than credit_threshold.value.

Snowflake

WITH warehouse_usage AS (
  SELECT 'WH_A' AS warehouse_name, 120 AS credits_used
  UNION ALL
  SELECT 'WH_B', 80
  UNION ALL
  SELECT 'WH_C', 200
),
credit_threshold AS (
  SELECT 100 AS value
)

-- Select warehouses with credits_used > credit_threshold.value
-- Your code here

Need a hint?

Use a simple join in the FROM clause and filter with WHERE.

4

Display the filtered credit usage results

Run the full query to display the warehouses with credits used above the threshold. The output should show warehouse_name and credits_used columns.

Snowflake

WITH warehouse_usage AS (
  SELECT 'WH_A' AS warehouse_name, 120 AS credits_used
  UNION ALL
  SELECT 'WH_B', 80
  UNION ALL
  SELECT 'WH_C', 200
),
credit_threshold AS (
  SELECT 100 AS value
)
SELECT warehouse_name, credits_used
FROM warehouse_usage, credit_threshold
WHERE credits_used > credit_threshold.value

-- Run the query to display results
-- Your code here

Need a hint?

Run the query as is. The output should list warehouses WH_A and WH_C with their credits used.