Connect to a Google Big Query dataset to integrate with your Anaplan model.

There's a limit of 3GB data volume for integrations when you use CloudWorks with BigQuery. You can also view Introduction to tables to understand table limitations. At a minimum, the following BigQuery permissions are required:

## Project level permissions

• roles/bigquery.jobUser
• roles/bigquery.User

## Permissions to import from BigQuery

• roles/bigquery.dataViewer role on the table or the whole dataset

## Permissions to export to BigQuery

• roles/bigquery.dataEditor role on the table or the whole dataset

These required permissions are to load or edit table data, or to overwrite a table.

See BigQuery required permissions(opens external page).

1. Select Connections from the menu.
2. Select New connection.
The Connect to a service dialog displays.
The Connect to a service dialog. The dropdown choices are Amazon S3, Azure Blob, and Google BigQuery.
2. Complete the dialog entries:
• Enter a new Connection name. Use a unique name that starts and ends with a letter or number. You can include spaces, hyphens (-), and underscores (_), but no other special characters.
The limit is 60 characters.