| Name | Description |
|---|---|
.devcontainer/devcontainer.json |
A file that tells VS Code how to access (or create) a development container with a well-defined tool and runtime stack |
csv_files/ |
A folder that contains CSV files used for testing dbt seed |
setup/ |
A folder that contains data and scripts used for initializing the Postgres database used in this project |
yaml_files/ |
A folder that contains the YAML file examples such as profiles.yml or src.yml |
.gitignore |
A file that specifies intentionally untracked files that Git should ignore |
LICENSE |
A license of this repo |
Makefile |
A Makefile file which defines set of tasks to be executed |
README.md |
README file that provides the setup instruction on this project |
docker-compose.yml |
A Docker Compose file that runs a Postgres database and SQLPad used in this project |
greenery-dbdiagram.txt |
A file that provides code for drawing an ER diagram on dbdiagram.io |
requirements.txt |
A file that contains Python package dependencies for this code repository |
To start the Docker compose:
make uppython -m venv ENV
source ENV/bin/activate
pip install -r requirements.txtdbt initNote: 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 ../yaml_files/profiles.yml . -
Edit the content in the
profiles.ymlfile 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 debugexport DBT_ENV_SECRET_PG_PASSWORD=postgres
cd <dbt_project_name>
dbt runexport DBT_ENV_SECRET_PG_PASSWORD=postgres
cd <dbt_project_name>
dbt testexport DBT_ENV_SECRET_PG_PASSWORD=postgres
cd <dbt_project_name>
dbt docs generate
dbt docs serve
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent