Forum Discussion
User Defined Parameters for BQ SQL
Hi, I would like my users to define 2 key parameters and run Big Query SQL code, they need to supply a code and a start date. The SQL adds 30 days to the start date and uses the code the filter d...
Hi amitchandak - thanks for your reply and referring link.
While in the scenario above the dynamic range can be applied it seems to need a lookup table to be created in order for a user to refer to this. While creating a lookup table might be possible for dates it might be a little harder for the second part which is the code required. It had been my hope that a user could just input this and it be injected in to the query but I dont think this is possible. I will explore options around creating a lookup table in any case as it might be my only option. Thanks! Tristan