Скриншоты результатов запросов

Development

1. Clone this repo & open with IDE (e.g. VS Code)

2. Prepare your development credentials for Clickhouse:

   • DBT_HOST
   • DBT_USER
   • DBT_PASSWORD

3. Install dbt environment with Docker:

   docker-compose up -d # build & run container
   
   docker-compose exec \
       dbt bash # execute dbt commands interactively

   Alternatively, install on local machine

   Install dbt and configure profile manually by yourself. By default, dbt expects the profiles.yml file to be located in the ~/.dbt/ directory.

   Use this template and enter your own credentials:

   config:
       send_anonymous_usage_stats: False
       use_colors: True
       partial_parse: True
   
   clickhouse_starschema:
       target: dev
       outputs:
           dev:
               type: clickhouse
               schema: default
               host: "{{ env_var('DBT_HOST') }}"
               port: 8443
               user: "{{ env_var('DBT_USER') }}"
               password: "{{ env_var('DBT_PASSWORD') }}"
               secure: True
               verify: False