Skip to content

BigQuery - Getting Started

BigQuery is a fully managed enterprise data warehouse that helps you manage and analyze your data with built-in features like machine learning, geospatial analysis, and business intelligence. BigQuery's serverless architecture lets you use SQL queries to answer your organization's biggest questions with zero infrastructure management. BigQuery's scalable, distributed analysis engine lets you query terabytes in seconds and petabytes in minutes. 1

BigQuery Basics for Data Analysts - cloudskillsboost.google

This has been a great learning resource for me.

Google BigQuery: Node.js Client - https://cloud.google.com/nodejs/docs/reference/bigquery/

The BigQuery Node client lets me create query jobs, wait for the results, and solve interesting problems with JavaScript.

Example usage

index.js line 59

const bigquery = new BigQuery();
const table = "`bigquery-public-data.country_codes.country_codes`";
const query = `SELECT country_name as Country, alpha_2_code as Two_Char_Code, alpha_3_code as Three_Char_Code FROM ${table};`;

try {
  let data;
  console.log("Querying ISO Country Codes...");
  const [job] = await bigquery.createQueryJob(query);
  const [result] = await job.getQueryResults();
  // Create workbook
  const workbook = utils.book_new();
  // Worksheet
  data = [...result];
  const worksheet = utils.json_to_sheet(data);
  // Add hyperlinks to worksheet
  for (let index = 0; index < data.length; index++) {
    const element = data[index];
    worksheet[`B${index + 2}`].l = {
      Target: `https://www.iso.org/obp/ui/#iso:code:3166:${element.Two_Char_Code}`,
    };
  }
  // Append NP worksheet to workbook
  utils.book_append_sheet(workbook, worksheet, "ISO Country Codes");
  // Export workbook
  console.log("Exporting results to ISO_Country_Codes.xlsx");
  writeFile(workbook, "ISO_Country_Codes.xlsx");
} catch (error) {
  console.log(error);
}

Example output

ISO_Country_Codes.xlsx

  1. What is BigQuery? - clould.gogle.com ↩