To start the Docker compose:
make up
python -m venv ENV
source ENV/bin/activate
pip install -r requirements.txt
dbt init
Note: Let's specify the project name greenery
.
-
Change the directory to your dbt project.
cd <dbt_project_name>
-
Run the following command to copy the profiles example file to the real profiles file in the project folder.
cp ../profiles.yml.example profiles.yml
-
Edit the content in the
profiles.yml
file by changing the output and target to your name (e.g.,dbt_john
), and save. See the example below.greenery: outputs: dbt_zkan: type: postgres threads: 1 host: localhost port: 5432 user: postgres pass: "{{ env_var('DBT_ENV_SECRET_PG_PASSWORD') }}" dbname: greenery schema: dbt_zkan prod: type: postgres threads: 1 host: localhost port: 5432 user: postgres pass: "{{ env_var('DBT_ENV_SECRET_PG_PASSWORD') }}" dbname: greenery schema: prod target: dbt_zkan
-
Set the environment variable.
export DBT_ENV_SECRET_PG_PASSWORD=postgres
-
We then should be able to use dbt now. :-)
export DBT_ENV_SECRET_PG_PASSWORD=postgres
cd <dbt_project_name>
dbt debug
export DBT_ENV_SECRET_PG_PASSWORD=postgres
cd <dbt_project_name>
dbt run
export DBT_ENV_SECRET_PG_PASSWORD=postgres
cd <dbt_project_name>
dbt test
export DBT_ENV_SECRET_PG_PASSWORD=postgres
cd <dbt_project_name>
dbt docs generate
dbt docs serve