Grafana Visualization of Historical Data

I’ve been experimenting with Grafana for visualization of my historical data and I see two limitations - at least for my skillset. The historical data is split in monthly tables. While I can use a JOIN or UNION of existing past month tables, I am not really sure how to add future monthly tables that do not exist yet. And while I can query for a specific tagid, there is no guarantee that that id will not be retired over time and replaced by a new id. So I would need to query for the specific tagpath and keep track of the retirements periods…
Has anybody found a way to deal with those limitations yet?

Can you point Grafana at a web API instead of a DB? Then you can expose an API with the WebDev module and have its implementation query tag history with Ignition’s scripting methods. IA’s historian really should be treated as a black box.

There is a JSON path to Grafana (Introduction | JSON API for Grafana) but the messages would need to constantly update to visualize live data…