Grafana with MariaDB source not working

My HA is configured to use mariaDB for all the sensor history.
Is it possible to display grafana dashboards by connecting directly to the mariaDB (without using influx)
I have added the mariaDB as a data source (using mySQL) however I am getting nothing when trying to run a query against it:


Bad query or just not possible to do?