Multiple Parameters

Answered
I have a SQL script using a XXXENVXXX string that I would like to be able to change the environment type throughout the script. I set up a parameter but it is asking me to add a value for EVERY instance of the string. I want to just add the value once and have it change all occurances of the string to the new value. What am I doing wrong?
4 comments
Comment actions Permalink

Tyler Delange,

Could you provide a full example of your script and the way you set User Parameters?

0
Comment actions Permalink

Sure,

So I might have something like:

XXXENVXXX parameter for an environment type.

 

SELECT *

FROM lake_XXXENVXXX.table_one

LEFT JOIN lake_XXXENVXXX.table_two ....

LEFT JOIN lake_XXXENVXXX.table_three ....

 

I will set up a parameter like the following:

 

But when I run the code I would like it to only ask for the value once but I get results like this instead....

 

I have to enter the environment 3 different times for the code to run.

0
Comment actions Permalink

Already implemented. The part of the parameter, that is its "name", should be in parenthesizes, so it should be defined like `(XXXENVXXX)` or `XXX(ENV)XXX`

0

Please sign in to leave a comment.