Extension fails to render relative paths in environment variable (macOs/Linux)

[abuchmueller]

Expected behavior

Providing an environment variable through a .env like ENV_VAR=$HOME/path/to/file.json should work as long as $HOME is set.

Actual behavior

The extension throws an exception (FileNotFound)

Runtime Error Failed to authenticate with supplied credentials error: File $HOME/path/to/file.json was not found.

Providing the full path without $HOME works i.e. /Users/andreas/path/to/file.json works.

Steps To Reproduce

Inside a .env file, create an environment variable like ENV_VAR=$HOME/path/to/file.json and make sure $HOME exists. In my case, I use a credentials file to authenticate with GCP.

Log output/Screenshots

No response

Operating System

macOs 15.2

dbt version

1.8.6

dbt Adapter

dbt-bigquery

dbt Power User version

0.51.0

Are you willing to submit PR?

• [ ] Yes I am willing to submit a PR!