Hello I m trying to run a DBTShellTask using prefect cloud I

Question

Hello I m trying to run a DBTShellTask using prefect cloud I have a lot of my connection details stored as Prefect secrets It looks like when prefect generates the profiles yml file for this task it is storing literal values instead of injecting the Prefect secrets Is there a way to inject these into the dbt kwargs argument

Eric Mauser · Answer

```with Flow dbt storage=Docker path= flow py stored as script=True run config=ECSRun as flow repo = pull dbt repo dbt kwargs = type postgres User password auth user PrefectSecret DEV DB USER password PrefectSecret DEV DB PASSWORD database PrefectSecret DEV DB NAME port PrefectSecret DEV DB PORT threads 1 client session keep alive False deps = dbt command= dbt deps dbt kwargs=dbt kwargs flow run ```

Eric Mauser · Answer

it s generating this in the profiles yml file which is causing a syntax error for dbt `dev ` outputs null client session keep alive false database python object prefect client secrets Secret name DEV DB NAME password python object prefect client secrets Secret name DEV DB PASSWORD port python object prefect client secrets Secret name DEV DB PORT threads 1 type postgres user python object prefect client secrets Secret name DEV DB USER target null ~

Kevin Kho · Answer

Hey < Eric Mauser> this is odd Could you try defining the secerets within the `dbt ` call and see if that changed anything

Kevin Kho · Answer

Does it happen for both `flow run ` and a registered flow

Eric Mauser · Answer

man facepalming you nailed it Seems to have been a registration issue after registering the error goes away thank you

Kevin Kho · Answer

Oh I was just asking Glad you got it sorted I expect this to work with `flow run ` as well as long as you have `PREFECT CLOUD USE LOCAL SECRETS=false`