Grafana maps with rockset and dynamodb

user_2269200 0
Viewed 207

Hy all, i am using grafana with rockset to collect real time series form our dynamodb database, but we have the next problem in the plugin maps.

My data with the next query:

select country,real,_event_time from commons.Players

is

'US' '0.5' '2020-05-27T08:40:51.548000Z',
'UK' '0.2' '2020-05-27T08:40:50.548000Z'

I read that i must pase the country code in the group by:

select 
 country,sum(real) as total ,_event_time 
from commons.Players 
group by _event_time,country

but this doesn't work, I select the correct type of location data (countries) but impossible to see anything.

I don't have problem with any kind of graph but in the map is impossible to my to see the information. I have read documentation and really I don't understand the query that i must use in this part to see the data.

Thanks for everything.

rockset grafana amazon-dynamodb real-time
1 Answers

You didn't post your panel configuration so it is blind guess. Use query:

SELECT
  _event_time AS "time",
  country AS "code",
  real
FROM commons.Players

and configure Map Data Options->Location Data: countries to "translate" 2 letter country code to map coordinates.

user_33486040
Related