BigQuery to Glofox Loader

Use data from BigQuery to create or update information in Glofox.

Update Users

Execute an SQL Query against a BigQuery data warehouse and use the results to create or update users in Glofox.

Variables

Source Parameters

bq_creds required

Credentials to use to access the BigQuery Cloud Data Warehouse.

table_name required

Name of the table with data to process, in project.dataset.table format.

pointer required

Datetime stamp indicating the starting point of the data to process. This field will automatically be updated after each increment is processed.

end_query

SQL Query to use to determine the end point of the data to process.

sql_query required

SQL Query to obtain data to process.

post_sql_query

SQL Steps to run after entries in Glowfox have been created or updated.

user_params

Parameters to use in your SQL Queries and Steps, if any. Refer to slide out help for more information.

process_increment

This Task will process data in increments. Set a value in this field to determine the size of each increment.

Destination Parameters

glofox_connection required

Credentials to use to connect to Glofox.

skip_error required

Continue processing subsequent data if an error occurs.

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