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
DBT_HOST="baseurl"
DBT_USERNAME="username"
host: "{{ env_var('DBT_HOST') }}"
username: "{{ env_var('DBT_USERNAME') }}"