dbt (Data Build Tool)

dbt is our transformation tool. We use the dbt-fusion version of dbt.

Initial Setup

Clone the dbt project from GitHub

git clone https://github.com/majority-dev/dt-dbt.git
cd dt-dbt

Install dependencies with uv

uv sync

Configure profiles.yml

dbt needs a profiles.yml file with connection details to BigQuery.

Create a profiles.yml in your home directory:

mkdir -p ~/.dbt

Create ~/.dbt/profiles.yml with your configuration (copy from the profiles.yml in the dbt repo, and change the default), then set the environment variable:

export DBT_PROFILES_DIR=/Users/your.name/.dbt

Add this to your ~/.zshrc or ~/.bashrc to make it permanent.

Verify Connection

dbt debug

Install dbt Dependencies

dbt deps

dbt-fusion

To install the dbt-fusion follow this guide.

For the further dbt usage, check the dbt documentation