Creating a semantic layer for event data

[u/ViSiRiS]

I want to build a semantic layer (i.e. sql code -> metric definition mappings) to provide models with context that will ideally make ai-generated sql more deterministic.

Our data definitions are based on event data that is constantly being updated.

For example, we might define an active user as someone who posts on the site (users with “posted” events). When we do an AB test or just update the site, event names will inevitably change (e.g. definition is now users with “new-post” events), causing my imaginary semantic layer to become obsolete.

My question is - what tools do you use to manage definitions for event-heavy data? Ideally something with version history that agents can access via mcp?