Adding measurements to an SQL collector

measurements can be added to an sql collector by manually adding measurements bulk importing measurements docid\ ocuypopzcouihwwzc vj7 manually add a measurement follow the guide on docid\ u5 07ylms2jix9kz m lb for general instructions on how to create a measurement once the collector is successfully configured, you can add one or more measurements a measurement defines which results from your sql query map into historian to create a new measurement manually, open the measurements page in the factry historian web interface and click + create measurement basic settings measurementkey maps the measurement key column from the query result (required) for example, looking at this query from the docid\ jgcek7sjj 9dntsxr9zqt select s id as measurement key, s value as value, s timestamp as ts, s updated as updated, 'good' as quality, t line nr as tag line nr from sensors s inner join tags t on s pk = t sensor pk where updated > ?; the output might look like this measurement key value ts updated quality tag line nr sensor temp 14 2025 09 10 00 00 30z 2025 09 10 02 00 42z good 45 sensor volume 100 2025 09 10 00 13 45z 2025 09 10 00 15 30z good 6 sensor weight 66 2025 09 10 00 21 40z 2025 09 10 00 33 30z good 2 in this case, you would enter sensor temp , sensor volume , or sensor weight as the measurementkey when creating a measurement in historian