1. Data integration
  2. Anaplan Data Integration
  3. CloudWorks
  4. Create a new connection
  5. Connect to Google Big Query

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 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

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.
The Connect to a service dialog. A reminder to paste the JSON displays.