Querying InfluxDB IOx Using the New Flight SQL Plugin for Grafana

The InfluxData team has released a new plugin for Grafana called Flight SQL, which allows users to perform SQL queries directly against InfluxDB IOx and other storage engines compatible with Apache DataFusion. This plugin provides a quick start guide for installation, configuration, and usage, including examples of how to configure the plugin, deploy Telegraf and Grafana using Docker-compose, and create custom SQL functions to handle complex time series calculations. The plugin also introduces new global variables that can be used to make queries dynamic and streamlined, such as $__timeRange(time) and $__dateBin(time). With Flight SQL, users can now leverage the power of SQL on top of InfluxDB IOx, enabling more advanced data analysis and visualization capabilities.