Skill UI

This comprehensive guide details strategies for migrating enterprise data platforms to Databricks. It provides PySpark examples for discovery, schema mapping (converting types from Hadoop, Snowflake, etc.), and executing robust data transfer methods like SYNC, DEEP CLONE, and CTAS. Use this when moving data from legacy sources like Hadoop, Snowflake, or Redshift to a modern Delta Lake environment.

Automates Snowflake data warehouse workflows via the Composio MCP, letting you list databases, schemas, and tables, run SQL (SELECT, DDL, DML), and integrate those operations into cross-app pipelines for faster data ops.

Comprehensive Snowflake development assistant covering SQL best practices, dynamic tables, streams, tasks, Snowpipe, Cortex AI functions/agents, Snowpark Python, dbt integration, performance tuning, and security hardening for production data platforms.

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 reference architecture provides a comprehensive blueprint for building a robust revenue intelligence data platform integrated with Clari. It covers the entire data lifecycle, including API data extraction (ETL pipeline), data warehousing design (Snowflake/BQ), change detection logic, and advanced analytics/alerting layers. Use this guide when designing a scalable forecast tracking system, planning complex data integrations, or establishing best practices for enterprise revenue analytics.

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

A comprehensive guide for executing core Snowflake data loading workflows. This covers setting up stages (S3, GCS, Azure), defining file formats (CSV, JSON, Parquet), and using COPY INTO for bulk loading. It also details advanced continuous ingestion using Snowpipe, enabling real-time data synchronization from cloud storage into Snowflake tables.

Master the creation of robust ELT (Extract, Load, Transform) data pipelines within Snowflake. This guide demonstrates advanced data orchestration using Snowflake Streams for Change Data Capture (CDC), Tasks for scheduled transformations and DAG management, and Dynamic Tables for declarative, auto-refreshing data models. Ideal for building sophisticated, scalable data warehousing solutions.

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.