Hi, I'm having issues materialising assets. Locall...
# integration-dbt
b
Hi, I'm having issues materialising assets. Locally it is running fine. On my self hosted VM with docker I get the following error:
Copy code
Encountered an error:
Database Error
  [Errno 2] No such file or directory: '/secrets/dbt-service-keyfile'
I have no longer have a reference to the /secrets/dbt-service-keyfile in my code anymore I'm using a env variable instead in my
profiles.yml
that uses
method: service-account-json
Locally that works fine. But on the hosted machine it is failing. I'm not sure were else to look.
IS dbt caching this anywhere? Can I clear that cache somehow.
I reset the DB for dagster so it seems to not be in the dagster postgres DB.
r
https://docs.getdbt.com/docs/get-started/connection-profiles#connecting-to-your-warehouse-using-the-command-line
dbt will search the current working directory for the
profiles.yml
file and will default to the
~/.dbt/
directory if not found.
I would check in your docker VM to see if your
~/.dbt/
folder still has the stale reference to your former
profiles.yml
. If so, you should delete it.
daggy love 1
b
The correct image would be were the dagster daemon runs?
Found it in the user_code image. Something in my built process seems to be not workign correctly