Skip to content
Node.js client for Google Cloud BigQuery: A fast, economical and fully-managed enterprise data warehouse for large-scale data analytics.
Branch: master
Clone or download
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.github chore: move CONTRIBUTING.md to root (#349) Feb 7, 2019
.kokoro build: switch to GitHub magic proxy (#485) Jun 18, 2019
benchmark chore(deps): update dependency gts to v1 (#419) May 3, 2019
samples chore: release 4.1.3 (#480) Jun 17, 2019
src build: remove unused clang format (#475) Jun 10, 2019
system-test feat(model): dataset model support (#449) May 22, 2019
test feat(table): support all sourceFormat types (#469) May 31, 2019
.eslintignore chore: update nyc and eslint configs (#305) Dec 11, 2018
.eslintrc.yml Enable prefer-const in the eslint config (#198) Sep 20, 2018
.gitignore chore: cleanup repo metadata and remove unused files (#420) May 1, 2019
.jsdoc.js build: check for 404s in the docs (#337) Jan 30, 2019
.nycrc build: ignore proto files in test coverage (#461) May 28, 2019
.prettierignore Repo migration (#1) Nov 15, 2017
.prettierrc Repo migration (#1) Nov 15, 2017
.repo-metadata.json fix(docs): move to new client docs URL (#479) Jun 13, 2019
CHANGELOG.md chore: release 4.1.3 (#480) Jun 17, 2019
CODE_OF_CONDUCT.md Repo migration (#1) Nov 15, 2017
CONTRIBUTING.md docs: update links in contrib guide (#358) Feb 14, 2019
LICENSE chore: update license file (#283) Dec 4, 2018
README.md fix: link to new googleapis.dev docs (#477) Jun 11, 2019
codecov.yaml Update kokoro config (#208) Oct 2, 2018
package.json chore(deps): update dependency eslint-config-prettier to v5 (#483) Jun 17, 2019
renovate.json chore: ignore package-lock.json (#162) Aug 7, 2018
synth.metadata build: switch to GitHub magic proxy (#485) Jun 18, 2019
synth.py fix(docs): change source location to ./build for ts project (#291) Dec 6, 2018
tsconfig.json refactor(ts): enable noImplicitAny (#259) Nov 8, 2018
tslint.json refactor(ts): re-enable fix and lint (#232) Oct 29, 2018

README.md

Google Cloud Platform logo

Google Cloud Bigquery: Node.js Client

release level npm version codecov

Google BigQuery Client Library for Node.js

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

  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 Open in Cloud Shell
Copy Table source code Open in Cloud Shell
Create Dataset source code Open in Cloud Shell
Create Table source code Open in Cloud Shell
Delete Dataset source code Open in Cloud Shell
BigQuery Delete Model source code Open in Cloud Shell
Delete Table source code Open in Cloud Shell
Extract Table To GCS source code Open in Cloud Shell
BigQuery Get Model source code Open in Cloud Shell
Insert Rows As Stream source code Open in Cloud Shell
List Datasets source code Open in Cloud Shell
BigQuery List Models source code Open in Cloud Shell
BigQuery List Models Streaming source code Open in Cloud Shell
List Tables source code Open in Cloud Shell
Load CSV From GCS source code Open in Cloud Shell
Load CSV From GCS Autodetect source code Open in Cloud Shell
Load CSV From GCS Truncate source code Open in Cloud Shell
Load JSON From GCS source code Open in Cloud Shell
Load JSON From GCS Autodetect source code Open in Cloud Shell
Load JSON From GCS Truncate source code Open in Cloud Shell
Load Local File source code Open in Cloud Shell
Load Orc From GCS Truncate source code Open in Cloud Shell
Load Parquet From GCS Truncate source code Open in Cloud Shell
Load Table GCSORC source code Open in Cloud Shell
Load Table GCS Parquet source code Open in Cloud Shell
Query source code Open in Cloud Shell
Query Disable Cache source code Open in Cloud Shell
Query Params Arrays source code Open in Cloud Shell
Query Params Named source code Open in Cloud Shell
Query Params Positional source code Open in Cloud Shell
Query Params Structs source code Open in Cloud Shell
Query Params Timestamps source code Open in Cloud Shell
Query Stack Overflow source code Open in Cloud Shell
Quickstart source code Open in Cloud Shell
BigQuery Update Model source code Open in Cloud Shell

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

You can’t perform that action at this time.