Skill UI

This comprehensive guide provides step-by-step instructions for upgrading Snowflake drivers (Node.js and Python) and managing complex data warehouse migrations. It covers prerequisite checks, reviewing release notes, handling common API breaking changes (e.g., cursor types, async connections), and performing post-migration validation to ensure application stability during platform or edition upgrades.

Master event-driven patterns within Snowflake using native alerts, email integrations, external functions, and cloud notification services (S3/GCS). This skill is essential for building robust, reactive pipelines that trigger actions (like sending alerts, calling external APIs, or ingesting data) in response to data changes or specific system events. Use cases include data quality checks, real-time monitoring, and automated notifications.

A static analysis tool that audits SQL code for common cost and performance anti-patterns (e.g., full-table scans, Cartesian joins). It calculates a query health score (0-100) for data warehouses like BigQuery, Snowflake, and Redshift, providing a prioritized, actionable plan with concrete fixes and estimated cost savings. Essential for FinOps and data quality assurance.