Skill UI

This comprehensive benchmark suite evaluates the performance of Vision-Language Models (VLM) on complex video anomaly detection tasks using the SmartHome-Bench dataset. It covers a wide range of real-world smart home scenarios, including security breaches, elderly fall detection, and unusual pet behavior. Unlike single-frame analysis, this benchmark requires deep multi-frame video understanding, making it a robust tool for testing the advanced AI capabilities of video monitoring systems.

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.

Master the deployment of applications connected to Snowflake across various cloud environments, including serverless functions (AWS Lambda, Cloud Run) and containers. This guide covers best practices for secure connection management, connection pooling, handling secrets (like private keys), and ensuring application reliability in production settings.

A comprehensive guide detailing the process of migrating data warehouses to Snowflake from major sources like Amazon Redshift, Google BigQuery, or on-premise databases. This resource covers critical steps including schema conversion (handling dialect differences like STRUCT/ARRAY to VARIANT), robust data transfer methods (S3/Cloud Storage, Python/Pandas), data validation techniques (checksums, row counts), and essential SQL syntax translation patterns.

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.

This comprehensive checklist guides the deployment of Snowflake data pipelines and integrations into a production environment. It covers critical areas such as authentication best practices, warehouse configuration, data pipeline readiness, access control, monitoring setup, and disaster recovery planning. Use it when preparing for a go-live or validating the stability of your production Snowflake setup.

A comprehensive guide to implementing production-grade reliability patterns for Snowflake environments. Covers advanced techniques like Time Travel for point-in-time recovery, cross-region database replication, account failover groups for disaster recovery, and application-level resilience coding (e.g., connection failover logic). Essential for building fault-tolerant, highly available data pipelines.

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.

This skill provides Continuous Integration (CI) testing for applications built with WebContainer and StackBlitz SDK. It utilizes Playwright browser tests to ensure code reliability and functional correctness across various environments. Ideal for developers integrating WebContainers into CI pipelines or working within the StackBlitz development ecosystem.

This comprehensive guide provides solutions for common and complex errors encountered when using WebContainer and StackBlitz environments. It covers essential fixes for cross-origin isolation headers (COOP/COEP), managing WebContainer boot failures using singleton patterns, resolving npm installation hangs, and handling file system errors (ENOENT). Use this skill to stabilize and debug complex web development sandboxes.

Provides a comprehensive production checklist specifically for WebContainer applications built using the StackBlitz SDK. This guide helps developers ensure that their web applications are robust and ready for deployment by checking essential aspects like security headers, cross-browser compatibility, and necessary fallback mechanisms.

This comprehensive guide details essential security practices for deploying WebContainers. It covers implementing Content Security Policy (CSP) headers, ensuring robust sandbox isolation, and performing rigorous input validation to mitigate common web vulnerabilities. Use this when developing applications with WebContainers or the StackBlitz SDK.