Skill UI

A comprehensive guide on implementing AWS CloudTrail log analysis for robust security monitoring, threat detection, and forensic investigation. Learn how to configure CloudTrail, use Amazon Athena for SQL querying, and leverage CloudWatch Logs Insights and SIEM integration to identify unauthorized access, privilege escalation, and suspicious API activity across AWS services.

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.

Analyzes Excel and CSV uploads with DuckDB, inspecting schemas, running SQL, summarizing statistics, and exporting results so users can explore structured data efficiently.

A high-performance library built on Polars for advanced genomic interval operations and bioinformatics file I/O. It provides robust support for core interval arithmetic (overlap, merge, complement) and reading/writing major formats like VCF, BAM, BED, and GFF. Features include out-of-core streaming, cloud-native I/O (S3, GCS, Azure), and a powerful SQL interface, making it ideal for large-scale genomic research.

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

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.

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.

This expert acts as a dedicated data analysis partner for Product Managers. It helps users explore data, write complex queries (e.g., SQL, BigQuery), analyze key metrics, and create structured dashboards. Use this tool when you need to derive actionable insights from complex datasets, compare user cohorts, or understand product performance trends to inform critical business decisions.

This skill allows for the generation and execution of complex, optimized SQL queries to derive deep business insights. It supports sophisticated data workflows, including multi-table joins, multi-dimensional analysis (e.g., trend analysis, attribution modeling, comparative analysis), and subsequent recommendations for appropriate data visualizations (e.g., line charts, waterfall charts). It goes beyond simple SELECT statements by planning the query structure, handling schema relationships, and ensuring adherence to best practices.

This guide identifies and provides solutions for common anti-patterns and mistakes when working with Snowflake. It covers best practices in SQL writing, warehouse resource management, data loading strategies (e.g., using MERGE), and access control setup. It is essential for auditing existing deployments, onboarding new users, or performing code reviews to ensure cost efficiency and data integrity.