Feedback on /integrate/grafana: How to efficiently query Grafana when using CrateDB as time series database

[amotl]

Documentation feedback

• Page title: Grafana
• Page URL: https://cratedb.com/docs/guide/integrate/grafana/index.html
• Source: https://github.com/crate/cratedb-guide/blob/main/docs/integrate/grafana/index.md

---

Problem

Hi. It looks like no resource is educating about how to use Grafana with CrateDB properly, by applying the $__timeGroupAlias and $__timeFilter macros correspondingly. I can't find them being mentioned on the following resources contrary to being guided effectively by @hammerhead and @seut on a patch conceived the other day. Do I miss any?

• https://cratedb.com/blog/time-series-cratedb-cloud-sql-examples
• https://cratedb.com/blog/visualizing-time-series-data-with-grafana-and-cratedb
• https://medium.com/@drishtinishchhal/unlock-the-power-of-time-series-with-cratedb-an-overview-4995f10ad35d

Evaluation

No wonder users will overload CrateDB with dashboarding when using Grafana without applying those querying essentials by including the relevant macros into their SQL queries?

References

• https://github.com/crate/c-vatvalve/issues/11
• https://github.com/crate/tech-content/issues/72

Outlook

If you are still reading, please educate yourself about how cool a native LTTB implementation would be.

• https://community.cratedb.com/t/advanced-downsampling-with-the-lttb-algorithm/1287
• https://community.cratedb.com/t/lttb-downsampling-to-work-around-grafana-sql-limits/1596