title: How to add a list of "permitted values" to a parameter by using a BigQuery connector in Data Studio?
body: <p>I was wondering if there is a way to add a list of &quot;permitted values&quot; to a parameter in Data Studio by using a custom query / BigQuery connector?</p>
  <p>There is an option to do it manually in the Data Studio UI:
  <a href="https://i.stack.imgur.com/ZdPyh.png" rel="nofollow noreferrer">Permitted values through Data Studio UI</a></p>
  <p>But I am looking for a solution to do it through SQL because I have to pass a long list of values that can be changed every day, so adding a list of values manually through the UI is impossible.</p>
  <p>Is it possible to do it through a custom query?</p>
  <p>Thank you!</p>