Skip to main content
This guide is specific to setting up a dataloader with Google BigQuery. To learn more about data loaders in general, you can read our general article.

​
Authorizations

To set up our BigQuery connector, you’ll need to configure a Service Account with the right permissions. To do so, you can follow these steps:
  1. Go to the Google Cloud Console for the project containing your database and navigate to the IAM & Admin tab.
  2. Click Create Service Account, enter a name and description for the service account, then click Create.
  3. Assign the following roles to the service account: BigQuery Data Viewer and BigQuery Job User, then click Continue and Done.
  4. Find the newly created service account in the list and click it. Go to the Keys tab, click Add Key, and select Create new key. Select JSON, then click Create.

​
Load your data

To get started, just go to the data loaders page in Hyperline, create a new connection and select “Google BigQuery” in the dropdown list.
Copy and paste the content of the JSON key file in the correct box, enter a name and then save the connection. When creating or updating a connection, Hyperline always performs a ping test to check that the database is accessible. If the test passes, your connection is ready.