Building a Semantic and Knowledge Layer on BigQuery and Exposing It to Agents
batmanparam · reddit · 2026-09-27
A developer describes building semantic, ontology, and knowledge layers directly on Google BigQuery, their enterprise data platform. Rather than adopting a separate semantic-layer product at this early stage, they've implemented the layers as plain tables.
They're seeking guidance on:
- Best practices and resources for building these layers on top of GBQ
- How to expose the layers to AI agents as tools
- At what point in agent execution these semantic/knowledge tools should be invoked
It's a practical data-platform-meets-agents architecture question, favoring a lightweight, evolvable table-based approach over new middleware.
More from coding & agent
- open-slide 2.0 ships: an agent-first slide framework with visual editor and editable pptx export — CurieuxExplorer · 2026-09-27
- Meta Muse praised for transparency: users can inspect all agent tool-call logs — CurieuxExplorer · 2026-09-27
- Microsoft's Foundry Agents, Toolbox and MCP session heads to Global AI Conference Chennai — lee_stott · 2026-09-27
- One prompt, a hike later: Rust PDF compressor matches ILovePDF, built autonomously by Claude — avt_im · 2026-09-27
- Two days of work six months ago, a few hours today: researcher benchmarks agentic coding's leap — avt_im · 2026-09-27
- GitHub Copilot CLI v1.0.89-5 Adds Claude Code Rules File Support — copilot-cli-release-app[bot] · 2026-09-27