BigQuery API - Class Google::Cloud::Bigquery::Job::ScriptStatistics (v1.41.0)

Reference documentation and code samples for the BigQuery API class Google::Cloud::Bigquery::Job::ScriptStatistics.

Represents statistics for a child job of a script.

Inherits

  • Object

Example

require "google/cloud/bigquery"

bigquery = Google::Cloud::Bigquery.new

multi_statement_sql = <<~SQL
  -- Declare a variable to hold names as an array.
  DECLARE top_names ARRAY<STRING>;
  -- Build an array of the top 100 names from the year 2017.
  SET top_names = (
  SELECT ARRAY_AGG(name ORDER BY number DESC LIMIT 100)
  FROM `bigquery-public-data.usa_names.usa_1910_current`
  WHERE year = 2017
  );
  -- Which names appear as words in Shakespeare's plays?
  SELECT
  name AS shakespeare_name
  FROM UNNEST(top_names) AS name
  WHERE name IN (
  SELECT word
  FROM `bigquery-public-data.samples.shakespeare`
  );
SQL

job = bigquery.query_job multi_statement_sql

job.wait_until_done!

child_jobs = bigquery.jobs parent_job: job

child_jobs.each do |child_job|
  script_statistics = child_job.script_statistics
  puts script_statistics.evaluation_kind
  script_statistics.stack_frames.each do |stack_frame|
    puts stack_frame.text
  end
end

Methods

#evaluation_kind

def evaluation_kind() -> String

Indicates the type of child job. Possible values include STATEMENT and EXPRESSION.

Returns
  • (String) — the current value of evaluation_kind

#stack_frames

def stack_frames() -> Array<Google::Cloud::Bigquery::Job::ScriptStackFrame>

Stack trace where the current evaluation happened. Shows line/column/procedure name of each frame on the stack at the point where the current evaluation happened. The leaf frame is first, the primary script is last.

Returns