CSV/SQL Datasource (under development)

Load multiple csv/excel files data into grafana’s dashboards from ftp/sftp servers.

Overview / Introduction

Config Editor

Requirements

• Grafana 9.0+
• FTP or SFTP server
• Grafana LLM app - optional

Features

• Server Health check.
• Files health check.
• Support multiple formats such as CSV, TSV, LTSV, Fixed-Length Format, JSON and JSON Lines.
• Auto-detect supported files.
• Data joins between multiple files.
• SQL query editor in fullscreen
• SQL-like query language.
• SQL syntax highlighting.
• SQL autocomplete.
• SQL validation.
• SQL formatting.
• Support grafana variables.
• Support LLM - Text to SQL using OpenAI.

Limitations

• Every column type is string - no type casting. (Workaround: you can use grafana transformation to make this work)

Todo

• Server Health check.
• Files health check.
• Support CSV.
• Support TSV.
• Support LTSV.
• Support Fixed-Length Format.
• Support JSON.
• Support JSON Lines.
• Auto-detect supported files.
• Data joins between multiple files.
• SQL query editor in fullscreen.
• SQL-like query language.
• SQL syntax highlighting.
• SQL autocomplete.
• SQL validation.
• SQL formatting.
• Support grafana variables.
• Support LLM - Text to SQL using OpenAI.

Documentation

If your project has dedicated documentation available for users, provide links here. For help in following Grafana’s style recommendations for technical documentation, refer to our Writer’s Toolkit.

Contributing

Do you want folks to contribute to the plugin or provide feedback through specific means? If so, tell them how!