Install dbt Wizard and run your first prompt

Authenticate to Google Cloud

dbt Wizard requires Google Cloud Application Default Credentials (ADC). The agent uses your GCP identity to talk to the dbt platform's hosted model gateway.

Check whether gcloud is installed

which gcloud

Install if missing

brew install --cask google-cloud-sdk

Authenticate

gcloud auth application-default login

Create a dbt account (first-run flow)

The first time you launch dbt Wizard, it opens a browser-based sign-in flow against the dbt platform. Follow these ten steps in order.

1. Press Enter to sign in

   The CLI prompts you to authenticate. Press Enter to open your default browser at the dbt platform sign-in page.

2. Create account

   On the sign-in page, click "Create account" rather than logging in. Use your @fivetran.com email.

   If you get a message about your account already existing, create a new account with +1 at the end. Ex: jane.doe+1@fivetran.com. The dbt accounts team is working on fixing this.
3. Verify your email

   Open the verification email from dbt Labs and click the confirmation link.

4. Return to the terminal

   Switch back to the terminal window where dbt Wizard is waiting. The browser tab can stay open.

5. Click "Sign in", not "Continue"

   The browser flow gives you two options. Choose Sign in. Choosing Continue will loop you back to the account-creation form.

6. Reset your password

   On the sign-in page, click "Forgot password" to trigger a password reset. This is required for new accounts created through this flow.

7. Enter your email

   Type the same email you used to create the account (including the +1 suffix if you needed it).

8. Set a new password

   Follow the email link and set a new password. Save it in your password manager.

9. Sign in with the new password

   Return to the sign-in page and authenticate with your email and the new password.

10. Set up 2FA

    You'll be prompted to configure two-factor authentication. Use your authenticator app of choice. Once 2FA is configured, the CLI session will pick up the auth and drop you into a dbt Wizard prompt.

Troubleshooting

The common things that go wrong, and how to fix them.

command not found: dbt-wizard

Re-run the install script and check that the install location is on your PATH. The installer prints the path it wrote to at the end. If your shell can't find it, source your shell rc file or open a new terminal.

Auth errors when invoking the agent

Your ADC token has expired or was never set. Re-run:

gcloud auth application-default login

dbt_show returns no rows

Two usual culprits: the wrong profile is selected, or the run-cache dependency is missing. Confirm your profile in ~/.dbt/profiles.yml matches dbt_hands_on_lab_profile, and make sure your venv has the right dbt deps:

pip install "run-cache>=2.6.1"

Browser doesn't open during first-run

Copy the URL the CLI prints and paste it into a browser by hand. The flow works the same.

Stuck on 2FA setup

If your authenticator app rejects the code, double-check the time sync on your phone. If the QR code never appears, refresh the page and the dbt platform will regenerate it.