I’d like to query the continuous query configuration parameters from my hosted InfluxDB instance, but obviously I can’t access the config files, like /etc/influxdb/influxdb.conf.
Is there an equivalent to MySQL’s SHOW VARIABLES LIKE '%run-interval%'?
SHOW DIAGNOSTICS will print a “safe” subset of the configuration. Generally this is preferred over inspecting a config file, because SHOW DIAGNOSTICS returns what InfluxDB actually parsed from the config - there’s no room for error of misinterpreting a config setting that looks correct but actually contains a typo and is therefore ignored, for example.