Google Cloud Bigquery: Node.js Client

Google BigQuery Client Library for Node.js

• Google Cloud Bigquery Node.js Client API Reference
• Google Cloud Bigquery Documentation
• github.com/googleapis/nodejs-bigquery

Read more about the client libraries for Cloud APIs, including the older Google APIs Client Libraries, in Client Libraries Explained.

Table of contents:

• Quickstart
  • Before you begin
  • Installing the client library
  • Using the client library
• Samples
• Versioning
• Contributing
• License

Quickstart

Before you begin

1. Select or create a Cloud Platform project.
2. Enable the Google Cloud Bigquery API.
3. Set up authentication with a service account so you can access the API from your local workstation.

Installing the client library

npm install @google-cloud/bigquery

Using the client library

  // Imports the Google Cloud client library
  const {BigQuery} = require('@google-cloud/bigquery');

  async function createDataset() {
    // Creates a client
    const bigqueryClient = new BigQuery();

    // Create the dataset
    const [dataset] = await bigqueryClient.createDataset(datasetName);
    console.log(`Dataset ${dataset.id} created.`);
  }
  createDataset();

Samples

Samples are in the samples/ directory. The samples' README.md has instructions for running the samples.

Sample	Source Code	Try it
Browse Rows	source code
Copy Table	source code
Create Dataset	source code
Create Table	source code
Delete Dataset	source code
Delete Table	source code
Extract Table To GCS	source code
Insert Rows As Stream	source code
List Datasets	source code
List Tables	source code
Load CSV From GCS	source code
Load CSV From GCS Autodetect	source code
Load CSV From GCS Truncate	source code
Load JSON From GCS	source code
Load JSON From GCS Autodetect	source code
Load JSON From GCS Truncate	source code
Load Local File	source code
Load Orc From GCS Truncate	source code
Load Parquet From GCS Truncate	source code
Load Table GCSORC	source code
Load Table GCS Parquet	source code
Query	source code
Query Disable Cache	source code
Query Params Arrays	source code
Query Params Named	source code
Query Params Positional	source code
Query Params Structs	source code
Query Params Timestamps	source code
Query Stack Overflow	source code
Quickstart	source code

The Google Cloud Bigquery Node.js Client API Reference documentation also contains samples.

Versioning

This library follows Semantic Versioning.

This library is considered to be General Availability (GA). This means it is stable; the code surface will not change in backwards-incompatible ways unless absolutely necessary (e.g. because of critical security issues) or with an extensive deprecation period. Issues and requests against GA libraries are addressed with the highest priority.

More Information: Google Cloud Platform Launch Stages

Contributing

Contributions welcome! See the Contributing Guide.

License

Apache Version 2.0

See LICENSE