BigQuery is a serverless and cost-effective enterprise data warehouse that works across clouds and scales with your data.
🐕🦺 Setup guide
Prerequisites
To use the BigQuery source, you'll need:
- A Google Cloud Project with BigQuery enabled
- A Google Cloud Service Account with the "BigQuery User" and "BigQuery Data Editor" roles in your GCP project
- A Service Account Key to authenticate into your Service Account
Before you begin
🤔 What is a Service Account?
Zenskar needs credentials for a Service Account with the "BigQuery User" and "BigQuery Data Editor" roles. These roles grant Zenskar:
- Permission to run BigQuery jobs
- Write to BigQuery Datasets
- Read table metadata
Service Account
We highly recommend that you create a Service Account exclusive to Zenskar for ease of permission and auditing. However, you can use a pre-existing Service Account that has the correct permissions.
🤔 How to create a Service Account?
The easiest way to create a Service Account is to follow GCP's guide for Creating a Service Account. Once you've created the Service Account, make sure to keep its ID handy as you will need to reference it when granting roles. Service Account IDs typically take the form <account-name>@<project-name>.iam.gserviceaccount.com
Then, add the service account as a Member in your Google Cloud Project with the "BigQuery User" role. To do this, follow the instructions for Granting Access in the Google documentation. The email address of the member you are adding is the same as the Service Account ID you just created.
At this point you should have a service account with the "BigQuery User" project-level permission.
🤔 How to create a Service Account Key?
Service Account Keys are used to authenticate as Google Service Accounts. For Zenskar to leverage the permissions you granted to the Service Account in the previous step, you'll need to provide its Service Account Keys. See the Google documentation for more information about Keys.
Follow the Creating and Managing Service Account Keys guide to create a key. Zenskar currently supports JSON Keys only, so make sure you create your key in that format. As soon as you created the key, make sure to download it, as that is the only time Google will allow you to see its contents.
Security
Please delete the Service Account Key JSON from your computer after setting up BigQuery as a data source.
Setup the BigQuery source in Zenskar
⚙️ Set up data source and type
- Log into your Zenskar account.
- In the left navigation bar, click Metering > Data Sources. In the top-right corner, click + ADD DATA SOURCE.
- In the Set Up Source section of the Add New Data Source page, enter a name for the QuickBooks data source connection.
- Select BigQuery from the Source Type dropdown.
⚙️ Configure data source
In the Source Config section of the Add New Data Source page, do the following:
- Default Dataset ID [optional] - the schema name if you are interested in only one schema.
- Project ID - The labeled company ID whose data you'd like to sync.
- Credentials JSON: the contents of the Service Account Key JSON file.