How to Set Up dbt Cloud to BigQuery

This is some text inside of a div block.
Published
May 10, 2024
Author

How to Set Up dbt Cloud to BigQuery?

In order to set up dbt Cloud to BigQuery, you will need to create a new project in dbt Cloud. This involves selecting account settings, clicking on '+ New Project', entering a project name and selecting BigQuery for the warehouse.

Create new project -> Select Account settings -> Click + New Project -> Enter project name -> Select BigQuery for warehouse

This code example represents the sequence of steps to create a new project in dbt Cloud and select BigQuery as the warehouse. Each step is separated by an arrow.

  • Create new project: This is the first step in setting up dbt Cloud to BigQuery.
  • Select Account settings: This is where you can manage your dbt Cloud account settings.
  • Click + New Project: This initiates the creation of a new project.
  • Enter project name: Here, you provide a unique name for your project.
  • Select BigQuery for warehouse: This is where you select BigQuery as the warehouse for your project.

How to Set Up the Connection in dbt Cloud to BigQuery?

Setting up the connection involves uploading a Service Account JSON File in the settings. You then select the JSON file that was downloaded when you generated BigQuery credentials.

In Settings -> Click Upload a Service Account JSON File -> Select the JSON file

This code example outlines the steps to upload a Service Account JSON File in the settings of dbt Cloud and select the JSON file that was downloaded when generating BigQuery credentials.

  • In Settings: This is where you can manage your dbt Cloud settings.
  • Click Upload a Service Account JSON File: This allows you to upload the necessary JSON file to set up the connection.
  • Select the JSON file: Here, you select the JSON file that was downloaded when you generated BigQuery credentials.

How to Test the Connection in dbt Cloud to BigQuery?

To test the connection, you click on 'Test Connection'. If the test fails, you need to regenerate the BigQuery credentials. If the test succeeds, you can proceed to the next step.

Click Test Connection -> If test fails, regenerate BigQuery credentials -> If test succeeds, click Next

This code example demonstrates the steps to test the connection in dbt Cloud to BigQuery. It includes the actions to take if the test fails or succeeds.

  • Click Test Connection: This initiates the connection test.
  • If test fails, regenerate BigQuery credentials: This is the action to take if the connection test fails.
  • If test succeeds, click Next: This is the action to take if the connection test succeeds.

Where to Find More Information on Using dbt with BigQuery?

For more information on using dbt with BigQuery, you can consult the docs.github.com/dbt-bigquery package.

Consult docs.github.com/dbt-bigquery package

This code example suggests consulting the docs.github.com/dbt-bigquery package for more information on using dbt with BigQuery.

  • Consult docs.github.com/dbt-bigquery package: This is where you can find more detailed information on using dbt with BigQuery.

Keep reading

See all