Inner join transform in mixed data source pick only one joined row

I am using Mixed data sources
I used two postgres databases
Created two queries
In transform section, used Join by field => Mode as Inner join

but it is returning only one row instead of many-to-many join

Query1 result
user_id, name

Query2 result

Transform result

Expected transform result

Is many-to-many or many-to-one join not possible in grafana ?

Thanks in advance!

Hi @mir1198yusuf,

Welcome to the :grafana: community support forums !!

We are excited that you joined our OSS community. Please read about some of the FAQs in the community :slight_smile:

As per the documentation, it should be possible to what you want to achieve. However, I do not see a timestamp column in your provided sample so that might be causing problems?

1 Like


Why not join these different tables in one query instead of using grafana transformation?

There is no timestamp column, I want to inner join query 1 and query2 by user_id

Like I said I am using mixed data sources, it means both tables are in different databases, so I cannot join them in same query. thanks

so are you using data sources from 2 different servers or 2 different databases on same server?

Consider it has two different servers altogether and two different postgres database