Skill UI

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 static analysis tool that audits SQL code for common cost and performance anti-patterns (e.g., full-table scans, Cartesian joins). It calculates a query health score (0-100) for data warehouses like BigQuery, Snowflake, and Redshift, providing a prioritized, actionable plan with concrete fixes and estimated cost savings. Essential for FinOps and data quality assurance.

This skill analyzes your data warehouse to pinpoint stale, unused, or redundant tables that contribute to unnecessary storage costs. It classifies waste patterns (e.g., Zombie, Temporary) and computes safety tiers, helping users understand which assets can safely be dropped or archived to optimize spending and improve data governance.

This skill facilitates the extraction of population-scale (cohort-level) clinical text from Electronic Health Records (EHR) or FHIR data warehouses using the FHIR Bulk Data Access ($export) operation. It manages the asynchronous job kickoff, polling, and downloading of NDJSON files. The resulting data stream is designed to be fed in batches into OpenMed for mandatory de-identification and Named Entity Recognition (NER) analysis.

Expert data engineer specializing in scalable data pipelines, modern data warehouses, lakehouse architectures, and real-time streaming. Proficient in Apache Spark, dbt, Airflow, Kafka, and cloud-native platforms (AWS, Azure, GCP). Focuses on reliable, performant, and cost-effective data solutions with strong emphasis on data quality and governance.

Analyze data coverage gaps, create monitors for warehouse tables and AI agents. Provides use-case analysis, data quality monitoring, and agent observability. Helps identify unmonitored tables with anomalies and generate monitoring configurations via MCP tools.

Diagnose slow data pipeline jobs, expensive queries and latency regressions using Monte Carlo cross-platform observability, with a tiered approach that bridges jobs to tables and drills into root causes across Airflow, dbt, Databricks and warehouses.

An expert agent designed to collect critical data assets—including metadata, data lineage, and query logs—from any data warehouse platform. It uses the push ingestion API to send this data directly to Monte Carlo. This method is essential for integrating data sources that cannot be reliably covered by standard pull collectors, such as custom lineage paths or historical query logs.

This skill analyzes data warehouses to identify stale, unused, or redundant tables that increase storage costs. It classifies waste patterns, computes safety tiers, and supports category drill-downs. Compatible with Snowflake, BigQuery, Redshift, and Databricks. Use it when users ask about storage optimization, cost reduction, or cleanup opportunities.

A static analysis tool that audits SQL code for common cost and performance anti-patterns (e.g., full-table scans, Cartesian joins). It calculates a query health score (0-100) for data warehouses like BigQuery, Snowflake, and Redshift, providing a prioritized, actionable plan with concrete fixes and estimated cost savings. Essential for FinOps and data quality assurance.

This skill helps plan and review read-only data warehouse analysis with explicit scope, privacy, and validation checks. It turns business questions into reproducible analysis plans without assuming specific schemas. It identifies needed data, reviews proposed queries for risks like grain or privacy, and ensures results are communicated accurately. Suitable for authorized data warehouse usage, query review, and analysis documentation while avoiding administrative tasks.