Skill UI

This guide covers advanced retrieval strategies that significantly boost search quality beyond basic vector similarity search. Techniques include Hybrid Search (combining dense and sparse indexing), Reranking (improving result order), Relevance Feedback (guiding search with iterative user scores), and Maximal Marginal Relevance (MMR) for diversity. Use these methods when standard search results lack relevance, miss critical keywords, or exhibit poor precision.

This workflow utilizes the SerpApi to perform advanced, multi-engine searches across platforms including YouTube, Bing, Google News, Google Shopping, and Google Maps. It is essential for data scraping, SEO research, and building comprehensive search features that require aggregating results from diverse sources beyond standard Google search. Use it to collect videos metadata, product pricing, local business details, and news articles efficiently.

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.

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).

Collects comprehensive diagnostic evidence from Snowflake's ACCOUNT_USAGE views, QUERY_HISTORY, and environment details. This tool is essential for troubleshooting persistent performance issues, connection failures, or preparing detailed support cases for Snowflake support, ensuring all necessary logs, query metrics, and resource usage data are collected in one package.

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.

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.

TileDB-VCF is a high-performance library built on TileDB's sparse array technology, designed for the efficient storage and retrieval of large-scale genomic variant-call data (VCF/BCF). It supports scalable, incremental ingestion of single-sample VCF/BCF files and enables highly efficient parallel querying across vast genomic regions and multiple samples. This tool is essential for building robust population genomics databases, conducting GWAS, and performing large-scale cohort studies.

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.