Anvil Data Tables as datasource in Grafana

Anvil Q&A
1

Hello guys,
I just wanted to ask if it is somehow possible to use anvil data tables as the data source for grafana dashboards?

I took a look on the list of grafana compatible data source providers:

And also those available as plugins:

I just wonder which approach should I consider to try to connect anvil data tables as the source for the data in grafana. Write some service that will dump data to csv file, then import that csv into google spreadsheet and then reference such spreadsheet as data source in grafana? Or maybe someone already was trying to achieve something similar and there is something simpler available that I just could not find?

2

I’m not a guy but I’d probably tackle this by creating an http endpoint and using one of the Json plugins for grafana.

1 Like
3

Hi Owen, sorry if it was not appropriate to call forum users as guys. I didn’t mean to offend anybody.

Thanks for your suggestion about Json plugin, I will definitely give it a go. For now I found some other way around how to setup whole infrastructure and connect it to grafana as standard postgres data source.

I started with docker image:
https://hub.docker.com/r/anvilworks/anvil-app-server

And postgres image:
https://hub.docker.com/_/postgres

I created docker-compose yaml file with those 2 above. This file has reference to my anvil app and is pointing anvil-app-server to use custom config file which is using postgres db from other docker image.
That way I can then connect to same postgres db directly from any grafana instance. This setup is also very easy to deploy across various cloud providers like Azure, Digital Ocean, AWS, and others as all we need is simple linux server, docker-compose.yaml, git repo with our anvil client app and we should be ready to go in just couple minutes.

1 Like