Use data from BigQuery to update information in HubSpot.
Use data from BigQuery to update contacts in HubSpot.
Credentials to use to access the BigQuery Cloud Data Warehouse.
SQL query to find new and updated contacts in BigQuery.
Column that holds a timestamp of the last time the row was updated.
Column that holds the id associated with the contact in HubSpot.
Optional table name specified as project.dataset.table to store errors. If specified, invalid contacts will be skipped. Otherwise, invalid contacts trigger an execution failure.
Datetime stamp indicating the last run time. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone.
SQL Query to use to determine the end point of the data to process.
API Key or Access Token to connect to HubSpot.