intelligent consolidation

Intelligent consolidation is a capability within the Data Discovery feature. Intelligent consolidation is supported via the /api/v1/discovery endpoints (search, consolidate, preview). Intelligent consolidation uses TableIndex for semantic table matching. The Consolidation Mechanism produces Consolidated Unified Views by creating session-scoped joins of related tables for queries. Budget Analysis Cluster requires the Consolidation Mechanism to combine related budget tables for comprehensive queries. Payment & Commitment Cluster requires the Consolidation Mechanism to join payments and commitments data tables appropriately. Monitoring Cluster requires the Consolidation Mechanism to unify monitoring-related datasets for accurate analysis. Grant Administration Cluster relies on the Consolidation Mechanism for consolidating grant-related tables for analysis. The Data Consolidation capability creates TEMP VIEWs to unify related tables into a single schema for Arctic SQL generation. The Discovery Service implements the Schema consolidation mechanism to improve query success rate. The Schema consolidation mechanism is planned to be presented via the Schema relationship explorer UI for better transparency and customization. The Data Consolidation process stores consolidation recommendations for user reference. The Data Consolidation capability creates TEMP VIEWs to unify related tables into a single schema for Arctic SQL generation. The Discovery Service implements the Schema consolidation mechanism to improve query success rate. The Schema consolidation mechanism is planned to be presented via the Schema relationship explorer UI for better transparency and customization. The Data Consolidation process stores consolidation recommendations for user reference. Intelligent consolidation improves the query success rate from 70% to over 95%. The Data Discovery feature uses intelligent consolidation to enhance query success rate.