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

Description

Obtain data from Glofox and load it into BigQuery.

Purchasing Options

Glofox to BigQuery Loader - $99.99 / month

Available Actions

Load Leads

Retrieve lead information for a specific branch from Glofox and store it in a table in BigQuery.

Variables

Source Parameters
glofox_connection required

Credentials to use to access Glofox.

x_glofox_branch_query required

Query to receive ID's of the branches (studio or location) containing the data to retrieve.

filters

Additional filters to use to download a subset of data. Refer to slide out help for more information.


Destination Parameters
bigquery_connection required

Credentials to use to access the Google Cloud Platform account with the BigQuery database.

project_id required

Unique identifier of the Google Cloud project that contains the dataset where the data will be loaded.

dataset required

Name of the dataset that contains the table where the data will be loaded.

bigquery_table required

Name of the table where the data will be loaded.

region

Optional. Region where the dataset is located.

create_table_if_dne required

Enable to create the table if it does not exist.

bq_config required

Shared Config that contains the load options and column definitions.

process_increment required

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

skip_error required

Continue loading subsequent data if an error occurs.


Range Parameters
range_start_point required

Date where the download of your data should begin. This field will automatically be updated after each increment is processed.

range_data_offset

Fixed amount to adjust the Next Run Start Point.

range_end_point_query

SQL Query to execute against the BigQuery database to determine the end point of the data to download. Leave this field blank to download all data with a date after the Next Run Start Point.


Load Clients

Retrieve clients information for a specific branch from Glofox and store it in a table in BigQuery.

Variables

Source Parameters
glofox_connection required

Credentials to use to access Glofox.

x_glofox_branch_query required

Query to receive ID's of the branches (studio or location) containing the data to retrieve.


Destination Parameters
bigquery_connection required

Credentials to use to access the Google Cloud Platform account with the BigQuery database.

project_id required

Unique identifier of the Google Cloud project that contains the dataset where the data will be loaded.

dataset required

Name of the dataset that contains the table where the data will be loaded.

bigquery_table required

Name of the table where the data will be loaded.

region

Optional. Region where the dataset is located.

create_table_if_dne required

Enable to create the table if it does not exist.

bq_config required

Shared Config that contains the load options and column definitions.

process_increment required

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

skip_error required

Continue loading subsequent data if an error occurs.


Load Memberships

Retrieve membership information for a specific branch from Glofox and store it in a table in BigQuery.

Variables

Source Parameters
glofox_connection required

Credentials to use to access Glofox.

x_glofox_branch_query required

Query to receive ID's of the branches (studio or location) containing the data to retrieve.


Destination Parameters
bigquery_connection required

Credentials to use to access the Google Cloud Platform account with the BigQuery database.

project_id required

Unique identifier of the Google Cloud project that contains the dataset where the data will be loaded.

dataset required

Name of the dataset that contains the table where the data will be loaded.

bigquery_table required

Name of the table where the data will be loaded.

region

Optional. Region where the dataset is located.

create_table_if_dne required

Enable to create the table if it does not exist.

bq_config required

Shared Config that contains the load options and column definitions.

process_increment required

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

skip_error required

Continue loading subsequent data if an error occurs.


Load Classes

Retrieve class information for a specific branch from Glofox and store it in a table in BigQuery.

Variables

Source Parameters
glofox_connection required

Credentials to use to access Glofox.

x_glofox_branch_query required

Query to receive ID's of the branches (studio or location) containing the data to retrieve.

filters

Additional filters to use to download a subset of data. Refer to slide out help for more information.


Destination Parameters
bigquery_connection required

Credentials to use to access the Google Cloud Platform account with the BigQuery database.

project_id required

Unique identifier of the Google Cloud project that contains the dataset where the data will be loaded.

dataset required

Name of the dataset that contains the table where the data will be loaded.

bigquery_table required

Name of the table where the data will be loaded.

region

Optional. Region where the dataset is located.

create_table_if_dne required

Enable to create the table if it does not exist.

bq_config required

Shared Config that contains the load options and column definitions.

process_increment required

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

skip_error required

Continue loading subsequent data if an error occurs.


Range Parameters
range_start_point required

Date where the download of your data should begin. This field will automatically be updated after each increment is processed.

range_data_offset

Fixed amount to adjust the Next Run Start Point.


Load Bookings

Get bookings for specific branch and store the results in a table in BigQuery.

Variables

Source Parameters
glofox_connection required

Credentials to use to access Glofox.

x_glofox_branch_query required

Query to receive ID's of the branches (studio or location) containing the data to retrieve.

filters

Additional filters to use to download a subset of data. Refer to slide out help for more information.


Destination Parameters
bigquery_connection required

Credentials to use to access the Google Cloud Platform account with the BigQuery database.

project_id required

Unique identifier of the Google Cloud project that contains the dataset where the data will be loaded.

dataset required

Name of the dataset that contains the table where the data will be loaded.

bigquery_table required

Name of the table where the data will be loaded.

region

Optional. Region where the dataset is located.

create_table_if_dne required

Enable to create the table if it does not exist.

bq_config required

Shared Config that contains the load options and column definitions.

process_increment required

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

skip_error required

Continue loading subsequent data if an error occurs.


Range Parameters
range_start_point required

Date where the download of your data should begin. This field will automatically be updated after each increment is processed.

range_data_offset

Fixed amount to adjust the Next Run Start Point.

range_end_point_query

SQL Query to execute against the BigQuery database to determine the end point of the data to download. Leave this field blank to download all data with a date after the Next Run Start Point.