Graph with metrics cross data source

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:

  1. mysql dwh: order numbers and ttv value
  2. google analytics: visits
  3. 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 :+1: on the first post

But it sounds like you are looking for this:
https://github.com/metabase/metabase/issues/10273 - upvote by clicking :+1: 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