Remix.run Logo
aszen 5 days ago

I like the idea of a semantic Layer but don't think defining it in yaml is the right way to go about it.

Semantic Layer needs proper language and tooling support which Malloy provides.

articsputnik 5 days ago | parent | next [-]

Yeah, we still have them, MDX before and now DAX :)

I curate some more on here in case of interest: https://www.ssp.sh/brain/data-modeling-languages.

efromvt 5 days ago | parent | next [-]

MDX really did it well, at the cost of being impenetrable to the average user - the drilldown flow you could get is still hard to beat.

Shameless plug for the list, though - I work on https://github.com/trilogy-data/pytrilogy - semantic layer directly embedded in otherwise (mostly) SQL syntax.

I'll do an equivalent example on the taxi dataset when I have some time.

12ian34 5 days ago | parent | prev [-]

oh nice resource! Another one for you: https://docs.lightdash.com/guides/lightdash-semantic-layer#l...

kermatt 5 days ago | parent | prev | next [-]

Anything but a markup language / JSON.

12ian34 5 days ago | parent | prev [-]

are you using Malloy in prod? Do you know of anyone? I remember the Malloy hype during Data Council in 2023. Haven't heard about it since.

aszen 4 days ago | parent | next [-]

Not yet, but it's evolving nicely, the original team moved to meta and they are building interesting open source stuff

apwell23 5 days ago | parent | prev [-]

i think the team moved on from google ( which was the main benefactor)