google-cloud-bigquery
Python library.
The required arguments to establish a connection are as follows:
project_id
is a globally unique identifier for your project.dataset
defines the default dataset. Tables from this dataset are shown in the object tree.service_account_keys
is a full path to the service account key file. This parameter is required but can be replaced by service_account_json
.service_account_json
stores the content of a JSON file defined by the service_account_keys
parameter. This parameter is required when service_account_keys
is not provided.service_account_keys
parameter or the service_account_json
parameter.If you use MindsDB Cloud, it is recommended to provide the service_account_json
parameter, as in the example below.If you use local installation of MindsDB, you can provide either the service_account_keys
parameter or the service_account_json
parameter, as in the example below.mydataset
dataset is the default one. The below queries are equivalent: