Project

Snowflake Cost & Query Bottleneck Monitoring Dashboard

AFOUR Technologies

Jun 2023 – Feb 2024

PythonSnowflakeAzure PipelinesMonitoringDashboardsWeb Analytics

Built a web app to monitor Snowflake metrics (compute costs, heavy queries) to identify and reduce bottlenecks; deployed via Azure Pipelines.

Problem

Teams needed clear visibility into Snowflake performance and cost drivers to control spend and reduce slow query bottlenecks.

Solution

Implemented monitoring dashboards and analytics views around Snowflake usage metrics (compute, query hotspots) and automated build/deploy via Azure Pipelines.

Impact

Improved cost awareness by surfacing compute utilization and heavy-query patterns.
Accelerated delivery and release reliability through CI/CD automation.