/dbt_data_piplene

The project cover the dbt tutorial also I set trino and postgres.

Primary LanguageHTML

dbt_data_pipeline

The project covers the dbt tutorial, and I also set up Trino and Postgres. Also you can check kubernetes_deployment version.

image

TASK

Task link = https://github.com/dbt-labs/jaffle_shop-dev

Step 1: Start by initializing a dbt project.

$ dbt init jaffle_shop

Step2: Check your profil.yml and dbt_project.yml

$ dbt debug

Step 2: Seed your raw data if you have CSV files.

$ dbt seed

Step 3: Write models (SQL files) to transform your data into useful tables and run them.

$ dbt run

Step 4: Write tests in your schema.yml file to ensure data quality.

$ dbt test

image

Step 5: Generate and serve the documentation.

$ dbt dbt docs generate

$ dbt docs serve --port 8081

image

Final:

image