How to get all values for a dimension ingested in a datasource over a period of time?

Hi,

What is the most efficient way to get this done? We can say that there are going to be about 100 distinct values in a dimension, although this can increase in the future? I do not care about their order or their respective event counts?

if I understood correctly seems You want to select all distinct values for a particular dimension in a given time range, if that is the case, You can run a query like below:

SELECT DISTINCT <Dimention_Name>

FROM

WHERE “__time” BETWEEN TIMESTAMP ‘t1’ AND TIMESTAMP ‘t2’

Thanks and regards,

Vaibhav