bigquery

Connecting JavaScript and BigQuery with ADBC

Instructions

Prerequisites

1. Install Node.js (version 22 or later)

   • Alternatively, you can use Bun or Deno

2. Install dbc

3. Install Google Cloud CLI

4. Create a Google account or be able to log in to an existing one

Set up BigQuery

1. Log into the Google Cloud Console and create a project or locate an existing project and record the project ID for use in a later step

2. Run this command in your terminal to log in with the Google Cloud CLI:

   gcloud auth application-default login

Connect to BigQuery

1. Install the BigQuery ADBC driver:

   dbc install bigquery

2. Install dependencies:

   npm --prefix .. install

3. Customize the script main.js as needed

   • Change the connection arguments in databaseOptions
     • Change the value of adbc.bigquery.sql.project_id to match the project ID you recorded in the earlier step
     • Change the value of adbc.bigquery.sql.dataset_id, or keep it to use the public Shakespeare dataset
   • If you changed the dataset, also change the SQL SELECT statement in conn.query()

4. Run the script:

   Node.js:

   node main.js

   Bun:

   bun run main.js

   Deno:

   deno run --allow-ffi --allow-env main.js