Our platform enables you to quickly and easily connect your data sources to Google BigQuery table.
This enables a one-way synchronization to occur - where any changes in the Google BigQuery table are downloaded into your data source on a regular basis.
Your data source will be automatically updated in this way until you remove the connector or an error occurs (such as losing authorization to access the database).
Before you add a Google BigQuery Connector, you must ensure that you have a valid Google Cloud Platform Connection set up on your organisation. You also need to setup a few basic things in the GCP console.
Creating Task Connectors
Go to the Tasks main menu item, then jump to the "templates" page via the navigation bar.
You should see a list of your existing Task Templates displayed.
If you don't have any Templates, then add a new template by clicking on the ADD NEW button.
This starts the task template wizard. You can read more on the steps to create a Task Template here
When creating a new Template, you will encounter a step in the wizard named Connectors.
If you edit an existing Template, you should see an additional navigation link named "connectors" off the Template details page.
Once on the Connectors page, click the ADD CONNECTOR button.
You can then select BigQuery option.
This will refresh the page and display your Connector, ready for configuration:
- Project ID: Specify the Google Cloud project id that contains your BigQuery table and dataset.
- Custom SQL: Add the desired query that will fire once the trigger conditions have been met. This query will fire against the Project Id specified.
- Anonymize Personal Data: If enabled, data from fields marked as Personal Data will be converted to a nonhuman-readable format to aid privacy.
Hit the SAVE button to save your changes and activate the Connector.
If you want to access Task specific information in your connector, simply use one of our built-in Task metadata placeholders.
You can access these placeholders via the Formula Builder (which can be opened where ever you see a "hammer" icon).
Selecting the Trigger
Select what will trigger your connector to run, options being:
- Task is Overdue
- Task Owner Changed
- Task Status Updated
Task is Overdue
Selecting Task is Overdue from the dropdown list will give you the option of selecting how many days overdue the task is before the connector is triggered.
Task Owner Changed
Selecting Task Owner Changed from the dropdown list will allow you to trigger the connector when the owner changes.
Task Status Changed
Selecting Task Status Changed from the dropdown list will allow you to trigger the connector based on change of status.