This is Below Node Graph Data With MSSQL DB
This is Below Edge Graph Data With MSSQL DB
This is Currently showing Node Graph and title this type But Not showing anther property values and styling which I have mentioned in database like subtitle, cpu, memory, c_disk_size, d, c_disk_size color, d_color on node
and Hover of Edge mainStat and secondaryStat is not visible
Here Is my configuration in Node and Edge
This is for reference of what I want It to look like
And Version is @10.2.3
Hello, you can change the MS SQL query for node from current to this:
SELECT TOP (1000) [id] as id
,[title] as title
,[sub_title] as subTitle
,[cpu] as mainStat
,[memory] as SecondaryStat
,[c_disk_size] as arc__cpu
,[d] as arc__memory
,[c_disk_size_color] as arc__cpu_color
,[d_color] as arc__memory_color
,[detail]
FROM [Users].[dbo].[Servers]
and edge query from current to this:
SELECT TOP (1000) [id]
,[source]
,[target]
,[main_stat] as mainStat
,[secondary_stat] as secondaryStat
,[detail_one] as detail__1
FROM [Users].[dbo].[Edge]
Now, after applying the above-mentioned two queries, you will be able to see data on the Grafana node graph, but the color will still not be there.
To set the color, you can see the panel option available on the right-hand side of the grafana panel, and here you can see the nodes section. Here, one arc section will be there, and just below it, one add arc button. Click on this button and then select the arc__cpu option and assign color to it. Now click on the below-situated add arc button and select the arc__memory section. This should solve your issue regarding data not being visible and arc colors not being visible.
Thank you so much to solve my problem. 
Now it’s working.
Hi @henilvaland @shahnawazvhora7333, I am new to Grafana and had a query : Can we use JSON data format to configure a Node Graph in Grafana ?
For example can we use something like this :
[
{
"fields": [
{
"name": "id",
"type": "string",
"config": {
"links": [
{
"title": "test data link",
"url": "",
"internal": {
"query": {
"scenarioId": "logs",
"alias": "from service graph",
"stringInput": "tes"
},
"datasourceUid": "gdev-testdata",
"datasourceName": "gdev-testdata"
}
}
]
},
"values": [
"root",
"service:1",
"service:2",
"service:3",
"service:4",
"service:5",
"service:6",
"service:7",
"service:8",
"service:9"
]
},
{
"name": "mainstat",
"type": "number",
"config": {
"displayName": "Transactions per second"
},
"values": [
0.5269084489952305,
0.3186172070712774,
0.0217189888767102,
0.23881712564156032,
0.8115396296859896,
0.9600485890145185,
0.8605002419520664,
0.6896544605115285,
0.7066672691468294,
0.9905411582046693
]
},
{
"name": "secondarystat",
"type": "number",
"config": {
"displayName": "Average duration"
},
"values": [
0.5360624488395105,
0.8088904153561247,
0.3949131736355005,
0.40714005398818776,
0.9925655948029481,
0.8141737809302889,
0.35716677938480146,
0.18012858235383256,
0.7106872573185647,
0.2455825750261207
]
},
{
"name": "arc__success",
"type": "number",
"config": {
"color": {
"fixedColor": "green",
"mode": "fixed"
},
"displayName": "Success"
},
"values": [
1,
0.009825831912042116,
0.6809865086881657,
0.02142287422487632,
0.5066214145905183,
0.5801643496033606,
0.6150000368161581,
0.561365727033396,
0.8082503303402178,
0.2160674573708321
]
},
{
"name": "arc__errors",
"type": "number",
"config": {
"color": {
"fixedColor": "red",
"mode": "fixed"
},
"displayName": "Errors"
},
"values": [
0,
0.9901741680879579,
0.3190134913118343,
0.9785771257751237,
0.49337858540948165,
0.4198356503966394,
0.3849999631838419,
0.43863427296660396,
0.19174966965978224,
0.7839325426291679
]
}
],
"meta": {
"preferredVisualisationType": "nodeGraph"
},
"name": "nodes"
},
{
"name": "edges",
"fields": [
{
"name": "id",
"values": [
"root--service:1",
"root--service:2",
"root--service:4",
"root--service:6",
"service:1--service:3",
"service:2--service:5",
"service:2--service:7",
"service:3--service:1",
"service:4--service:6",
"service:5--service:7",
"service:5--service:8",
"service:6--service:9",
"service:6--service:2"
],
"type": "string",
"state": null
},
{
"name": "source",
"values": [
"root",
"root",
"root",
"root",
"service:1",
"service:2",
"service:2",
"service:3",
"service:4",
"service:5",
"service:5",
"service:6",
"service:6"
],
"type": "string",
"config": {},
"state": null
},
{
"name": "target",
"values": [
"service:1",
"service:2",
"service:4",
"service:6",
"service:3",
"service:5",
"service:7",
"service:1",
"service:6",
"service:7",
"service:8",
"service:9",
"service:2"
],
"type": "string",
"config": {},
"state": null
}
],
"meta": {
"preferredVisualisationType": "nodeGraph"
},
"length": 13
}
]
And also, if I want to use SQL then, how will we storing things like config.displayName in the table ?
Also please provide any resources (if you have) for configuring advanced properties of nodes like color, displayName, etc.
Thanks !!
Hey @sahayyash9
Sorry for late replay, I am little bit busy now.
to store data like config.displayName in table that i haven’t tried to store in sql tables but i think there might be some way to store and to give answer of your first question we can not use json data with existing database but we can surely bind CSV data using infinity database which you can find in add connection section and from here you might be able to bind JSON as well(not 100% sure) with infinity, with use of sql if you are able to add config.displayName then it is surely possible to add data it in grafana.
I hope this helps.
Hey @shahnawazvhora7333
Thanks for the response.
I don’t find it possible to set properties like “displayName” using a SQL datasource. But I found a plugin : Nodegraph API Datasource Plugin which let’s us consume an API as a datasource for Grafana Node graph. This plugin lets us set properties like displayName, arc__color.
Thanks again !!