dbt Cloud: Create a project

Now that we've successfully run our sample query in BigQuery, and chosen the way we want to develop, we can create a dbt project! In this step, we'll create a starter project with example models, before we build our own models.

Create the starter project

  1. Create a dbt Cloud account here. If your organization already has a dbt Cloud account, ask an admin to add you as a Developer.
  2. If you created a new account, a new project should automatically be created. If you were added to an existing account:
    • Click the hamburger menu, then Account Settings, then Projects.
    • Name your project "dbt Tutorial", and click Save. There's no need to fill in the other details.
    • Click the hamburger menu, and then Home.
    • Switch the project in the header bar to your new "dbt Tutorial" project.
  3. Complete the project setup flow:
    • Connect to BigQuery using the credentials file from the Setting Up instructions.
    • Add a repository — choose managed repository, and name it dbt-tutorial. If you're comfortable with git, you can also choose to link to an existing, but bare, repository.
dbt Cloud Project Setup flow
dbt Cloud Project Setup flow
  1. Go to the Develop interface by either:

    • Selecting Start Developing, or
    • Selecting the hamburger menu, and then Develop.
  2. Select Initialize a project to create your project. You should see a directory structure with .sql and .yml files that were generated by the init command.

    The starter project in dbt Cloud
    The starter project in dbt Cloud
  3. Update the following values in the dbt_project.yml file:

name: jaffle_shop # this normally says my_new_package
...
models:
jaffle_shop: #this normally says my_new_package. It should match the value for `name:`
...

Perform your first dbt run

Our sample project has some example models in it. We're going to check that we can run them to confirm everything is in order. In the terminal bar at the bottom of the screen, type in dbt run and hit enter.

A successful run of the starter project in dbt Cloud
A successful run of the starter project in dbt Cloud

Commit your changes

We need to commit our changes so that our repository has up-to-date code. Click the commit button, with a message like "Create a starter project"

Commit your changes
Commit your changes