Skill UI

This comprehensive guide teaches users how to set up a ClickHouse database environment. It covers creating a MergeTree table, inserting structured event data using TypeScript, and executing essential analytical queries (e.g., counting, grouping, unique user metrics). Ideal for beginners learning OLAP databases, testing connections, or mastering core data warehousing concepts.

This guide provides comprehensive steps for setting up and authenticating the official ClickHouse client for both Node.js and Python. It covers connecting to ClickHouse Cloud or a self-hosted instance, managing environment variables, and verifying the connection using sample code snippets. Ideal for new ClickHouse projects or integrating data analytics pipelines into existing applications.

A comprehensive tutor designed to build robust statistical thinking. It guides users through the entire data analysis lifecycle, from exploratory data visualization and descriptive statistics to complex hypothesis testing and regression modeling. The focus is on understanding the 'why' and 'how' of statistical logic using real datasets and practical problems, rather than just memorizing formulas. It is tool-agnostic, supporting concepts learned in Python, R, SPSS, or Stata.

This skill provides a comprehensive workflow for generating professional and structured financial reports. It guides the user through planning, writing, and editing various sections, and can also generate necessary chart configurations using visual tools. Ideal for condensing complex financial analysis into clear, actionable reports.

This comprehensive guide demonstrates how to scrape live webpages using Bright Data's Web Unlocker proxy. It details how to bypass advanced anti-scraping mechanisms, such as CAPTCHAs and fingerprinting, automatically. Users are provided with full code examples in both Node.js and Python, showing methods for scraping via the proxy endpoint and through the dedicated REST API. Ideal for starting new scraping projects or integrating Bright Data into existing workflows.

This guide provides production-ready patterns for integrating with Bright Data proxy services. It covers critical aspects like setting up a proxy client, implementing robust retry logic for transient errors (e.g., 502, 503), managing sticky sessions for consistent IPs, and parsing complex HTML responses. Essential for building reliable, high-scale web scrapers using TypeScript and Python.

This guide provides a comprehensive walkthrough for interacting with the Clari API to export critical business data. It covers listing available forecasts, initiating the export of forecast and quota snapshots, monitoring the job status, and ultimately downloading and parsing the structured data. This skill is ideal for testing API connectivity and integrating Clari's revenue intelligence into external data pipelines.

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.

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.