Integrating with Google BigQuery

To integrate BigQuery with your Yespo account:

1. Register your account at Google Cloud Platform.
2. Get a project key.
3. Create tables in Google BigQuery for importing data to Yespo; tables with data from Yespo will be created automatically after the first export.

❗️

Important

When creating tables in Google BigQuery, use snake_case or camelCase for field names. This will help avoid spaces in names and simplify integration with Yespo.

Examples of correct names:

• first_name
• loyalty_card_number
• `orderDate

4. Create the Yespo connector.

If you already have a project key and BigQuery tables with data for Yespo, you can go directly to the connector settings.

Creating a Project Key

1. Create a Google Cloud Platform account.
2. Select a project → APIs & Services → Credentials.

3. Click Create credentials → Service account.

4. Enter a service account name and click the Create and continue button.

5. Select BigQuery Admin role, click Continue → Done.

📘

Note

The BigQuery Admin role is required because the connector needs to create and manage tables in your dataset — no narrower, custom role is currently supported. If your security team requires least-privilege access, scope this role to the specific GCP project used for the Yespo integration rather than granting it account-wide.

6. Click the link Manage service accounts on the main page of the Credentials section.

7. Click on the three dots opposite created account and select the option Manage keys.

8. Click on the Add key button and select Create new key option in Keys section.

9. Select JSON key type and click Create.

10. The browser will automatically download the key to the download folder.

Setting up BigQuery Connector

Go to your profile → Settings → Connectors → and select Connect BigQuery.

Create connector:

1. Fill in the Name field.
2. Upload the key file.
3. Click Validate connection to test whether the authorization data is correct. You will see the notification if the connection is successful or not. If the connection fails, check the entered data and contact your system administrator if needed.
4. Set unique contact field: select a table column that contains a unique contact key and Yespo's unique contact key. They should match.
   5. Click Save.

You will see created connector in Settings → Connectors. Click the tab with its name to edit the connector’s parameters.

Now, you can use it for exporting Yespo’s data and for importing data from BigQuery.

📘

Note

• The target BigQuery dataset must already exist before you connect it — Yespo creates the individual tables inside that dataset automatically, but it does not create the dataset itself.
• The connector does not backfill historical data — export starts collecting data only from the moment the connector is activated. If you need data from before that date, request it via the Get contacts activity API method (available for roughly the last 3 months).