finalize-tables

Finalizes harmonized Lance tables into linked, schema-conformant biomedical collections.

7|Updated Feb 21, 2026
One-click install
npx skills add https://github.com/epiblastai/homeobox --skill finalize-tables
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: finalize-tables
Source: https://github.com/epiblastai/homeobox/tree/main/packages/polycomb/skills/finalize-tables
Command: npx skills add https://github.com/epiblastai/homeobox --skill finalize-tables

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires homeobox, lancedb, pandas, pyarrow, polycomb, and includes scripts (resource) components.

What problem does it solve?

This Skill converts independently harmonized Lance tables into a complete, internally linked collection that is ready for ingestion, analysis, and machine learning. It resolves cross-table relationships, assigns required identifiers, preserves auditability for source-data changes, and catches schema or value inconsistencies before downstream use.

Core Features & Use Cases

  • Collection-wide finalization: Processes tables in dependency-aware DAG order so registry targets receive identifiers before referencing tables are linked.
  • Multimodal table integration: Joins feature-space observation tables, preserves ingestion row-order artifacts, and supports both single-modality and multimodal datasets.
  • Deterministic enrichment and validation: Assigns UIDs and dataset identifiers, fills registry keys and derived fields, removes transient or audited leftovers, initializes missing schema columns, and validates every row against its target schema.
  • Fail-loud safeguards: Detects duplicate or unmatched natural keys, conflicting multimodal values, malformed polymorphic relationships, missing required fields, and value-level schema violations instead of silently producing incomplete links.
  • Use Case: After harmonizing datasets from multiple assays, run this Skill to connect observations, datasets, publications, feature registries, and other entities into a validated Homeobox collection ready for ingestion.

Quick Start

Use the finalize-tables skill to finalize the harmonized collection at the specified root against its target schema YAML and perform a dry run before writing changes.

Frequently Asked Questions about finalize-tables

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I validate multimodal Lance tables against a schema before ingestion?

You can validate multimodal Lance tables by finalizing them against target schema YAML. This process resolves cross-table relationships, assigns required identifiers, and validates every row against its target schema to catch inconsistencies before downstream use.

What is the best way to link harmonized biomedical datasets with registry keys?

The best way to link harmonized biomedical datasets is by processing tables in dependency-aware DAG order. This ensures registry targets receive identifiers before referencing tables are linked, successfully filling registry keys and derived fields while preserving source-data auditability.

How do I assign UIDs and dataset identifiers across multiple data modalities?

To assign UIDs and dataset identifiers across data modalities, use a table finalization process that handles multimodal integration. It joins feature-space observation tables and preserves ingestion row-order artifacts for both single-modality and multimodal datasets.

Do I need Homeobox schema models to finalize LanceDB tables?

Yes, Homeobox schema models are required to finalize LanceDB tables. The finalization process relies on Homeobox models alongside LanceDB, PyArrow, pandas, and Polycomb utilities to successfully join, mutate, audit, and validate tables into a linked collection.

Why does table finalization fail on duplicate or unmatched natural keys?

Table finalization fails on duplicate or unmatched natural keys due to fail-loud safeguards. Instead of silently producing incomplete links, the process actively detects duplicate keys, conflicting multimodal values, and malformed polymorphic relationships to prevent schema violations.

Can I dry run schema validation on harmonized collections before writing changes?

Yes, you can perform a dry run for schema validation on harmonized collections before writing changes. The finalization process allows you to specify a collection root and target schema YAML to validate data without committing modifications to the tables.