Skill UI

This guide outlines the implementation of a production-ready Snowflake data platform using the industry-standard Medallion Pattern (Bronze, Silver, Gold). It provides comprehensive, step-by-step SQL examples covering raw data ingestion (Bronze), data cleansing and typing (Silver), and business-level aggregation (Gold). Use this when designing new data warehouses or establishing robust, layered data architecture standards on Snowflake.

This guide details essential security best practices for Snowflake data warehouses. It covers implementing network policies, managing key rotation, enabling Multi-Factor Authentication (MFA), and securing credentials using secret managers. Use this comprehensive resource to audit security configurations, restrict network access, and enforce least-privilege access within your Snowflake environment.

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.