Extend the BigQuery scope to support sheets

[tombaeyens]

https://soda-community.slack.com/archives/C01HYL8V64C/p1615918663005600

David Schoel 7:17 PM
Testing soda-sql with BigQuery, via a service account.
Is there a way to include the scope of https://www.googleapis.com/auth/drive to enable testing against Google Sheet External tables?
For reference, see how dbt handles here:
https://github.com/fishtown-analytics/dbt/blob/1060035838650a30e86989cbf2693db7720ff002/plugins/bigquery/dbt/adapters/bigquery/connections.py#L[…]31 (edited)

plugins/bigquery/dbt/adapters/bigquery/connections.py:129-131
SCOPE = ('https://www.googleapis.com/auth/bigquery',
'https://www.googleapis.com/auth/cloud-platform',
'https://www.googleapis.com/auth/drive')
https://github.com/fishtown-analytics/dbt|fishtown-analytics/dbtfishtown-analytics/dbt | Added by GitHub

[vijaykiran]

Duplicate of sodadata/soda-core#779