Getting started

Steps to Download Service account key JSON file

Requirements

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

See the setup guide for more information about how to create the required resources.

Service account

Step 1:

In order for Future Agi to sync data from BigQuery, it needs credentials for a Service Account with the "BigQuery User" and "BigQuery Data Editor" roles, which grants permissions to run BigQuery jobs, write to BigQuery Datasets, and read table metadata. We highly recommend that this Service Account is exclusive to Future Agi for ease of permissioning and auditing. However, you can use a pre-existing Service Account if you already have one with the correct permissions.

Step 2:

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

Step 3:

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.

Download Service account key JSON file

Step 1:

Service Account Keys are used to authenticate as Google Service Accounts. For Future Agi 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. Future Agi 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. Once you've successfully configured BigQuery as a source in Future Agi, delete this key from your computer.

Now you can Setup the BigQuery source in Future Agi using downloaded Service Account Key JSON file.

Sample json file

{
	"type": "service_account",
	"project_id": "",
	"private_key_id": "",
	"private_key": "-----BEGIN PRIVATE KEY-----\nMIIEvgU7\npCDP9PUHYb\n-----END PRIVATE KEY-----\n",
	"client_email": "",
	"client_id": "",
	"auth_uri": "https://accounts.google.com/o/oauth2/auth",
	"token_uri": "https://oauth2.googleapis.com/token",
	"auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
	"client_x509_cert_url": "",
	"universe_domain": "googleapis.com"
}

Once you've configured BigQuery as a source, delete the Service Account Key from your computer.