Hi all I m trying to run a dbt library locally using dbt cli

Question

Hi all I m trying to run a dbt library locally using dbt cli in Prefect I ve noticed an error I tend to get is ``` ERROR Runtime Error Credentials in profile snowflake dbt transformations target dev invalid database is a required propertyDefined profiles snowflake dbt transformations For more information on configuring profiles please consult the dbt docs <https docs getdbt com docs configure your profile>``` Upon investigation it seems like the dbtCliProfile passed to the dbtTrigger task gets saved in the `~ dbt profiles yml` first and then used inside the dbtCli shell task However the problem is the method where it saves the dbtCliProfile into a yaml file does not save the `TargetConfigs` resulting in the profile file being incomplete Has anyone had an experience with this before and know any workarounds

Farid · Answer

I have tried passing the dbtCliProfile everytime but given it saves it as a Yaml first and then uses it for the dbt tasks it does not work either ``` dbt command = dbt test if dbt select param is None else dbt test + dbt select param Executing `dbt test` to test the models and validate the expectations we have about values in them dbt test result = trigger dbt cli command with options name= dbt test description= Testing the dbt models and transformations command=dbt command project dir=DBT REPO LOCAL PATH gt gt dbt cli profile=dbt cli profile block gt gt overwrite profiles=True ```

Farid · Answer

```$ cat ~ dbt profiles yml config snowflake dbt transformations outputs dev schema DBT DEFAULT threads 1 type snowflake target dev```

Farid · Answer

I realised the recently merged resolves this issue too so I changed the requirements file of my prefect repo to use this specific commit before an official release on pypi ```$ cat requirements txt s3fs prefect dbt cli git+ prefect gitlab prefect snowflake dbt snowflake```