What Grafana version and what operating system are you using?
What are you trying to achieve?
In a table panel, I have several queries on a MS SQL source and would like to join a query on an InfluxDB (v0) source on a common field.
How are you trying to achieve it?
I have used the Outer join Transform.
The Outer join Transform works among the SQL queries, but when the InfluxDB query is added the join doesn’t happen and all the SQL query results disappear from the table.
What did you expect to happen?
I’d expect that the InfluxDB query results would be added to the table as with the other queries
Can you copy/paste the configuration(s) that you are having problems with?
For example, the SQL queries are like:
SELECT [SiteName] ,[SiteDescription] FROM [foo].[bar].[bas]
The InfluxDB query is
SELECT count("value") FROM "event" WHERE $timeFilter GROUP BY "SiteName"
And the Outer join is done on the field SiteName
Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
Did you follow any online instructions? If so, what is the URL?
I’ve looked up resources s but none was specifically about this issue