.gitpod.yml

image: corise/dbt-course-gitpod
tasks:
  - name: Start psql and add role
    command: |
      sudo /etc/init.d/postgresql start
      export PGPASSWORD=corise PGUSER=corise PGDATABASE=dbt
      mkdir -p /workspace/.dbt && ln -snf /workspace/.dbt ~/.dbt
      cd dbt-greenery 
      export DBT_PROFILES_DIR='.'
      psql
      create role reporting;
  - name: Install Python Packages
    command: pip install -r requirements.txt --user

ports:
  - port: 8000
    onOpen: open-preview

vscode:
  extensions:
    - ms-toolsai.jupyter
    - ms-python.python
    - cweijan.vscode-postgresql-client2