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
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.
Perhaps you should open a support ticket. This forum is not support.
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?
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.
