Skill UI

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.

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.

A comprehensive guide to designing high-performance schemas in ClickHouse. Learn how to select the optimal MergeTree engine (e.g., ReplacingMergeTree, AggregatingMergeTree), structure the ORDER BY key for maximum query efficiency, and implement effective partitioning strategies for large-scale analytical workloads and ETL processes.

This comprehensive guide provides advanced techniques to diagnose and significantly boost ClickHouse query performance. It covers analyzing slow queries using system tables, optimizing ORDER BY keys, implementing data skipping indexes (Bloom, Set, MinMax), utilizing projections for pre-aggregation, and fine-tuning server settings and materialized views. Essential for high-volume OLAP environments.

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 comprehensive guide details best practices for securing a ClickHouse deployment. It covers essential security measures including role-based access control (RBAC) for granular user permissions, implementing row-level security for multi-tenancy, configuring network IP restrictions, enabling TLS encryption, and setting up detailed audit logging. Use this when hardening a production ClickHouse instance or enforcing strict data governance.

This guide details how to set up and execute large-scale, distributed GPU training jobs on the CoreWeave platform. It covers both single-node multi-GPU setups and multi-node training utilizing PyTorch DDP and Kubernetes resources (A100/H100). This workflow is ideal for fine-tuning large language models (LLMs) or running complex deep learning models that require high-performance, shared-storage compute clusters.

This guide demonstrates how to deploy GPU workloads on the CoreWeave platform using Kubernetes (kubectl). It covers deploying vLLM inference services for large language model (LLM) testing and running batch CUDA jobs for benchmarking. This is ideal for users running their first GPU workloads, testing inference pipelines, or verifying cluster access on bare-metal GPU nodes (A100, H100).

This skill guides users on automating fundraising workflow analysis using local data methods. Since Finta lacks a public API, it teaches how to export pipeline data (CSV) and use Python (Pandas) scripts to calculate key funnel metrics, conversion rates, and generate detailed weekly reports for investor tracking and reporting.

This skill guides the setup of CI/CD pipelines for Hex data analytics projects using GitHub Actions. It enables running automated unit tests on pull requests and triggering live project runs on the main branch merge. Use this when establishing automated testing workflows, validating data transformation logic, or integrating Hex outputs into a continuous delivery process.

This guide provides comprehensive solutions for diagnosing and resolving common errors and exceptions encountered while using the Hex data platform. It covers critical areas such as API authentication failures (401, 403), resource not found issues (404), rate limiting, and various run status errors (ERRORED, KILLED). This is essential for debugging failed data requests, optimizing integration workflows, and ensuring stable data analytics pipelines.

Provides a comprehensive checklist for deploying Hex data analytics integrations into production. It covers critical operational best practices, including API key management, rate limit handling, error resilience (circuit breakers, exponential backoff), and robust monitoring strategies. This guide ensures that data pipelines are deployed reliably, minimizing downtime and guaranteeing consistent, high-quality data reporting for go-live scenarios.