I have a series with tags that are IDs from the production system. Similar to a 3NF database, is there a way to join the Ids with their text values via kapacitor?
This feature has been requested before see this. Please add comment or specific to your use case there.
In the meantime you could use a UDF to join the value based on the IDs. Here is a guide on writing a UDF: https://docs.influxdata.com/kapacitor/v1.3/guides/socket_udf/