Skill UI

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.

This skill provides comprehensive methods and code examples for optimizing spending on Bright Data services. It covers product selection (Proxy vs. API), implementing caching strategies, bulk usage monitoring, and setting budget alerts, ensuring cost efficiency in large-scale web scraping projects.

This guide provides a quick reference for diagnosing and fixing the top common errors encountered in ClickHouse, including syntax errors, memory limit issues, write permission failures, and data type mismatches. It offers specific error codes, root causes, and actionable SQL solutions for smooth database operation and complex analytics.

This comprehensive guide provides advanced workflows for interacting with ClickHouse. It covers efficient bulk data insertion (CSV, JSON), complex analytical querying (funnel analysis, retention), implementing materialized views for pre-aggregation, and utilizing powerful window functions. Ideal for building high-performance OLAP dashboards and executing large-scale data transformations.

This specialized skill provides a robust framework for tracking and updating financial investment signals. It systematically assesses the impact of new market information—such as breaking news or price movements—on existing investment theses. The system determines if a signal is Strengthened, Weakened, Falsified, or Unchanged, providing a crucial layer of continuous signal validation for sophisticated financial decision-making.

This advanced technique allows users to identify an obscure actor by linking indirect clues across three domains: the director, the film's characteristics, and the actor's biographical details. It is essential when direct searches fail, using the director's work or a film's context as the primary entry point to resolve the actor's identity.

This skill aggregates real-time financial information, including hot news articles and market trends from multiple sources (e.g., Weibo, Zhihu). It is also capable of retrieving structured data from prediction markets like Polymarket. Use this when you need a unified, comprehensive view of the financial market landscape, spanning breaking news, aggregated sentiment, and forward-looking market predictions.

A comprehensive skill designed for finance-related information retrieval. It provides dual search capabilities: real-time web searching across multiple engines (Jina, DDG, Baidu) for general market knowledge, and Retrieval-Augmented Generation (RAG) for querying local, proprietary document stores (e.g., daily news). Ideal for financial analysts needing both broad market context and specific internal data insights.

Execute comprehensive, asynchronous transcription workflows using AssemblyAI. This tool handles file upload, queues jobs, and provides advanced audio intelligence features. Capabilities include speaker diarization, sentiment analysis, named entity recognition (NER), topic categorization (IAB), content safety moderation, and sensitive PII redaction. Ideal for processing meeting recordings, interviews, and large volumes of spoken content.