Skill UI

Automates creating and validating GCP BigQuery views with best-practice guidance, production-ready code snippets, and integrations for Vertex AI, Cloud Run, Firebase, and similar services to keep analytics workloads consistent.

Automates Google BigQuery workflows via Rube MCP and Metabase, letting you run native SQL/MBQL queries, fetch metadata, and explore schemas before querying.

This skill provides comprehensive guidelines for monitoring Granola usage, tracking team meeting patterns, and building detailed analytics dashboards. It guides users in defining critical metrics (e.g., adoption rate, efficiency score) and establishing robust data pipelines. Users can stream meeting metadata from Granola to data warehouses like BigQuery, enabling deep, customizable reporting and automated weekly insights via services like Zapier and Slack.

An advanced workflow orchestrator designed to perform multi-phase, deep-dive schema optimization on large datasets (e.g., BigQuery exports). It systematically analyzes schema structure, identifies unused or redundant fields, assesses potential impact, and generates a comprehensive, actionable report with recommended optimization strategies and estimated savings.

Reviews Python + BigQuery pipelines to flag runaway costs, missing dry-run safeguards, unsafe backfills, write idempotency issues, and monitoring gaps, returning a structured report with exact function/line references for minimal fixes.

Builds a robust, automated workflow to export critical sales data—including forecasts, quota details, adjustments, and CRM totals—from Clari CRM to a designated data warehouse. The pipeline supports multiple targets like Snowflake, BigQuery, and PostgreSQL, ensuring that real-time revenue intelligence is available for advanced analytics and business reporting.

A comprehensive guide to setting up and securing API access for Clari. Learn how to generate API tokens, configure environment variables, and test connectivity to export critical revenue intelligence and forecast data to data warehouses like Snowflake or BigQuery. Includes steps for both standard Clari API and Copilot API integration.

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.

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.

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 tool allows users to export comprehensive marketing data—including KPIs, contact records, campaign results, and performance snapshots—to external data stores. It supports integration with BigQuery for advanced data warehousing, Google Sheets for stakeholder collaboration, and Supabase for custom application development. The process includes mandatory PII handling, schema transformation, and detailed execution summaries to ensure compliance and data integrity for downstream analytics and reporting.

This skill analyzes data warehouses to identify stale, unused, or redundant tables that increase storage costs. It classifies waste patterns, computes safety tiers, and provides actionable cleanup recommendations. Supports Snowflake, BigQuery, Redshift, and Databricks. Ideal for reducing cloud infrastructure expenses and optimizing data governance.