importing dashboards

[pmpetit]

Hello,
i deploy pgwatch2 using a helm Release component.
importing dashboard is quite tricky. For the moment i am not able to make it run.

here is the error message

k apply -f grafana-dashboards.yaml
error: error parsing grafana-dashboards.yaml: json: offset 2: invalid character '{' looking for beginning of object key string

here is the helm release, as you can see i do not download the source

---
apiVersion: helm.toolkit.fluxcd.io/v2beta1
kind: HelmRelease
metadata:
  name: pgwatch2
  namespace: my-system
spec:
  releaseName: pgwatch2
  timeout: 10m
  interval: 10m
  chart:
    spec:
      chart: "helm-chart"
      version: "v1.10.0"
      sourceRef:
        kind: GitRepository
        name: cybertec-postgresql
        namespace: my-system
      interval: 1m

  valuesFrom:
  - kind: Secret
    name: pgwatch2-values
    optional: false

  postRenderers:
    # Instruct helm-controller to use built-in "kustomize" post renderer.
    - kustomize:
        patchesJson6902:
          - target:
              version: v1
              kind: Deployment
              name: pgwatch2-daemon
            patch:
              - op: add
                path: /spec/template/spec/volumes/-
                value:
                  name: instance-volume
                  secret:
                    secretName: pgwatch2-monitoreddb
              - op: add
                path: /spec/template/spec/containers/0/volumeMounts
                value:
                  - name: instance-volume
                    mountPath: /tmp/config
              - op: add
                path: /metadata/annotations
                value:
                  "secret.reloader.stakater.com/reload": "pgwatch2-values,pgwatch2-monitoreddb"
              - op: add
                path: /spec/template/spec/nodeSelector
                value:
                  "usage" : "tools"
              - op: add
                path: /spec/template/spec/tolerations
                value:
                  - "operator" : "Exists"
                    "effect"   : "NoExecute"
                  - "effect"   : "NoSchedule"
                    "operator" : "Exists"
              - op: add
                path: /spec/template/spec/containers/0/resources
                value:
                  limits:
                   cpu: "2500m"
                   memory: "1024Mi"
                  requests:
                   cpu: "1000m"
                   memory: "256Mi"
              - op: add
                path: /spec/template/spec/containers/0/volumeMounts/-
                value:
                  name: custom-metrics
                  mountPath: /pgwatch2/metrics/pgbouncer_stats/0/metric.sql
                  subPath: pgbouncer.sql
              - op: add
                path: /spec/template/spec/containers/0/volumeMounts/-
                value:
                  name: custom-metrics
                  mountPath: /pgwatch2/metrics/stat_activity_realtime/10/metric.sql
                  subPath: stat_activity_realtime.sql
              - op: add
                path: /spec/template/spec/containers/0/volumeMounts/-
                value:
                  name: custom-metrics
                  mountPath: /pgwatch2/metrics/index_col_stats/10/metric.sql
                  subPath: index_col_stats.sql
              - op: add
                path: /spec/template/spec/volumes/-
                value:
                  name: custom-metrics
                  configMap:
                    name: pgwatch2-custom-metrics

Is there a more simple way to import dashboards in grafana ?

thanks

[pashagolub]

Hello. @yanchenko-igor do you have an opinion on this topic? I'm not that much into helm charts, sorry