Grafana administration

It is possible to import a corrupt dashboard json file into Grafana. After this, the dashboard cannot be deleted through the web interface.

These steps will delete it.

Get credentials for the cluster.

gcloud container clusters get-credentials ...

Log into the grafana server pod:

kubectl exec -it grafana-server-468492966-zc61m /bin/bash

Install the sqlite3 command line tool. (Grafana saves it's data to an sqlite3 db).

apt-get update
apt-get install sqlite3

Open the grafana db and delete the offending dashboard.

sqlite3 /var/lib/grafana/grafana.db

# search for your dashboard name.
select slug from dashboard;

# delete your dashboard by name.
delete from dashboard where slug='my-bad-dashboard-name';

# exit sqlite3.
.exit

Now reload your grafana page and the offending dashboards should be absent.