Skill UI

This comprehensive skill guides users through the entire lifecycle of developing AI agent skills. From initial concept (Understand) to structured design, writing the core skill logic, rigorous testing, and final performance optimization. It ensures skills are robust, accurate, and highly triggerable across any domain, including engineering, content creation, and research.

This guide details how to use Skyvern's AI-powered Command Line Interface (CLI) for advanced browser automation. Users can perform tasks such as quick data validation, structured data extraction, form filling, secure login, and building complex, multi-step, reusable workflows across various websites. It offers solutions for scenarios where deterministic selectors fail.

A comprehensive guide for deep debugging complex Snowflake issues. This guide covers advanced techniques including detailed query profiling (spill analysis), diagnosing lock contention and transaction conflicts, analyzing metadata operations, and optimizing partition usage. Use it when standard troubleshooting fails to address slow queries or warehouse performance bottlenecks.

This comprehensive guide provides blueprints for implementing optimal Snowflake data architectures. It covers diverse patterns, including traditional data warehouses, Lakehouse designs using Iceberg tables, decentralized Data Mesh structures, and advanced data sharing and Snowpark native patterns. Use this when designing enterprise data platforms across varying scales.

This comprehensive guide demonstrates how to establish a robust Continuous Integration/Continuous Deployment (CI/CD) pipeline for Snowflake data warehousing. It integrates SchemaChange for managing version-controlled database migrations, GitHub Actions for automated testing and deployment triggering, and Terraform for provisioning and managing underlying Snowflake infrastructure (databases, warehouses, roles). Use this when setting up reliable, repeatable, and automated deployment workflows.

A comprehensive quick reference guide for diagnosing and resolving common operational and compilation errors encountered when working with Snowflake. It provides actionable solutions for issues like 'Object Does Not Exist', connectivity failures, authentication problems, and SQL syntax mistakes across various programming languages and drivers (Python, Node.js).

A comprehensive guide for executing core Snowflake data loading workflows. This covers setting up stages (S3, GCS, Azure), defining file formats (CSV, JSON, Parquet), and using COPY INTO for bulk loading. It also details advanced continuous ingestion using Snowpipe, enabling real-time data synchronization from cloud storage into Snowflake tables.

Master the creation of robust ELT (Extract, Load, Transform) data pipelines within Snowflake. This guide demonstrates advanced data orchestration using Snowflake Streams for Change Data Capture (CDC), Tasks for scheduled transformations and DAG management, and Dynamic Tables for declarative, auto-refreshing data models. Ideal for building sophisticated, scalable data warehousing solutions.

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.

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.

Master the setup of enterprise-grade Role-Based Access Control (RBAC) within Snowflake. This guide covers defining custom role hierarchies, managing system roles, granting granular object privileges, and integrating advanced security features like SAML/OIDC-based Single Sign-On (SSO) and SCIM for automated user provisioning. Essential for implementing least-privilege access patterns and robust data governance.

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.