Integrating with Google BigQuery

To integrate BigQuery with your eSputnik account:

  • Register your account at Google Cloud Platform,
  • Get a project key,
  • Create tables in Google BigQuery for importing data to eSputnik; tables with data from eSputnik will be created automatically after the first export.
  • Create the eSputnik connector.

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

Creating a Project Key

  1. Create a Google Cloud Platform account.
  2. Select a project → APIs & ServicesCredentials.
Credentials
  1. Click Create credentials → Service account.
Service account
  1. Enter a service account name and click the Create and continue button.
Create and continue
  1. Select BigQuery Admin role, click Continue → Done.
Done
  1. Click the link Manage service accounts on the main page of the Credentials section.
Credentials
  1. Click on the three dots opposite the created account and select the option Manage keys.
Manage keys
  1. Click on the Add key button and select the Create new key option in the Keys section.
Create new key
  1. Select JSON key type and click Create.
Create

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

Connecting BigQuery

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

Connect BigQuerry

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 a 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 eSputnik's unique contact key. They should match.
  5. Click Save.
Create connector

The created connector will be displayed in the Settings → Connectors section. Click the tab with its name to edit the connector’s parameters.

Connectors

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