can I add static labels to target?

[free]

can I add static labels to target?

[burningalchemist]

Hi @farodrig,

it's impossible to add static labels to the target afaik, but you can add static labels in the metrics definition. It was merged to master yesterday, so you can define it now within the metrics configuration with static_labels as key/value pair. See the example:

metrics:
  - metric_name: pricing_update_time
    type: gauge
    help: 'Time when prices for a market were last updated.'
    key_labels:
      # Populated from the `market` column of each row.
      - Market
    static_labels:  <-----------
      # Arbitrary key/value pair
      portfolio: income
      testlabel: testvalue
    values: [LastUpdateTime]
    query: |
      SELECT Market, max(UpdateTime) AS LastUpdateTime
      FROM MarketPrices
      GROUP BY Market

[nanawel]

See also a more complete request about this here: #58 (allows reusing collectors config accross different targets)

[SPFZ]

It is missing in https://github.com/free/sql_exporter/blob/master/documentation/sql_exporter.yml