Skill UI

This comprehensive guide identifies and explains common anti-patterns, gotchas, and integration mistakes when using Clay's data enrichment platform. It details the root causes of credit waste, workflow failures, and data loss, providing actionable fixes for auditing configurations, onboarding new team members, or optimizing existing pipelines.

This skill guides users on how to search for physical monuments, memorials, or landmarks by linking them to their originating historical events. The core technique involves treating the historical event (e.g., a battle, a protest, a significant date) as the primary search anchor, and then locating the associated memorial or structure. It provides structured query templates and anti-patterns to ensure accurate, context-aware geographical and historical information retrieval.

This skill provides comprehensive tools to analyze and engineer protein glycosylation patterns. It scans amino acid sequences for canonical N-glycosylation sequons (N-X-S/T) and predicts O-glycosylation hotspots. Use cases include optimizing therapeutic antibodies, designing vaccine antigens, and characterizing biosimilars by rationally modifying glycan structures for improved stability, function, or immune evasion.

This guide provides a comprehensive reference architecture for building production-ready, enterprise-grade applications on Palantir Foundry. It covers the entire data lifecycle, detailing best practices for the standard data pipeline (Raw > Clean > Model), Ontology design, external API integration patterns, and robust multi-layered security models. Use it when designing, planning, or optimizing complex data infrastructure within Foundry.

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.

This static analysis skill audits SQL queries across major data warehouses (BigQuery, Snowflake, Redshift, Postgres) for performance and cost anti-patterns (e.g., SELECT *, full scans, Cartesian joins). It provides a health score (0-100) and generates a prioritized, actionable cost-reduction plan, detailing the 'why' and the 'how' to fix expensive queries.