How to add .ENV Variables to my DBT Community Adapter

The problem I’m having

I want to be able to use a .ENV file inside my dbt Project and this goes inside the include directory of the adapters.

The context of why I’m trying to do this

I’m trying to create a .ENV file due to the fact that I’ve got very sensitive data which I do not want exposed and this seemed like a nice alternative to what I am trying to do but using it would mean that I would expose my credentials.

What I’ve already tried

I’ve already tried creating a .ENV file with the ‘DBT_’ prefix but that doesn’t do anything and the dbt CLI fails to read it.

Some example code or error messages

sample .env file
host: "{{ env_var('DBT_HOST') }}"
username: "{{ env_var('DBT_USERNAME') }}"