Connecting Big Query via MindsDB cloud

[saldanhad]

The json service account file is stored in my system, however the Big Query handler for MindsDB cloud needs it in a url format, any idea how this can be done?

[ZoranPandovski]

Hi @saldanhad for MindsDB cloud you will need to upload the file on a filestorage service as s3 and reference the url to it as:

CREATE DATABASE bigquery_datasource
WITH ENGINE='bigquery',
PARAMETERS={
  "project_id": "badger-345908",
  "service_account_keys": {
    "url": "http://s3-us-east-1.amazonaws.com/bucket/"
  }
};

This is not the most secure way but we will add the auth option for the files soon.

[saldanhad]

Hi @ZoranPandovski thanks for clarifying!