# Snowflake Tag History Issues

**URL:** <https://forum.inductiveautomation.com/t/snowflake-tag-history-issues/90752>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [May 22, 2024, 6:10pm UTC](https://forum.inductiveautomation.com/t/snowflake-tag-history-issues/90752 "2024-05-22T18:10:09Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![braydon.hancock](https://avatars.discourse-cdn.com/v4/letter/b/c67d28/32.png) [@braydon.hancock](https://forum.inductiveautomation.com/u/braydon.hancock)\
**Post date:** [May 22, 2024, 6:10pm UTC](https://forum.inductiveautomation.com/t/snowflake-tag-history-issues/90752/1 "2024-05-22T18:10:09Z")

</div>

I'm trying to use Snowflake as a history datasource, I've configured the JDBC driver and translator per [JDBC Driver and Database Translator Settings | Ignition User Manual](https://docs.inductiveautomation.com/docs/8.1/platform/database-connections/connecting-to-databases/jdbc-drivers-and-translators/jdbc-driver-and-database-translator-settings)

Everything is working as expected aside from the tagid's not storing correctly. All data entries have a tagid of 0.

I've attached some screenshots from a newly created schema with only 4 historical tags that I have changed the data once on each.

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/1/b180d3e766a7ad90289dd9e891c77eb453773d35.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/1/e1eb24f7e7f222606740ff9b99eb9079dc66078b.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/8/382fdd48f222e45bbaea83b002b5d4a866915499.png)

---

<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:** [May 22, 2024, 6:33pm UTC](https://forum.inductiveautomation.com/t/snowflake-tag-history-issues/90752/2 "2024-05-22T18:33:27Z")

</div>

Perhaps you should open a support ticket. This forum is not support.

---

<div class="post-metadata">

**Author:** ![kcollins](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kcollins/32/19646_2.png) [@kcollins](https://forum.inductiveautomation.com/u/kcollins)\
**Post date:** [May 22, 2024, 8:28pm UTC](https://forum.inductiveautomation.com/t/snowflake-tag-history-issues/90752/3 "2024-05-22T20:28:06Z")

</div>

I don't believe Ignition Tag History is directly compatible with Snowflake. I think it has something to do with not being able to retrieve the value of an AUTOINCREMENT identity column (something that is supposed to be innate from JDBC). Probably due to the distributed nature of Snowflake?

---

<div class="post-metadata">

**Author:** ![braydon.hancock](https://avatars.discourse-cdn.com/v4/letter/b/c67d28/32.png) [@braydon.hancock](https://forum.inductiveautomation.com/u/braydon.hancock)\
**Post date:** [May 23, 2024, 2:48pm UTC](https://forum.inductiveautomation.com/t/snowflake-tag-history-issues/90752/4 "2024-05-23T14:48:08Z")

</div>

I submitted a support ticket as well, but figured there might be a community member out there using Snowflake already.

From what I can tell the AUTOINCREMENT is working, new tags are added with unique IDs.

The issue occurs when new entries are stored in SQLT\_DATA\_\* tables, the unique SQLT\_TE ID is not linked up correctly to the SQLT\_DATA TAGID.

---

<div class="post-metadata">

**Author:** ![john.maldonado](https://avatars.discourse-cdn.com/v4/letter/j/77aa72/32.png) [@john.maldonado](https://forum.inductiveautomation.com/u/john.maldonado)\
**Post date:** [June 12, 2025, 10:33pm UTC](https://forum.inductiveautomation.com/t/snowflake-tag-history-issues/90752/5 "2025-06-12T22:33:05Z")

</div>

Did you ever get this resolved?

I had just ran into the same issue with no real solution from support other than restarting the historian module and then the TagIds start working in the DATA table.

It seems after adding new tags, they go in with TagID = 0 until I restart the historian module.

---

<div class="post-metadata">

**Author:** ![braydon.hancock](https://avatars.discourse-cdn.com/v4/letter/b/c67d28/32.png) [@braydon.hancock](https://forum.inductiveautomation.com/u/braydon.hancock)\
**Post date:** [June 13, 2025, 4:01pm UTC](https://forum.inductiveautomation.com/t/snowflake-tag-history-issues/90752/6 "2025-06-13T16:01:39Z")

</div>

We never ran this to ground before our company ended up switching our data warehouse to Databricks.
