We have many dozens of questions that use the same exact list of variables with the same configurations. When we want to add a new question or expand that list of variables, we have to make the change to all of these questions.
Doing this manually takes a ton of time. The SQL can be copy/pasted, but then we have to individually configure the variable (set the widget type, find the field to point it to, etc.) on each question. We are currently looking to add 20 more variables to about 60 questions, and it takes 5 clicks to do this for each variable on each question
Example query:
select * from table
where true
[[and {{attribute_1}}]]
[[and {{attribute_2}}]]
[[and {{attribute_3}}]]
[[and 20 more attributes to be added here]]
So, 2 part question
- Is there an easier way to do this than repeating the manual process across all questions? e.g. is there a way to “save” a variable so that it always has the same configuration?
- We’re currently using Metabase v35. I see v36 has the ability to create snippets. Does this unlock what we’re looking to do? i.e. can the variable settings be saved as part of a snippet?