Hi everyone,
I know ETL is OOT for Metabase and I fully agree with this approach.
What about the possibility to create a report/graph with metrics coming from different database/data-source?
This will just a frontend task and it will enhance 70% of the ETL requests.
Simple use case:
- mysql dwh: order numbers and ttv value
- google analytics: visits
- desiderata: create a dashboard with real
- conversion rate = visits / orders number
- average order value per visit = ttv / visits
I guess we are doing something similar with dashboard where for example we need to sync x axes value (ex. date )
Thanks,
Fabio
Hi @repente
Doing joins across databases is the most request issue - there are workaround, see comments:
https://github.com/metabase/metabase/issues/3953 - upvote by clicking on the first post
But it sounds like you are looking for this:
https://github.com/metabase/metabase/issues/10273 - upvote by clicking on the first post
Ciao @flamber thanks for your answer.
Yes you right it’s more https://github.com/metabase/metabase/issues/10273 where I want the possibility just frontend side to plot or calculate metrics from different sources.
“Join across multiple databases” will not possible and not for this tool, better use ETL like stich data.
Thanks,
Fabio