You can't use this until you register with us!




Description

Use information in Zen Planner to update data in BigQuery.


Purchasing Options



Available Actions

Update Data

Use information in Zen Planner to update data in BigQuery.


Variables

Zen Planner Parameters
zenplanner_credentials required

Credentials used to access Zen Planner.

data_type required

Select the type of data to update.

include_future_dated_records

Some data types, such as Classes, have future dated records. Enable to include future dated records.

pointer

Datetime stamp indicating the begin date of the data to update for data types that are date based, such as Classes. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone.


BigQuery Parameters
bq_creds required

Credentials to use to access the BigQuery Cloud Data Warehouse.

gcp_project_id required

Name of the project with the dataset where the data will be updated.

gcp_dataset_id required

Name of the dataset with the table where the data will be updated.

gcp_table required

Name of the table where the data will be updated.

create_dataset_if_not_exists

Enable to create the specified dataset if it does not exist.

load_pattern

Select which pattern to use when loading the data.

scope_query required

Query to execute in BigQuery that will return a list of Scope ID's.