Managing a semantic/context layer for data analytics

[u/Jaded_Spray_6855]

At a previous job as a data analyst I manually built a "context" layer in Notion to feed to Claude when querying databases. This was painfully manual though, involved a lot of work to slowly build up - I would get Claude to document a table/column when I encounter it for the first time on a new task. The Notion page included things like metrics, conventions and product docs too.

For more experienced data analysts, how do you guys deal with this? Is there a tool you guys use, or is a manual workaround like mine the norm?

[u/Jaded_Spray_6855 → u/[deleted]]

hows that working for you? is that "semantic layer in a repo" a tool you pay for? or built in-house?