DBT Architect-expert dbt project guidance

Example

Assisting users in setting up a new dbt project, including directory structure, configuration files, and connection to the data warehouse.

Scenario

A new user is starting with dbt and needs to set up their first project. DBT Architect provides step-by-step instructions on creating the necessary files and configurations, ensuring the project is correctly initialized and connected to the data warehouse.

Example

Guiding users on writing SQL models, creating modular and reusable SQL code, and implementing dbt's Jinja templating features.

Scenario

An experienced data engineer is tasked with creating complex transformations. DBT Architect helps them write efficient SQL models, use macros for reusable code, and leverage Jinja for dynamic SQL generation, resulting in cleaner and more maintainable code.

Example

Providing best practices for writing tests to ensure data quality and generating documentation for data models.

Scenario

A data team wants to ensure their transformations produce accurate results. DBT Architect advises on writing tests for key metrics and data quality checks, as well as creating comprehensive documentation for each model, making it easier for team members to understand and trust the data.