Reference documentation and code samples for the BigQuery API module Google::Cloud.
Methods
.bigquery
def self.bigquery(project_id = nil, credentials = nil, scope: nil, retries: nil, timeout: nil) -> Google::Cloud::Bigquery::Project
Creates a new Project
instance connected to the BigQuery service.
Each call creates a new connection.
For more information on connecting to Google Cloud see the Authentication Guide.
- project_id (String) — Identifier for a BigQuery project. If not present, the default project for the credentials is used.
- credentials (String, Hash, Google::Auth::Credentials) — The path to the keyfile as a String, the contents of the keyfile as a Hash, or a Google::Auth::Credentials object. (See Bigquery::Credentials)
-
scope (String, Array<String>) (defaults to: nil) —
The OAuth 2.0 scopes controlling the set of resources and operations that the connection can access. See Using OAuth 2.0 to Access Google APIs.
The default scope is:
https://www.googleapis.com/auth/bigquery
-
retries (Integer) (defaults to: nil) — Number of times to retry requests on server
error. The default value is
5
. Optional. - timeout (Integer) (defaults to: nil) — Default timeout to use in requests. Optional.
require "google/cloud" bigquery = Google::Cloud.bigquery dataset = bigquery.dataset "my_dataset" table = dataset.table "my_table"
#bigquery
def bigquery(scope: nil, retries: nil, timeout: nil) -> Google::Cloud::Bigquery::Project
Creates a new object for connecting to the BigQuery service. Each call creates a new connection.
For more information on connecting to Google Cloud see the Authentication Guide.
-
scope (String, Array<String>) (defaults to: nil) —
The OAuth 2.0 scopes controlling the set of resources and operations that the connection can access. See Using OAuth 2.0 to Access Google APIs.
The default scope is:
https://www.googleapis.com/auth/bigquery
-
retries (Integer) (defaults to: nil) — Number of times to retry requests on server
error. The default value is
5
. Optional. - timeout (Integer) (defaults to: nil) — Default request timeout in seconds. Optional.
require "google/cloud" gcloud = Google::Cloud.new bigquery = gcloud.bigquery dataset = bigquery.dataset "my_dataset" table = dataset.table "my_table" data = table.data # Iterate over the first page of results data.each do |row| puts row[:name] end # Retrieve the next page of results data = data.next if data.next?
The default scope can be overridden with the scope
option:
require "google/cloud" gcloud = Google::Cloud.new platform_scope = "https://www.googleapis.com/auth/cloud-platform" bigquery = gcloud.bigquery scope: platform_scope