# Include Tag Name Instead of Tag ID in Ignition MariaDB Data Tables

**URL:** <https://forum.inductiveautomation.com/t/include-tag-name-instead-of-tag-id-in-ignition-mariadb-data-tables/105196>\
**Category:** Ignition\
**Created:** [April 16, 2025, 8:25pm UTC](https://forum.inductiveautomation.com/t/include-tag-name-instead-of-tag-id-in-ignition-mariadb-data-tables/105196 "2025-04-16T20:25:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kevin\_Ortega](https://avatars.discourse-cdn.com/v4/letter/k/c67d28/32.png) [@Kevin\_Ortega](https://forum.inductiveautomation.com/u/Kevin_Ortega)\
**Post date:** [April 16, 2025, 8:25pm UTC](https://forum.inductiveautomation.com/t/include-tag-name-instead-of-tag-id-in-ignition-mariadb-data-tables/105196/1 "2025-04-16T20:25:44Z")

</div>

I am working with Ignition writing to a MariaDb. I noticed that Ignition creates a table that stores the data with tagid column, rather than the tag name. Is there a way to have ignition create automatically create a column in the data table that has the tag name rather than the id.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [April 16, 2025, 8:30pm UTC](https://forum.inductiveautomation.com/t/include-tag-name-instead-of-tag-id-in-ignition-mariadb-data-tables/105196/2 "2025-04-16T20:30:08Z")

</div>

No, and that would be an enormous performance killer. Learn to use JOINs if you need that in your own SQL. (Or better, don't write your own SQL against the historian. Use the provided scripting functions.)

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [April 16, 2025, 8:33pm UTC](https://forum.inductiveautomation.com/t/include-tag-name-instead-of-tag-id-in-ignition-mariadb-data-tables/105196/3 "2025-04-16T20:33:51Z")

</div>

The [Ignition Database Table Reference | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/appendix/reference-pages/ignition-database-table-reference#tag-history) outlines the structure of the various tables. **sqlth\_te** contains the id and tagPath.

One of the principles of good database design is that, as much as possible, each piece of information is stored only once. Look it up when required.