Custom Docker-container and python script for streamlining new DBT-projects. Supports these platforms:
- Postgresql
- Snowflake
- SQLServer
However, the script can be run if dbt is installed locally as well.
Requires Docker To use this repo to quickstart a DBT-project in VS Code, you need to have the following extensions installed:
- Docker (ms-azuretools.vscode-docker)
- Remote - Containers (ms-vscode-remote.remote-containers)
Run command Clone repository in Container Volume Pick this repository -> main branch and voila!
- Clone repository to desired location
- Backup any existing profiles.yml (usually at $HOME/.dbt/profiles.yml):
cp $HOME/.dbt/profiles.yml $HOME/.dbt/profiles.backup.yml
- Run dbt_init.py script:
chmod +x dbt_init.py && python dbt_init.py