How do I add a long list of arguments (500+) in a parameter / variable to be used in multiple queries?

Support Usage Support
1

I want to add a long list of arguments in a parameter which I can use in different queries. For example,

SELECT * FROM someTable where someField IN ( {{long_list}} )

Now long_list may contain over 500 elements. Is there any way to pre-define this long list somewhere and then be able to use it in multiple different queries within a dashboard?

Most parameter types seem to be designed for only one or two simple elements. I don’t want the user to keep on typing 500+ ids into the long_list parameter during runtime. Is there any way to store the values in long_list in a way so that we can look at all the elements in the list and modify it?

Any other workaround for this usecase is also appreciated!