Database table - sqlt_te

Ignition
1

Hi Ignition community,

I have a question regarding database that is linked to Ignition. When we create a database connection there will be several tables created. One of the table name is "sqlt_te". In this table we can see there are column named "tagpaths" and it's corresponding "tagid". The "tagpaths" and the "tagid" will be created when we enable historization in Ignition designer together with it's "created" timestamp.

Let's say there are tags with "retired" timestamps,I believe those tags are no longer historizing or the tags are no longer available in gateway.

I would like to know if it is safe to delete all the rows where the "tagpaths" are retired?

Below is the screenshot.

image

Thank you in advance

2

No, you have to see if any data in the partitions is still using that tag id. When looking for history in a query, Ignition will use all tag id's, including retired ones, that fit the time span and have the desired tag path(s).

If there are no more rows in the partitions with a retired tag id, you can delete it.