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.
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
| Capability | DBT Core (CLI) | DBT Cloud (SaaS) |
|---|---|---|
| Hosting | Local machine or your own servers | Hosted by dbt Labs in the browser |
| Development | Requires VS Code or similar local IDE | Built-in web-based IDE |
| Job Scheduling | Requires 3rd party tools (Airflow, cron) | Built-in Job Scheduler with alerts |
| CI/CD Integration | Complex to build custom pipelines | Native "Slim CI" (tests code on PRs) |
| Pricing | Open-source and absolutely free | Seat-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
- Navigate to cloud.getdbt.com and click Create a free account.
- Create your profile using an email address and password, or use Single Sign-On (like Google or GitHub).
- 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:
- Choose your database connection type (e.g., Snowflake).
- Enter your Account URL, Database name, and Warehouse name.
- 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.
- Choose your version control provider (GitHub, GitLab, or Azure DevOps).
- Authorize the DBT Cloud application to access your repositories.
- 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!
- Click the Develop tab at the top of your screen.
- The DBT Cloud IDE will open directly in your browser.
- 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 runanddbt testwithout ever needing to open a local terminal!