Hacker News Reader

Eh, many of them have some way to provide markup even when its informational only, because a data catalog or dictionary is required to use most large olap products.

eg Snowflake lets you declare all the foreign keys you want, but does nothing with that info except let you use it.

View on HN

Sure, some OLAP databases let you add the same metadata that a OLTP database gives you as constraints, especially enterprise ones. A lot still don't, like Clickhouse, afaik.

No OLAP database I know of would let you encode other semantic layer things like aggregations or metrics. EG defining a DAU/MAU metric as "The distinct number of users logged in that day vs the distinct number of users in the 28 days before that day."

Those types of definitions usually live in the semantic layer or bi layer, which a LLM analysis tool would need to solve for.

Reply on news.ycombinator.com