Re:Dbt to acquire Transform to build out its semantic layer
by pinkbeanz on Thursday February 09, 2023 @01:57PM
(#34729224)
I think that’s still the outstanding question. Tools like Mode and Hex have already started supporting dbt’s metrics layer, but will big players like Looker and Tableau also move to support it? That’s harder to say
Re:Dbt to acquire Transform to build out its semantic layer
by rwhaling on Thursday February 09, 2023 @02:33PM
(#34729935)
One of Transform's strong suits is their Tableau integration - they have really good tooling for pushing metrics out to Tableau, rather than relying on Tableau to pull them in. Apparently AirBnb was/is still a very dedicated Tableau shop.
Re:Dbt to acquire Transform to build out its semantic layer
by apahwa on Thursday February 09, 2023 @03:17PM
(#34730731)
Minerva actually had really poor tableau support as of a year ago, that is something Transform improved on. Most of Minerva consumption was done via Superset, GoogleSheets, and email
Re:Dbt to acquire Transform to build out its semantic layer
by johnito on Sunday February 12, 2023 @05:20AM
(#34761675)
An alternative to Transform that's done an awesome job to integrate with BI tools is Cube.js
Check their website https://cube.dev
For example, if you want to be able to aggregate revenue by subscription plan and by country over year, month or day, then you would have 6+ different aggregations. The more dimensions and time periods you add, the more the various combinations blow out. (I think the formula is dimension permutations multiplied by the number of time periods.) Having a single definition of the metrics prevents errors from occurring in rote implementations of the metrics. A bit like generics, but for queries.
At this point, I'm curious how they manage to make the integrations with different platforms work. (Ultimately, I think that's why they acquired Transform.)