influxdb schema

[Zar]

Hy Everyone,

There is a way to modify the schema of influxdb database that use thingworx?

[tmisner]

Hello Zar,

Can you please provide some further context for what information you are looking for? How are you looking to modify the schema and what is the purpose behind doing so? Any particular use case would also be helpful here.

[Zar]

I would like to add some thing properties as a "tag" in infludb, in order to make more efficient query(direct to db) and use some grafana features (ex: variables in grafana can be used only with tag).

[tmisner]

Hello again Zar,

In doing some searching on this topic I found a prior post from yourself within the ThingWorx Developer Community. It seems my colleague Sharon has already replied on that thread asking for some more information on how you are using Influx. Can you please reply to Sharon's query?

We can both continue to look into this on your behalf and open a Technical Support case if necessary.

[rjanardan]

As far as I know this is not currently supported. Marking a column as tag would require a change in the in-built queries used to insert data in InfluxDB.