Skill UI

Provides a comprehensive checklist for deploying Hex data analytics integrations into production. It covers critical operational best practices, including API key management, rate limit handling, error resilience (circuit breakers, exponential backoff), and robust monitoring strategies. This guide ensures that data pipelines are deployed reliably, minimizing downtime and guaranteeing consistent, high-quality data reporting for go-live scenarios.

This guide provides robust solutions for handling Hex API rate limits, implementing backoff, and ensuring idempotent API calls. It includes a rate limiter class and a retry mechanism with exponential backoff. Use this when building reliable data pipelines, running large-scale batch analytics, or integrating Hex into CI/CD environments where API call throttling is expected.

This guide provides comprehensive technical instructions for optimizing Palantir Foundry costs. Learn to use incremental transforms to drastically reduce compute rebuilds, right-size Spark profiles based on data volume, and migrate from expensive API polling to efficient, event-driven webhooks, ensuring both cost efficiency and system stability.

A structured guide for setting up a robust local development environment for Palantir Foundry data pipelines. This workflow enables users to run Python transforms and unit tests using PySpark against sample data, and mock the Foundry API client, ensuring fast, isolated iteration cycles before deploying code to the official Foundry environment. Ideal for data engineers and developers building complex ETL logic.

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 comprehensive guide details the process of implementing a secure and robust system for handling Palantir Foundry webhook events. It covers key steps including API-based webhook registration, mandatory signature verification with replay protection, sophisticated event routing for various object lifecycles (create, update, delete), and ensuring idempotent processing using caching mechanisms like Redis. Use this when external microservices must react reliably and immediately to changes within the Foundry Ontology or data assets.

This guide provides a comprehensive workflow for searching and retrieving biomedical literature from PubMed and NCBI. It covers advanced query construction using MeSH terms and specific field tags, advanced filtering (date, publication type), and a repeatable programmatic workflow using NCBI E-utilities (esearch, efetch). Essential for researchers conducting systematic reviews and literature monitoring.

A comprehensive guide for authors and developers on managing, writing, and validating Power Query M expressions within semantic model partitions. Covers critical concepts such as Query Folding for performance optimization, best practices for filtering and type handling, and advanced techniques for testing M code using the Power Query API.

This comprehensive guide details the programmatic management of semantic model refreshes using the Power BI Enhanced Refresh REST API and Fabric CLI. It covers the entire refresh lifecycle, including resolving model IDs, validating baseline data, triggering various refresh types (full, data-only, calculate), monitoring status, and performing robust post-refresh validation. Essential for automating ETL and data pipeline processes in a modern data platform.