Differences

This shows you the differences between two versions of the page.

--- watchdogs:creating_a_new_metric [2023/03/06 16:13] – 10.91.110.100
+++ watchdogs:creating_a_new_metric [2023/03/06 16:16] (current) – 10.91.110.100
@@ Line 12: / Line 12: @@
     - Highly recommend using a database querying workbench such as **DBeaver** or **MySQL Workbench** to quickly test your SQL queries, as this will also allow you to preview what data you can expect to receive.
   - When your desired query is made, run the **sql_exporter** file in a terminal and observe any errors that may occur. If it runs successfully, a port will be displayed on screen.
+    - //Note that the **values** field is mandatory. Structure your SQL query around this.//
   - Use this port number and go to http://localhost:[PortNumber]. Here, you can review whether your metrics got picked up correctly, and if they didn't, an error will be printed to the terminal where you have **sql_exporter** running. Analyse and fix this error if needed.
   - Once your metric has been checked and it works correctly when using **sql_exporter**, you can move on to the next step.

Internal Errigal Collaboration Wiki