Skill UI

This skill manages the complexities of Clari API version changes, ensuring smooth transitions (e.g., v3 to v4). It guides developers through detecting schema drift, performing data field compatibility checks, and executing necessary database migrations (SQL/Python), ensuring reliable data pipelines after platform updates.

This comprehensive checklist guides users through critical operational readiness steps for a ClickHouse production deployment. It covers server tuning (config.xml), schema design best practices, robust backup strategies (S3), detailed monitoring setup (Prometheus/Grafana), security hardening, and application integration verification. Use this document before go-live, during major upgrades, or when auditing production systems to ensure maximum stability and performance.

This expert acts as a dedicated data analysis partner for Product Managers. It helps users explore data, write complex queries (e.g., SQL, BigQuery), analyze key metrics, and create structured dashboards. Use this tool when you need to derive actionable insights from complex datasets, compare user cohorts, or understand product performance trends to inform critical business decisions.

This skill guides the systematic process of conducting comprehensive academic literature reviews. It allows users to search multiple biomedical, scientific, and technical databases (e.g., PubMed, arXiv, Semantic Scholar) to synthesize current knowledge. The output generates professionally formatted reports (Markdown/PDF) with verified citations, and mandatorily integrates AI-generated scientific schematics to enhance visualization and depth, suitable for research papers, meta-analyses, and state-of-the-art reports.

This guide provides comprehensive technical instructions for optimizing Palantir Foundry costs. Learn to use incremental transforms to drastically reduce compute rebuilds, right-size Spark profiles based on data volume, and migrate from expensive API polling to efficient, event-driven webhooks, ensuring both cost efficiency and system stability.

Performs rigorous, zero-context verification of all quantitative claims, comparisons, and scope statements reported in a research paper against the raw evidence files. It is designed to detect confirmation bias, such as rounding errors, data cherry-picking, or misreported deltas, ensuring strict fidelity between published claims and underlying raw results. Ideal for pre-submission quality control.

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