Skill UI

Automated guidance for data normalization tool tasks in ML training, offering best practices, production-ready code/configuration generation, and output validation.

This guide provides comprehensive, code-based solutions for diagnosing and fixing common errors encountered in Databricks environments. It covers critical issues such as cluster state failures, Spark OutOfMemory errors, Delta Lake concurrency conflicts, permission problems, and schema mismatches, offering tailored fixes in Python, SQL, and Bash.

This skill detects covert data exfiltration occurring over DNS tunnels. It analyzes DNS query names by computing Shannon entropy, examining query length distributions, and identifying high subdomain cardinality. It is essential for security operations, incident response, and proactive threat hunting when suspicious or encoded DNS activity is suspected.

Core Python library for astronomy and astrophysics workflows, covering units, coordinates, FITS I/O, tables, time systems, WCS, and cosmology. Use when implementing or debugging astronomical data analysis code with Astropy.

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

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

Execute arbitrary PySpark or pure Python code directly on Fabric Spark compute using the Livy API. This method creates ephemeral sessions without generating persistent notebook artifacts. It provides full read/write access to lakehouse Delta tables, making it ideal for agent-driven ETL pipelines, quick data transformations, or analyses where session cleanup is critical. Users must manage the session lifecycle (create, run, and delete).

A static analysis tool that audits SQL code for common cost and performance anti-patterns (e.g., full-table scans, Cartesian joins). It calculates a query health score (0-100) for data warehouses like BigQuery, Snowflake, and Redshift, providing a prioritized, actionable plan with concrete fixes and estimated cost savings. Essential for FinOps and data quality assurance.

This skill utilizes hyperbolic space embedding (Poincare ball model) to represent complex data structures with inherent hierarchy, such as dependency trees, ontologies, or module taxonomies. Unlike standard Euclidean embeddings, hyperbolic space preserves hierarchical distances efficiently, allowing for accurate distance calculations (geodesic distance) that grow logarithmically with tree depth. It is ideal for advanced knowledge graph analysis and code architecture mapping.