Is there a way to pass the value of a Parameter into a Prefe

Question

Is there a way to pass the value of a Parameter into a PrefectSecret as a string Is something like this possible ```run env = Parameter run env default= DEV sf user = PrefectSecret SF USER + + run env ```

Kevin Kho · Answer

I believe yes if `SF USER + + run env` was a task output because that is evaluated during build time instead of runtime

Zhibin Dai · Answer

cool ill give it a shot

Zhibin Dai · Answer

I tried this but it doesnt seem to work Heres the code ``` task def concat str str1 str2 delim return str1 + delim + str2 with Flow FLOW NAME storage=STORAGE run config=RUN CONFIG as flow run env = Parameter PREFECT RUN ENVIRONMENT PARAM NAME default= DEV sf user = PrefectSecret concat str SF USERNAME run env ``` And it get this error ``` Traceback most recent call last File opt homebrew lib python3 9 site packages prefect cli build register py line 134 in load flows from script namespace = runpy run path abs path run name= lt flow gt File opt homebrew Cellar python 3 9 3 9 9 Frameworks Python framework Versions 3 9 lib python3 9 runpy py line 268 in run path return run module code code init globals run name File opt homebrew Cellar python 3 9 3 9 9 Frameworks Python framework Versions 3 9 lib python3 9 runpy py line 97 in run module code run code code mod globals init globals File opt homebrew Cellar python 3 9 3 9 9 Frameworks Python framework Versions 3 9 lib python3 9 runpy py line 87 in run code exec code run globals File Users zhibin Desktop repos parcl orchestration flows ppi s3 to sf raw py line 50 in lt module gt sf user = PrefectSecret concat str SNOWFLAKE PREFECT USERNAME run env File opt homebrew lib python3 9 site packages prefect core task py line 159 in init old init self args kwargs File opt homebrew lib python3 9 site packages prefect tasks secrets base py line 45 in init super init name=name kwargs File opt homebrew lib python3 9 site packages prefect core task py line 159 in init old init self args kwargs File opt homebrew lib python3 9 site packages prefect tasks secrets base py line 26 in init super init kwargs File opt homebrew lib python3 9 site packages prefect core task py line 159 in init old init self args kwargs File opt homebrew lib python3 9 site packages prefect core task py line 345 in init self logger = logging get logger self name File opt homebrew lib python3 9 site packages prefect utilities logging py line 309 in get logger return prefect logger getChild name File opt homebrew Cellar python 3 9 3 9 9 Frameworks Python framework Versions 3 9 lib python3 9 logging init py line 1727 in getChild suffix = join self name suffix TypeError sequence item 1 expected str instance FunctionTask found```

Kevin Kho · Answer

can you try ```sf user = PrefectSecret concat str SF USERNAME run env ``` really not sure it will work

Kevin Kho · Answer

Actually I just read the source and I think it will work

Zhibin Dai · Answer

``` 12 50 50 | INFO | Entered state lt Failed gt Failed to load and execute flow run TypeError sequence item 1 expected str instance FunctionTask found 12 50 51 | ERROR | Failed to load and execute flow run TypeError sequence item 1 expected str instance FunctionTask found Flow run failed ```

Zhibin Dai · Answer

``` sf user = PrefectSecret concat str SNOWFLAKE PREFECT USERNAME run env <http logger info|logger info> f SF USER sf user ```

Kevin Kho · Answer

The logger won t work in the flow it needs to be in a task haha One sec let me test

Kevin Kho · Answer

```from prefect import Flow task import prefect from prefect tasks secrets import PrefectSecret task def t return SLACK WEBHOOK URL task def log x <http prefect context logger info|prefect context logger info> x return 1 with Flow as flow x = t a = PrefectSecret x log a flow run ```

Kevin Kho · Answer

this works for me