Skip to main content

04. DBT Cloud Overview

The DBT Cloud Alternative​

In the previous chapters, we configured DBT Core—the local, command-line interface. However, managing Python environments, securing local credentials, and setting up complex orchestrators like Apache Airflow can be overwhelming.

Enter DBT Cloud: a fully-managed Software-as-a-Service (SaaS) platform built around DBT Core.


1. Why Choose DBT Cloud?​

DBT Cloud completely abstracts away infrastructure management, providing an instant web-based IDE, turnkey job scheduling, and native CI/CD integrations.

Zero Local Setup

With DBT Cloud, new analysts can be onboarded in minutes. They simply log into the web browser, connect their warehouse, and immediately start writing SQL—no pip install, Python virtual environments, or terminal commands required.


2. Core vs Cloud: A Technical Breakdown​

CapabilityDBT Core (CLI)DBT Cloud (SaaS)
HostingLocal machine or your own serversHosted by dbt Labs in the browser
DevelopmentRequires VS Code or similar local IDEBuilt-in web-based IDE
Job SchedulingRequires 3rd party tools (Airflow, cron)Built-in Job Scheduler with alerts
CI/CD IntegrationComplex to build custom pipelinesNative "Slim CI" (tests code on PRs)
PricingOpen-source and absolutely freeSeat-based licensing (has a Free Tier)

3. Architecture of DBT Cloud​

A common misconception is that DBT Cloud processes or stores your data. It does not.

Instead, DBT Cloud acts purely as an orchestrator. It connects to your Cloud Data Warehouse, reads your SQL from your Git provider, and issues SQL commands down to the warehouse. All data processing stays securely within your own warehouse (e.g., Snowflake).


4. How to Get Access and Set Up DBT Cloud​

For individuals and small setups, DBT Cloud offers a powerful Free Tier (Developer plan) that includes 1 developer seat and unlimited scheduled runs.

Getting access and setting up your first project takes just a few minutes. Here is how the onboarding flow works:

Step 1: Account Creation​

  1. Navigate to cloud.getdbt.com and click Create a free account.
  2. Create your profile using an email address and password, or use Single Sign-On (like Google or GitHub).
  3. Once logged in, you will be immediately prompted to set up your first Project.

Step 2: Connect Your Database (The Cloud equivalent of profiles.yml)​

DBT Cloud needs to talk to your warehouse to execute SQL. Instead of writing a YAML file, you fill out a form:

  1. Choose your database connection type (e.g., Snowflake).
  2. Enter your Account URL, Database name, and Warehouse name.
  3. Provide your developer credentials (Username, Role, and Password) and click Test Connection to ensure DBT Cloud can reach your data.

Step 3: Connect Your Git Repository​

Because DBT Cloud is built for collaborative engineering, it strictly uses Git as the source of truth for all code.

  1. Choose your version control provider (GitHub, GitLab, or Azure DevOps).
  2. Authorize the DBT Cloud application to access your repositories.
  3. You can either select an existing repository, or have DBT Cloud automatically generate a clean, initialized repository for you.

Step 4: Launch the IDE​

Once your database and Git repository are linked, you are ready to write code!

  1. Click the Develop tab at the top of your screen.
  2. The DBT Cloud IDE will open directly in your browser.
  3. You will see a file tree on the left, a SQL editor in the center, and a command line interface at the bottom. From here, you can execute commands like dbt run and dbt test without ever needing to open a local terminal!