1. Data integration
  2. Anaplan data integration tools
  3. CloudWorks
  4. Create a 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 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 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.

Disclaimer

We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.