To let dbt connect to your warehouse, you'll need generate a keyfile. This is like using a database user name and password with most other data warehouses. (but without filling up manually)
- Go to the BigQuery credential wizard. Ensure that your new project is selected in the header bar.
- Generate credentials with the following options:
- Which API are you using? BigQuery API
- What data will you be accessing? Application data (you'll be creating a service account)
- Are you planning to use this API with App Engine or Compute Engine? No
- Service account name: dbt-user
- Role: BigQuery Job User & BigQuery User
- Key type: JSON
- Download the JSON file and save it in an easy-to-remember spot, with a clear filename (e.g. dbt-user-creds.json)