Skill UI

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.

This guide provides comprehensive instructions on managing performance and concurrency within Snowflake. It covers key concepts like warehouse sizing, multi-cluster configuration, and detecting query queuing issues. Users learn how to right-size resources and implement application-level rate limiting to prevent throttling and optimize data warehouse throughput for complex analytics workloads.

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 skill performs a structured Systematic Literature Review (SLR) by analyzing multiple academic papers on a given topic. It searches academic databases (like arXiv), extracts structured metadata (research questions, methodologies, key findings, limitations) from the entire set of papers, and synthesizes overarching themes and research trends. It is ideal for creating comprehensive literature surveys, annotated bibliographies, and cross-paper comparisons, outputting reports in professional citation formats like APA, IEEE, or BibTeX.

A high-performance library built on TileDB for scalable ingestion, efficient storage, and retrieval of genomic variant data (VCF/BCF). It supports incremental sample addition, parallel querying across vast genomic regions, and robust data export for population genomics and cohort studies.

This tool performs a rigorous Level 2 semantic epistemic review of Agent-Native Research Artifacts (ARAs). It assesses six critical dimensions—including evidence relevance, falsifiability, and methodological rigor—to determine the content's intellectual soundness. It is used after initial structural validation to provide objective, constructive criticism, scoring the work from Strong Accept to Reject.

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.

Generates a complete, self-contained HTML dashboard for analytics, admin, or control panel views. It structures the layout with a fixed sidebar, top navigation, KPI cards, and detailed charts (using inline SVG). Ideal when the brief requires visualizing key metrics, performance over time, or operational statistics.

This skill generates a sophisticated, single-screen consumer dashboard mimicking a high-end lifestyle publication's dating column. It moves beyond simple swiping mechanics to visualize complex social metrics, mutual matches, and connectivity trends using editorial typography and restrained design. Ideal for concepts requiring data-driven storytelling about personal or community relationships.

This utility displays the precise, real-time token usage and estimated cost savings for the current session. It reads directly from the internal session log, ensuring objective and accurate data without requiring AI computation. Triggered by /caveman-stats, it provides immediate performance metrics to monitor API costs and usage patterns.