Bigquery

Bigquery is currently the only supported backend for amlaidatatests.

Connection String

bigquery://{project_id}/{dataset_id}?location&labels.first=value1&labels.second=value2

project:

The Google cloud billing project

dataset:

The bigquery dataset id in which queries are executed

location:

The bigquery location of the dataset

labels:

Key value pairs that will be added to default query job labels in the BigQuery client, formatted as labels.{label_key}={label_value}

Authentication

amlaidatatests uses Google Application Default Credentials to authenticate to GCP.

This means that the environment is inspected to locate your credentials and these credentials are used. There are a range of options depending on the environment you are using, and you should read more about these options in the google cloud documentation. Fully documenting the options to authenticate using Application Default Credentials is beyond the scope of this documentation.

Authenticate for local development

The simplest usage for interactive access is to:

1. Install the gcloud SDK and interactively obtain user credentials.

2. Interactively authenticate:

   $ gcloud auth login