dbt-project

The idea of this project is to create a database with tables in a star schema using DBT.

The star schema is a database design that includes a fact table and dimension tables.

Project overview

It is based on the Sakila database:

Which will turn into this dwh database:

Components

To work with this project you need to install the following programs:

• Docker
• dbt
• DBeaver or similar tool

Run the project

• Clone this repo:

  git clone https://github.com/mbvyn/dbt-project.git

• Download and run db with the command:

  docker run -e POSTGRES_PASSWORD=sakila -p 5432:5432 -d frantiseks/postgres-sakila

• Connect to the database:

  • host: localhost:5432
  • database/username: postgres
  • password: sakila

• Run dbt project:

  • dbt run

Resources:

• Learn more about dbt in the docs
• Check out Discourse for commonly asked questions and answers
• Join the chat on Slack for live discussions and support
• Find dbt events near you
• Check out the blog for the latest news on dbt's development and best practices