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
# Open the virtual environment with Ubuntu
cd /mnt/c/Users/USER/dbt-env
# Activate the virtual environment
source Scripts/activate
# Download dbt from git
git clone https://github.com/dbt-labs/dbt-core.git
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
# Install the Requirments txt file
python3 -m pip install -r requirements.txt
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
After installing open the plugin folder
# Open the BigQuery Folder
cd dbt-bigquery
# Install the BigQuery Requirement File
python3 -m pip install -e .
You can repeat the same process for Postgres etc.
You can verify if DBT was successfully installed by using
dbt --version
You can create a dbt project with the following code.
dbt init project_name
Thanks for following!!! Happy DBT learning
Top comments (0)