1. Data integration
  2. Anaplan Data Integration
  3. CloudWorks
  4. Create a new integration
  5. Integrate with Google Big Query

Integrate your Google Big Query dataset to pull or push Anaplan model data.

Your existing import and export actions may not work with Google BigQuery integrations. Create new ones by following the steps below.

Import 

There are  prerequisites for an import:

  • From your BigQuery table, export a data sample, as well as the table column headers (in CSV format).
  • You use this CSV file to set up your import action in Anaplan. 
  • With the Anaplan import action, you create your CloudWorks BigQuery import integration.
  • Your BigQuery table column header name cannot contain blank spaces, or you will get an error.
Create an integration dialog, import from BigQuery example.
  1. Click New integration / process. Select Import/Export from the drop-down menu. 
  2. Complete the dialog entries:
    • Enter the Integration 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 your Connection from the drop-down menu.
    • Select your Workspace from the drop-down menu.
    • Select your Model from the drop-down menu.
    • Select the Action Type: Import 
    • Select the Data source from the drop-down menu.
    • Select the Action from the drop-down menu.
  3. Click Save to accept and apply your settings for this integration.

Note: Your BigQuery table column headers cannot contain spaces. Use _ underscores instead.
If your BigQuery table column headers do contain spaces, you will get the error Failed import action - Incorrect file structure.

Export

If your integration export is from a model list that has Selective Access enabled:

  •  Make sure that your workspace administrator has granted the list Internal (Full Access).
  •   Internal (Full Access) is a type of Selective Access that represents integration service. 

When you create an integration export there are a few extra steps:

    • You map fields between Anaplan and BigQuery.
    • The data types on both sides must match. Supported data types are string, integer, float, numeric, Boolean, and date.
    • You must define the row headers in Anaplan.
    • Your export must be in .csv format to load into a BigQuery table.
    • You cannot use Anaplan dynamic cell access.
Export integration dailog, set to a Big Query table.

The Map fields dialog displays. 

Field mapping dialog for an integration export to a Big Query table.
  • Use the dropdowns to map fields from the Anaplan export action to your Big Query table elements.
  • To overwrite the data, check Overwrite data target (above). 
  • Select Create.

You get the notification "Integration Successfully created."