In order to connect to Google BigQuery, you'll need to:
- Select an existing Google Project or create a new one;
- Create and configure a Google Service Account; and,
- Create and save a JSON key.
We'll walk you through all of the steps above so that you can get started using your Google BigQuery database connection!
Step One: Select the existing Google Project where you have BigQuery Setup
The Platform Console will display any existing projects — feel free to select the existing project.
Step Two: Create & Configure a Google Service Account
Create a Service Account
Let's start by selecting+ Create Service Account.
In theService account namefield, enter a memorable name for the service account. TheService account IDfield will automatically populate based on the defined account name.
In theService account descriptionfield, enter a brief description of the service account.
When done, select Create and Continue.
In this step, you need to grant service account access. More information here.
In the Select a role field, grant the desired permissions to the service account, according to your needs:
- If you plan to use Preset for read-only access, granting BigQuery Data Viewer and BigQuery Metadata Viewer roles should be sufficient.
- If you also want to perform DML operations within Preset, grant the BigQuery Data Editor role as well.
To run a BigQuery job, you need the
bigquery.jobs.createIAM permission. This permission lets you run jobs programmatically and grants permissions for jobs that BigQuery runs automatically on your behalf.
Each of the following predefined IAM roles includes the permissions that you need in order to run a job:
Additionally, when you create a job, you are automatically granted the following permissions for that job:
For more information about IAM roles and permissions in BigQuery, see Predefined roles and permissions.
When ready, select Done.
The last step—granting access to users—is not required, so feel free to complete the process by selecting Done.
Step Three: Create & Save a JSON Key
A table displaying your new Google Service Account—which we've called WeSupply —appears - click on it!
Our next step is to create a private key in JSON that will be downloaded to your local system. This will be used later on when we configure the database connection in WeSupply.
Step Four: Upload JSON config key into WeSupply
Go to Settings -> Integrations -> App Integrations -> Scroll down to BigQuery and click on it:
Click on Upload and select the JSON file you previously created. Next, select the data that you would like to export to BigQuery and click Save Changes
Within 24 hours you should see data populating your BigQuery account.