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.
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, grantingBigQuery Data Viewer and BigQuery Metadata Viewer roles should be sufficient.
- If you also want to perform DML operation within Preset, grant the BigQuery Data Editor role as well.
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.