dbt Core vs dbt Cloud - Hands-On Comparison

Understanding dbt Core vs dbt Cloud

📖 Scenario: You work as a data analyst in a company that uses dbt (data build tool) to transform raw data into clean, usable datasets. Your team is deciding whether to use dbt Core or dbt Cloud for their data transformation workflows.To help the team, you will create a simple Python project that models the features of both dbt Core and dbt Cloud, so you can compare them clearly.

🎯 Goal: Build a Python dictionary that lists key features of dbt Core and dbt Cloud. Then, create a filter to select features available only in dbt Cloud. Finally, print these cloud-only features to help your team understand the differences.

📋 What You'll Learn

Create a dictionary named dbt_features with exact keys 'dbt Core' and 'dbt Cloud' and their feature lists.

Create a variable named cloud_only_features to hold features unique to dbt Cloud.

Use a list comprehension to find features in dbt Cloud that are not in dbt Core.

Print the cloud_only_features list as the final output.

💡 Why This Matters

🌍 Real World

Data teams often need to understand the differences between tools like dbt Core and dbt Cloud to choose the best fit for their workflows.

💼 Career

Knowing how to compare tool features and present clear summaries helps data analysts and engineers make informed decisions and communicate effectively with stakeholders.

1

Create the dbt features dictionary

Create a dictionary called dbt_features with two keys: 'dbt Core' and 'dbt Cloud'. Set the value for 'dbt Core' to the list ["Open-source", "Command-line interface", "Local development"] and for 'dbt Cloud' to the list ["Hosted environment", "Job scheduling", "User interface", "Open-source", "Command-line interface"].

dbt

# Create the dbt_features dictionary with exact keys and lists
# Your code here

Need a hint?

Use a dictionary with two keys exactly named 'dbt Core' and 'dbt Cloud'. Assign the exact lists of features as values.

2

Create a variable for cloud-only features

Create a variable called cloud_only_features and set it to an empty list []. This will hold features unique to dbt Cloud.

dbt

dbt_features = {
    'dbt Core': ["Open-source", "Command-line interface", "Local development"],
    'dbt Cloud': ["Hosted environment", "Job scheduling", "User interface", "Open-source", "Command-line interface"]
}

# Create an empty list called cloud_only_features
# Your code here

Need a hint?

Just create a variable named cloud_only_features and assign it an empty list [].

3

Find features unique to dbt Cloud

Use a list comprehension to set cloud_only_features to all features in dbt_features['dbt Cloud'] that are not in dbt_features['dbt Core']. Use the variable names exactly as given.

dbt

dbt_features = {
    'dbt Core': ["Open-source", "Command-line interface", "Local development"],
    'dbt Cloud': ["Hosted environment", "Job scheduling", "User interface", "Open-source", "Command-line interface"]
}

# Use list comprehension to find features in dbt Cloud not in dbt Core
cloud_only_features = [feature for feature in dbt_features['dbt Cloud'] if feature not in dbt_features['dbt Core']]

Need a hint?

Use a list comprehension with feature for feature in dbt_features['dbt Cloud'] if feature not in dbt_features['dbt Core'].

4

Print the cloud-only features

Write a print statement to display the cloud_only_features list.

dbt

dbt_features = {
    'dbt Core': ["Open-source", "Command-line interface", "Local development"],
    'dbt Cloud': ["Hosted environment", "Job scheduling", "User interface", "Open-source", "Command-line interface"]
}

cloud_only_features = [feature for feature in dbt_features['dbt Cloud'] if feature not in dbt_features['dbt Core']]

# Print the cloud_only_features list
# Your code here

Need a hint?

Use print(cloud_only_features) to show the list.