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

Your past 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 with 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'll get an error.

Note: Supported Anaplan data types are string, integer, float, numeric, Boolean and date. 

  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 dropdown.
    • Select your Workspace from the dropdown.
    • Select your Model from the dropdown.
    • Select the Action Type: Import.
    • Select the Action from the dropdown.
    • Select the Data source from the dropdown.
  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'll 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.
    • When your Module view includes Page dimensions, use Tabular Multiple Column when you export.
Export with Tabular Multiple Column format.

Below shows the Create a new integration dialog.

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

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.