Device/host level tags

We are evaluating InfluxDB as a possible time series datastore. We have a use case where instead of storing many tags at a measurement level, we want to store a single tag (device id) at the measurement level and then have a separate table/datastore to store a time-phased mapping between device and a device level tag (eg. location, vertical, etc.). This is because our customers can change these device level tags dynamically.

See for a better explanation of what we would like to do.

Our initial goal to be able support 10,000 devices. What would be recommended approach? A huge OR clause? Is this even practical?

Any advice is appreciated.