Skill UI

This skill allows for the generation and execution of complex, optimized SQL queries to derive deep business insights. It supports sophisticated data workflows, including multi-table joins, multi-dimensional analysis (e.g., trend analysis, attribution modeling, comparative analysis), and subsequent recommendations for appropriate data visualizations (e.g., line charts, waterfall charts). It goes beyond simple SELECT statements by planning the query structure, handling schema relationships, and ensuring adherence to best practices.

This skill provides comprehensive SQL queries and procedures to analyze and optimize Snowflake usage costs. It covers budgeting via resource monitors, right-sizing compute warehouses, tuning auto-suspend settings, and minimizing storage costs. Use it when reviewing billing, implementing cost controls, or reducing credit consumption in your Snowflake environment.

This comprehensive guide details how to implement robust data governance and privacy controls within Snowflake. Learn to apply column-level masking policies, row access policies, and object tagging to secure PII data. It provides practical SQL examples for achieving GDPR/CCPA compliance, managing data subject rights (access, erasure, rectification), and setting up automated data retention tasks.

This guide provides minimal working examples for connecting to Snowflake and executing core SQL operations. It comprehensively covers connection setup, running simple SELECT queries, creating databases and tables, and performing parameterized inserts using both Python and Node.js. It is ideal for initial environment setup, testing the Snowflake SDK, or learning fundamental data warehouse interactions.

This guide identifies and provides solutions for common anti-patterns and mistakes when working with Snowflake. It covers best practices in SQL writing, warehouse resource management, data loading strategies (e.g., using MERGE), and access control setup. It is essential for auditing existing deployments, onboarding new users, or performing code reviews to ensure cost efficiency and data integrity.

This guide provides a comprehensive methodology for load testing and capacity planning within Snowflake data warehouses. It covers optimizing query performance by adjusting warehouse sizes (Scale UP), simulating high concurrency using multi-threading (Scale OUT), and configuring advanced scaling policies (Standard, Economy, Maximized). Users can benchmark critical queries using SQL and simulate real-world user traffic using Python, ensuring robust and cost-efficient production environments.

This guide provides a comprehensive method for setting up Snowflake observability. It teaches how to leverage built-in ACCOUNT_USAGE views to monitor critical metrics such as query performance (latency, error rates), credit consumption, and storage growth. Furthermore, it demonstrates how to implement automated alerts for operational issues (e.g., high failure rates, stuck warehouses) and export metrics to external monitoring systems like Grafana or Prometheus.

A comprehensive guide to optimizing query performance in Snowflake. Learn advanced techniques such as implementing clustering keys, utilizing materialized views, leveraging result caching, and analyzing query profiles. This guide also covers best practices for warehouse tuning and optimizing common SQL anti-patterns to ensure efficient data querying and cost management.

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.

Generate data analysis reports by exploring database tables, running multidimensional SQL queries, performing deep attribution analysis, and outputting dynamic HTML visual reports with ECharts for business, trend, and KPI scenarios.

Logic Lens is an advanced AI skill that performs deep, formal logic-driven code review. Unlike standard linters, it analyzes code for complex issues like race conditions, security vulnerabilities (SQL injection, XSS), type safety flaws, and algorithmic errors across 9 critical risk categories. It is ideal for pre-merge PR reviews, auditing sensitive code paths, and refactoring complex business logic.

This skill fetches and compares live pricing for various Azure services, such as Virtual Machines, Storage, and SQL Databases. It utilizes the Azure Retail Prices API to allow users to check costs in specific geographic regions or compare the same service across multiple regions, helping them find the most cost-effective deployment option.