dbt-switch 0.2.6

A simple CLI to switch between dbt Cloud projects and hosts.

dbt-switch

A simple CLI tool to manage and switch between dbt Cloud projects and hosts. Solves the pain point of manually updating active-host and active-project in your dbt_cloud.yml when working with multiple dbt Cloud accounts.

The crux of the issue is documented in this dbt forum post: dbt Cloud CLI - Connect to Mulitple Hosts.

Requirements

• uv
• dbt Cloud CLI config in your ~/.dbt/dbt_cloud.yml file

Important Setup Step

You must manually merge your dbt_cloud.yml files from different accounts into one file.

If you work with multiple dbt Cloud accounts, you'll have separate dbt_cloud.yml files for each account. You need to combine all the projects sections into a single ~/.dbt/dbt_cloud.yml file before using dbt-switch.

Documentation

📚 See the Complete Usage Guide for detailed examples of the merged file structure.

Installation

uv tool install dbt-switch

Quick Start

# Initialize the configuration file
dbt-switch init

# Add a new project (interactive)
dbt-switch add

# Add a new project (non-interactive)
dbt-switch add my-project --host https://cloud.getdbt.com --project-id 12345

# List all configured projects
dbt-switch list

# Switch to a project
dbt-switch -p my-project

Key Features

• Manage multiple dbt Cloud projects across different accounts
• Switch projects instantly with a simple command
• Interactive and non-interactive modes for different workflows
• Update project configurations easily (host, project ID, or both)

Documentation

Complete Usage Guide - Detailed documentation with examples, configuration files, and command reference

How It Works

1. Store configurations: Define your projects in ~/.dbt/dbt_switch.yml
2. Switch instantly: Update active-host and active-project in your ~/.dbt/dbt_cloud.yml
3. Keep your data: All tokens and project configurations are preserved

Example workflow:

# Add your projects
dbt-switch add alpha --host cloud.getdbt.com --project-id 12345
dbt-switch add beta --host xyz123.us1.dbt.com --project-id 67890

# Switch between them
dbt-switch -p alpha    # Now using Alpha Industries project
dbt-switch -p beta     # Now using Beta Corp project