[FeatureRequest] YAML support for metrics file

[Supporterino]

Hi,

I’m migrating from iamseth’s oracledb_exporter (https://github.com/iamseth/oracledb_exporter) and built our workflows around defining default and custom metric sets as YAML files because they’re more readable and easier to automate in CI than TOML. I noticed this exporter currently only accepts TOML. Since the exporter’s own configuration is already YAML, are there plans to add native support for metric definitions in YAML?

Thanks for any guidance or timeline you can share.

[markxnelson]

Hi @Supporterino , we've been talking about whether to support YAML as well as (or instead of) TOML. We can certainly look at adding this. If you were willing to share an example file that woudl be great.

[Supporterino]

Hi @markxnelson ,

this is the current YAML we use for the shared memory pools of an instance.

metrics:
  - context: "shared_memory_pools"
    metricsdesc:
      size_mb: "Gauge metric with the size of the shared memory pools in megabytes."
      used_mb: "Gauge metric with the used size of the shared memory pools in megabytes."
      free_mb: "Gauge metric with the free size of the shared memory pools in megabytes."
    labels: [pool]
    request: "SELECT pool, ROUND(SUM(bytes) / 1024 / 1024, 2) AS size_mb, ROUND(SUM(CASE WHEN name != 'free memory' THEN bytes ELSE 0 END) / 1024 / 1024, 2) AS used_mb, ROUND(SUM(CASE WHEN name = 'free memory' THEN bytes ELSE 0 END) / 1024 / 1024, 2) AS free_mb FROM v$sgastat WHERE pool IS NOT NULL GROUP BY pool ORDER BY pool"

If PRs are welcome I can implement the YAML logic and test it in our local setup.

[anders-swanson]

Closed with #302