dbt Core vs dbt Cloud - Quick Revision & Key Differences

Recall & Review

beginner

What is dbt Core?

dbt Core is the open-source command-line tool that helps you transform data in your warehouse using SQL. It runs locally or in your own environment.

beginner

What is dbt Cloud?

dbt Cloud is a hosted service that provides a user-friendly interface, scheduling, and collaboration features on top of dbt Core.

intermediate

Name one key difference between dbt Core and dbt Cloud.

dbt Core is free and self-managed, while dbt Cloud offers managed hosting, a web UI, and additional features like job scheduling and alerting.

beginner

Can you run dbt Core without an internet connection?

Yes, dbt Core runs locally on your machine or server and does not require internet once installed.

intermediate

What feature does dbt Cloud provide to help teams collaborate?

dbt Cloud provides a web-based IDE and version control integration to help teams work together on data transformations.

Which of the following is true about dbt Core?

A It only works with cloud data warehouses.

B It is a paid hosted service.

C It is an open-source tool you run locally.

D It requires a web browser to use.

dbt Core is open-source and runs locally on your machine or server.

What extra feature does dbt Cloud provide over dbt Core?

A Command-line interface

B Job scheduling and alerting

C SQL query writing

D Local installation

dbt Cloud adds job scheduling, alerting, and a web UI on top of dbt Core.

Which tool would you choose if you want a free, self-managed option?

A dbt Core

B dbt Cloud

C Both require payment

D Neither is self-managed

dbt Core is free and self-managed, while dbt Cloud is a paid hosted service.

Does dbt Cloud provide a web-based IDE for editing SQL models?

A Yes

B No

C Only in dbt Core

D Only for paid users of dbt Core

dbt Cloud includes a web-based IDE to edit and run SQL models.

Which of these is NOT a feature of dbt Cloud?

A Team collaboration tools

B Job scheduling

C Version control integration

D Local command-line execution only

Local command-line execution is a feature of dbt Core, not dbt Cloud.

Explain the main differences between dbt Core and dbt Cloud.

Think about how you run each tool and what extra features they offer.

Describe a scenario where you might choose dbt Core over dbt Cloud.

Consider cost and control over environment.