From the user manual, the default table naming convention is:
sqlt_data_<driver id>_<year>_<month>
I've created a new tag and I checked the drvid it was attached to, and it was id 6.
I ran this query:
SELECT
t.id,
t.tagpath,
t.scid,
si.drvid,
d.provider,
d.name
FROM sqlth_te t
LEFT JOIN sqlth_scinfo si ON si.id = t.scid
LEFT JOIN sqlth_drv d ON d.id = si.drvid
WHERE
tagpath = '<new tag path>'
and got this (I added and deleted the same tag a few times for testing):
But these are the only tables I have:
There's no sqlt_data_6_2022_10
and I'm trying to work out why? (yes I've refreshed the list)
SELECT
*
FROM
sqlth_partitions
WHERE
drvid = 6
returns an empty dataset
But adding the tag to a trend shows data. There are also a large number of other tags using this drvid (6).
As an aside: I just noticed in 8.1.21 that deleting tags no longer lets you select the tag from the Power Chart's tag browser, which is awesome, and the thing I was trying to fix... which I now no longer need to fix