Skip to main content

Configuring BigQuery Private Service Connect betaEnterprise +

Available to certain Enterprise tiers

The private connection feature is available on the following dbt Enterprise tiers:

  • Business Critical
  • Virtual Private

To learn more about these tiers, contact us at sales@getdbt.com.

The following steps walk you through the setup of a GCP BigQuery Private Service Connect (PSC) endpoint in a dbt multi-tenant environment.

Private connection endpoints can't connect across cloud providers. For a private connection to work, both dbt and the server (like BigQuery) must be hosted on the same cloud provider. For example, dbt hosted on AWS cannot connect via PrivateLink to services hosted on Azure, and dbt hosted on Azure can’t connect via Private Link to services hosted on AWS.

Configure GCP Private Service Connect​

To enable dbt to privately connect to your BigQuery project via PSC, the regional PSC endpoint needs be enabled for your dbt account. Using the following template, submit a request to dbt Support:

Subject: New Multi-Tenant GCP PSC Request
- Type: BigQuery
- BigQuery project region: 
- dbt GCP multi-tenant environment:

dbt Labs will work on your behalf to complete the private connection setup. Please allow 3-5 business days for this process to complete. Support will contact you when the endpoint is available.

Create the connection in dbt​

Once the dbt Support team completes the configuration, you can start creating new connections using PSC:

  1. Navigate to Account settings > Connections.
  2. In the Connections page, select BigQuery. Click Edit.
  3. You will see two radio buttons: Default Endpoint and PrivateLink Endpoint. Select PrivateLink Endpoint.
  4. Select the private endpoint from the dropdown (this will automatically populate the API endpoint field).
  5. Configure any remaining data platform details.
  6. Save the connection and test in either a project job or Studio session.

Was this page helpful?

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

0
Edit this page