Efficient way to join multiple data sources to one main data source (lat/long) without duplicating queries in Geomap?

Grafana Geomap Panel
,
1

Hi Grafana community,

I’m trying to find an efficient way to join multiple data sources in Grafana.

Here’s my setup:

  • I have one main data source that contains the longitude and latitude (this is the base for my visualization).

  • I also have three other independent data sources that I want to join individually with the main one (same join key, different metrics).

What I want conceptually is:

Main (lat, long)
  ⟂ Join DS1
  ⟂ Join DS2
  ⟂ Join DS3

So the main data source stays the same, and each additional data source is joined to it separately.

However, the only solution I’ve found so far is to duplicate the main query for each additional data source, which means:

  • Repeating the same main query multiple times

  • Higher maintenance effort

  • Potential performance issues

I was wondering:

  • Is there a more efficient or recommended approach to do this in Grafana?

  • Is this possible using Transformations, mixed data sources, or backend joins?

  • Or is duplicating the main query currently the only supported way?

Any best practices or design patterns for this kind of setup would be really appreciated.

Thanks in advance!

Weekly Community Recaps - 3 Feb