# Tag History - No sqlt\_data\_X table for driver id for new tag

**URL:** <https://forum.inductiveautomation.com/t/tag-history-no-sqlt-data-x-table-for-driver-id-for-new-tag/65507>\
**Category:** Ignition\
**Created:** [October 21, 2022, 4:55am UTC](https://forum.inductiveautomation.com/t/tag-history-no-sqlt-data-x-table-for-driver-id-for-new-tag/65507 "2022-10-21T04:55:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [October 21, 2022, 4:55am UTC](https://forum.inductiveautomation.com/t/tag-history-no-sqlt-data-x-table-for-driver-id-for-new-tag/65507/1 "2022-10-21T04:55:41Z")

</div>

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:

```auto
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):

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/c/ac06813295605737470a313d98320c12dd8c8a45.png)

But these are the only tables I have:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/1/411374865a8fb98bbe604b67a5dc3bab32c128fd.png)

There's no `sqlt_data_6_2022_10` and I'm trying to work out why? (yes I've refreshed the list)

```auto
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 🤦‍♂️

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [October 21, 2022, 3:46pm UTC](https://forum.inductiveautomation.com/t/tag-history-no-sqlt-data-x-table-for-driver-id-for-new-tag/65507/2 "2022-10-21T15:46:31Z")

</div>

The 'driver id' used in the partition name will be whichever entry in `sqlth_drv` matches your gateway and has a _null_ `provider`. _Not_ whichever `id` matches your particular realtime provider.

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [October 21, 2022, 11:20pm UTC](https://forum.inductiveautomation.com/t/tag-history-no-sqlt-data-x-table-for-driver-id-for-new-tag/65507/3 "2022-10-21T23:20:01Z")

</div>

That makes sense, I did only skim read the user manual 😅 cheers