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

Grafana Dashboards
,
1

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
1,abc
2,def

Query2 result
order_id,user_id
1,1
2,1

Transform result
user_id,order_id,name
1,2,abc

Expected transform result
user_id,order_id,name
1,1,abc
1,2,abc

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

Thanks in advance!

2

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
3

Welcome

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

4

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

5

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

6

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

7

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