[Go] Support BigQuery Scopes

[amoeba]

Note: This issue was originally created as apache/arrow-adbc#3522 by yu-iskw and was later copied here as part of migrating active development of the BigQuery Go driver to adbc-drivers/bigquery.

What feature or improvement would you like to see?

We need to additionally specify the Google Drive API scope, if we want to access spreadsheets on Google Drive.

const (
	// Scope is the Oauth2 scope for the service.
	// For relevant BigQuery scopes, see:
	// https://developers.google.com/identity/protocols/googlescopes#bigqueryv2
	Scope = "https://www.googleapis.com/auth/bigquery"
)

https://cloud.google.com/go/docs/reference/cloud.google.com/go/bigquery/latest