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.
- Click New integration / process. Select Import/Export from the drop-down menu.
- 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.
- 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.
- 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.

Below shows the Create a new integration dialog.

The Map fields dialog displays.

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