I am using
Mixed data sources
I used two postgres databases
Created two queries
In transform section, used
Join by field => Mode as
but it is returning only one row instead of many-to-many join
Expected transform result
Is many-to-many or many-to-one join not possible in grafana ?
Thanks in advance!
Welcome to the community support forums !!
We are excited that you joined our OSS community. Please read about some of the FAQs in the community
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?
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