Our platform lets you quickly and easily connect your data sources to a Google BigQuery table, enabling streamlined data synchronization.

One-Way Synchronization

This connector supports one-way synchronization, meaning any updates in the BigQuery table are regularly pulled into your data source.

Updates will continue automatically unless:

• The connector is removed, or
• An error occurs (e.g., losing authorization to access the database)

Before you begin, ensure your organization has a valid Google Cloud Platform Connection (GCP) configured. You must also set a few basic things in the GCP console.

Creating Task Connectors

Step 1: Create or Edit Task Template

1. Go to the Task & Dispatch section on the main menu.
2. Go to the Task Templates page using the navigation bar.
3. You can either:
   • Click ADD NEW to create a new template (learn more here).
   • Click on an existing template (when editing an existing template, a “Connectors” tab will be available on the template details page).

Step 2: Add a BigQuery Connector

• Open the Connectors tab within your selected Task Template.
• Click the ADD CONNECTOR button.
• Choose BigQuery from the list of available options.

The page will refresh, displaying the BigQuery connector configuration fields.

Configuring the BigQuery Connector

• Project ID: Specify the Google Cloud project ID that contains your BigQuery table and dataset.
• Custom SQL: Enter a custom SQL query to be executed in a single transaction by this connector.
  Use our data templating syntax to inject Task and User data.
  e.g.
  DELETE FROM MyDataset.MyTaskStatusTable WHERE Id = '{{%TASKGUIDFULL}}';
• Anonymize Personal Data: If enabled, data from fields marked as Personal Data will be converted to a non-human-readable format to aid privacy.
• Once configured, click SAVE to store your settings and activate the Connector.

If you want to access task-specific information in your connector, use one of our built-in Task metadata placeholders.

You can access these placeholders via the Formula Builder (which can be opened wherever you see a “hammer” icon).

Selecting the Trigger

Choose when the connector should run. Available trigger options include:

Overdue

Selecting Task is Overdue from the dropdown list will allow you to select how many days overdue the task is before the connector is triggered.

Owner Changed

Selecting Task Owner Changed from the dropdown list will allow you to trigger the connector when the owner changes.

Status Changed

Selecting Task Status Changed from the dropdown list will allow you to trigger the connector based on status change.