Connect to Google Big Query

There's a limit of 3GB data volume for integrations when you use CloudWorks with BigQuery. You may also review 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
• If you are using a view on a different dataset, follow these instructions(opens external page) 

Permissions to export to BigQuery

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

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

See BigQuery required permissions(opens external page).

To connect your Anaplan model to Big Query, from the CloudWorks console:

1. Select Connections from the menu. 
2. Select New connection.
   The Connect to a service dialog displays. 
3. 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. 
   • Select a Service (Google Big Query) from the drop-down menu.
   • Go to your Google Big Query Account and log in as the primary user.
   • Retrieve your Google Big Query Service Account JSON and copy it into the field below.
     Note: Paste in the entire JSON.
4. Select Connect to accept and apply your settings for this connection.