Strategy One

Connect to Google BigQuery Using Service Account Authentication

Starting in Strategy One (February 2026), you can use vault connections to store and use service account authentication to connect your Google BigQuery data rather than uploading a JSON file.

Prerequisites

The user must have a vault connection assigned. For more information on creating vault connections, see Create, Edit, and Delete Vault Connections.

Some credential managers do not support storing keys for Google BigQuery service accounts, therefore Strategy Cloud Platform only supports AWS Secrets Manager, Azure Key Vault, and Google Secret Managers to store Google BigQuery credentials.

Connect to Google BigQuery

  1. Create a Mosaic model or right-click an existing Mosaic model and choose Edit.
  2. In the Sources tab, click Add Database.
  3. Select Google BigQuery.

  4. Enter values in the following fields:

    • Name: Type a name for the database connection.
    • Driver: Select JDBC or ODBC.
    • Connection Method: Select Service Account Authentication.

    • Use Vault: Toggle on to use a vault connection and toggle off to upload the credential file from a local machine.

      For more information on generating the credential file and storing it on your local machine or uploading it to a 3rd party vault manager, see Google BigQuery Service Account Authentication.

    • Service Account Wallet: If you are not using a vault connection, upload your access file.
    • Type: If you toggle on Use Vault, select the vault type you want to use.
    • Vault Connection: If you toggle on Use Vault, select the vault connection you want to use.
    • Secret Name: If you toggle on Use Vault, choose the secret name.
    • Billing Project: Type the billing project you want to access.
    • Client Email: Type your Google BigQuery email.
  5. Optionally click Test.

  6. Click Save.

  7. In Sources > Add Tables, click your newly added connection. The available namespaces display in the Preview page.

  8. Select the table(s) you want to add to the Mosaic model and click Add.

  9. Click Proceed.

  10. View and choose suggestions, view object logical relationships, or automatically create attributes and metrics.

  11. Click Save or Publish.

  12. If you Save your Mosaic model:

    1. Type a Name and Description.

    2. Choose a Save in folder location.

    3. Optionally, select the check box next to Certify Mosaic Model.