Establishing a workspace connection to a BigQuery data warehouse allows any workflow in that workspace to access tables from datasets in BigQuery.

To establish a connection to your BigQuery data warehouse, click the Integrations tab in your workspace and select New Integration.

When establishing a connection, the following information is required:



Connection Name

Choose a name for your connection


Service account key file generated by BigQuery

Importing data uses the BigQuery Storage API, which must be enabled on your Google Cloud Platform account.

Database configuration instructions

To connect Cascade to your BigQuery project, you will need to create a service account for Cascade to use.

Generate a new BigQuery service account key

You must have Google Cloud admin permissions to create a service account. Google has documentation on creating a service account and generating a service account key.

  1. Your service account requires two Google BigQuery predefined roles:

    • BigQuery > BigQuery Data Editor

    • BigQuery > BigQuery Job User

    Select the first role in the Select a role field, then click ADD ANOTHER ROLE and select the second role.

Use your key to connect BigQuery to Cascade

  1. Return to Cascade, and begin the process to connect a BigQuery database. When you see the form to enter your BigQuery credentials, first enter a name for the new database connection.

  2. Open the service account key you downloaded from BigQuery in a text editor, and copy the contents.

  3. In the Key field, paste the contents of the service account key into the text box.

  4. Click Test and Save to complete the connection.

Once an integration is established, open a workflow and select Import from BigQuery to pull data from your database into Cascade.

Last updated