Skill UI

Provides comprehensive programmatic control over Apify's core data infrastructure, including Datasets, Key-Value Stores, and Request Queues. This skill allows users to perform CRUD operations on various storage types, manage data persistence, and orchestrate complex, multi-stage data pipelines (e.g., scrape -> transform -> export). Ideal for building robust, end-to-end web scraping and data processing automation workflows.

A comprehensive workflow designed to build deep revenue analytics dashboards using exported Clari data. It calculates key metrics such as forecast accuracy, pipeline coverage ratios, and tracks representative performance changes. Ideal for financial analysts and sales managers needing to assess revenue health and forecast reliability.

This skill provides a robust solution for monitoring critical forecast changes within Clari. Since Clari lacks native real-time webhooks for all data, this system implements change detection by polling periodic data exports and comparing current snapshots against historical records. It calculates the percentage change and can trigger immediate alerts via platforms like Slack, ensuring users are always aware of significant shifts in revenue forecasts or sales pipelines.

A comprehensive guide to reducing expenses on ClickHouse Cloud. Learn advanced techniques for storage optimization (compression, TTL), compute resource tuning (scaling, thread limits), and query efficiency improvements. Use this when managing data budgets or analyzing high ClickHouse billing charges.

This guide details how to configure and manage resource constraints in ClickHouse, addressing server-side limits, user quotas, and connection management. Use it when encountering "too many simultaneous queries," optimizing resource usage, or implementing robust rate limiting strategies in applications connecting to ClickHouse. Covers SQL quota setup and client-side pooling techniques.

A comprehensive guide and implementation template for building robust data ingestion pipelines into ClickHouse. Supports multiple sources including HTTP webhooks (with batching), Kafka streams, S3, and direct SQL inserts. Demonstrates best practices for data handling, such as deduplication using ReplacingMergeTree and monitoring query logs, ensuring reliable, scalable data analytics.

This skill provides the core mechanism for integrating Hex into external data pipelines. It enables triggering, monitoring, and managing Hex projects (e.g., via Airflow or Dagster) programmatically. Users can implement parameterized runs, execute multi-step ETL workflows sequentially, and handle status polling and error management, making it ideal for production data orchestration.

A comprehensive guide and toolkit for optimizing Hex platform costs. This resource details strategies for reducing compute expenditure by auditing seat licenses, consolidating data connections, and optimizing notebook run schedules. It includes code examples for implementing result caching and usage monitoring to prevent unexpected billing spikes.