dbt Cloud deployment - Mini Project: Build & Apply

dbt Cloud Deployment Basics

📖 Scenario: You work as a data analyst who wants to automate data transformations using dbt Cloud. You will set up a simple dbt project, configure deployment settings, run a model, and check the output.

🎯 Goal: Build a basic dbt Cloud deployment workflow that creates a model, configures deployment settings, runs the model, and displays the results.

📋 What You'll Learn

Create a dbt model SQL file with a simple SELECT statement

Add a deployment configuration variable for the target environment

Write a dbt run command using the configured target

Print the run results summary

💡 Why This Matters

🌍 Real World

dbt Cloud deployment automates data transformations in analytics workflows, making data reliable and easy to update.

💼 Career

Data analysts and engineers use dbt Cloud to manage data pipelines and ensure consistent data models for business reporting.

1

Create a dbt model SQL file

Create a file named models/my_first_model.sql with the exact SQL code: select 1 as id, 'dbt' as tool

dbt

# Create the file models/my_first_model.sql with the SQL code
# Your code here

Need a hint?

This SQL creates a simple model with two columns: id and tool.

2

Add deployment target configuration

In your dbt_project.yml file, add a variable called target and set it to dev to specify the deployment environment.

dbt

select 1 as id, 'dbt' as tool
# Add variable target = 'dev' in dbt_project.yml
# Your code here

Need a hint?

The target variable tells dbt which environment to run against.

3

Run the dbt model using the target

Write the command dbt run --target dev to run the model using the dev deployment target.

dbt

select 1 as id, 'dbt' as tool

# dbt_project.yml content:
# target: dev

# Run the model with dbt run --target dev
# Your code here

Need a hint?

This command runs your dbt models in the specified environment.

4

Display the run results summary

Print the text Run completed successfully with 1 model to show the deployment output summary.

dbt

select 1 as id, 'dbt' as tool

# dbt_project.yml content:
# target: dev

# Command to run:
dbt run --target dev

# Print the run summary
# Your code here

Need a hint?

This confirms your dbt deployment ran without errors.