DEV Community

Cover image for My Analytics Engineering Career Path
Anuoluwapo Balogun
Anuoluwapo Balogun

Posted on

My Analytics Engineering Career Path

Hi there👋🏼, thank you for taking time out to read my blog post, actually I will be documenting my Analytics Engineering career journey for accountability purposes. I will be documenting every software installation and project.

I am currently learning Analytics Engineering at Udemy Bootcamp Click here to view course.

At the bootcamp I learnt how to set up and Install DBT core with Command Prompt and Ubuntu Terminal on my local machine and I will share the process with you.

I am using Command Prompt to create a Python Virtual Environment, so I can have access to the DBT folder on my local machine. I am only going to run it with Ubuntu.

What is DBT? DBT is a data transformation tool mostly used by Analytics Engineer to transform data in a database for analytical purposes.

# Creating new virtual environment with Command Line
python -m venv dbt-env
Enter fullscreen mode Exit fullscreen mode

Image description

# Open the virtual environment with Ubuntu
cd /mnt/c/Users/USER/dbt-env
Enter fullscreen mode Exit fullscreen mode

Image description

# Activate the virtual environment
source Scripts/activate
Enter fullscreen mode Exit fullscreen mode

Image description

# Download dbt from git
git clone https://github.com/dbt-labs/dbt-core.git
Enter fullscreen mode Exit fullscreen mode

I decided to download DBT core using git. After installing from git, Open the dbt Core folder.

# Opening the DBT-Core Folder after Downloading from git
cd dbt-core
Enter fullscreen mode Exit fullscreen mode

Image description

# Install the Requirments txt file
python3 -m pip install -r requirements.txt
Enter fullscreen mode Exit fullscreen mode

You can also Install plugins for database, so I installed plugins for BigQuery and Postgres

# Install plugins for dbt (Bigquery)
git clone https://github.com/dbt-labs/dbt-bigquery.git
Enter fullscreen mode Exit fullscreen mode

After installing open the plugin folder

# Open the BigQuery Folder 
cd dbt-bigquery
Enter fullscreen mode Exit fullscreen mode
# Install the BigQuery Requirement File
python3 -m pip install -e .
Enter fullscreen mode Exit fullscreen mode

You can repeat the same process for Postgres etc.

You can verify if DBT was successfully installed by using

dbt --version
Enter fullscreen mode Exit fullscreen mode

Image description

You can create a dbt project with the following code.

dbt init project_name
Enter fullscreen mode Exit fullscreen mode

Thanks for following!!! Happy DBT learning

Top comments (0)