Step Snap 1: [Environment Setup and Prerequisites 🛠️]

1. Environment Setup

1.1 Docker Environment Check

First, verify your PostgreSQL database container is running:

docker ps

Ensure the following containers are running:

• PostgreSQL (port 5432)
• pgAdmin (port 8080)

1.2 DBT Installation

Install dbt-core and required adapters using pip:

python -m pip install dbt-core dbt-postgres dbt-bigquery

Step Snap 2: [Database Configuration and Schema Setup 📊]

1. Database Preparation

1.1 Connect to PostgreSQL

docker exec -it <container_id> psql -U <username> -d postgres

1.2 Create Database and Schema

Execute in PostgreSQL command line:

-- Create development database
CREATE DATABASE dev_database;

-- Connect to new database
\\\\c dev_database

-- Create schema
CREATE SCHEMA my_schema;

-- Verify creation
\\\\dn