October 2025 Summaries

AI has become increasingly integrated into business intelligence (BI) tools and analytics workflows, but its effectiveness is often limited by a lack of business-specific context, such as metric definitions and valid join paths, which are typically embedded in SQL, dashboards, and tribal knowledge. A semantic data model can address this issue by consolidating these definitions and rules into a single framework that both humans and AI can interpret consistently. This concept was discussed by Alec Bialosky in a talk at dbt Coalesce, emphasizing the importance of semantic data models for enhancing AI's utility in analytics through shared meaning, query correctness, reasoning context, and automation foundations. The process of building a semantic data model involves identifying key business questions, aligning on core metrics, leveraging existing trusted definitions, making ownership explicit, documenting in plain language, and iterating with feedback. Automating the generation of semantic data models can further streamline this process, with tools like Select Star offering capabilities to reverse engineer and extract metric logic from existing BI tools, thereby accelerating model development and deployment.

Coalesce 2025 in Las Vegas highlighted a significant merger between dbt and Fivetran, and introduced the dbt Fusion engine, signaling a shift towards open data infrastructure and AI-ready analytics. The merger aims to bring ingestion, transformation, and metadata closer together without locking users into a single compute engine, while emphasizing open standards and compatibility across various tools. dbt Fusion, rewritten in Rust, acts as a SQL compiler that optimizes workflows by understanding warehouse dialects and providing real-time feedback, resulting in improved efficiency and reduced costs. AI-ready analytics were emphasized through the dbt MCP server, which facilitates a governed bridge for models and tools, and MetricFlow's open-source return under Apache 2.0, ensuring reliable metrics across platforms. The keynote underscored the importance of reliable metadata and agent-driven workflows to enhance throughput and confidence, suggesting starting with dbt Fusion on small projects and implementing CI diffs and impact analysis to improve workflow efficiency and reliability.

dbt Docs provides a framework for documenting data models, sources, and columns within dbt projects, using YAML files to define and maintain documentation that can be surfaced in BI tools and other platforms. As projects scale, challenges such as maintaining up-to-date documentation, ensuring accessibility for non-technical users, and preventing drift between different tools and documentation sites arise. A hybrid approach, integrating dbt with an automated data catalog like Select Star, is recommended to manage these challenges by drafting in the catalog and syncing updates back to dbt through daily pull requests, ensuring consistency and visibility across the data stack. This approach emphasizes treating documentation like code, with changes managed through pull requests, and encourages placing definitions where users work, such as in BI tool tooltips and lineage displays, to improve engagement and trust. Select Star's dbt Docs Sync supports this by providing a seamless integration that synchronizes documentation changes across platforms, reducing fragmentation and making analytics more consistent and discoverable.