Based on the documentation, it seems you need a column called "geojson" in your dataset that would contains a json object of a shape (as ST_AsGeoJSON from PostGIS would return).
Instead of using a database as the source, I want to present a geojson document I get from an HTTP GET request. I used the Grafana Infinity plugin and managed to parse a geojson document to get each features as an entry:
{
"geometry": {
"coordinates": [
-82.32861328125,
27.946462631225587
],
"type": "Point"
},
"id": "fd3c336a-c877-415a-8321-f371d20c3444",
"properties": {
"dynamic_message_function": "speed-limit",
"dynamic_message_text": "60",
"static_sign_text": "SPEED LIMIT"
},
"type": "Feature"
}
This way, I would have expected OrchestraCities map to be able to parse and display it, but nothing shows up on the map.
I tried to manually add a "data layer" and select the query and geojson field, but it doesn't help.