npm package discovery and stats viewer.

Discover Tips

  • General search

    [free text search, go nuts!]

  • Package details

    pkg:[package-name]

  • User packages

    @[username]

Sponsor

Optimize Toolset

I’ve always been into building performant and accessible sites, but lately I’ve been taking it extremely seriously. So much so that I’ve been building a tool to help me optimize and monitor the sites that I build to make sure that I’m making an attempt to offer the best experience to those who visit them. If you’re into performant, accessible and SEO friendly sites, you might like it too! You can check it out at Optimize Toolset.

About

Hi, 👋, I’m Ryan Hefner  and I built this site for me, and you! The goal of this site was to provide an easy way for me to check the stats on my npm packages, both for prioritizing issues and updates, and to give me a little kick in the pants to keep up on stuff.

As I was building it, I realized that I was actually using the tool to build the tool, and figured I might as well put this out there and hopefully others will find it to be a fast and useful way to search and browse npm packages as I have.

If you’re interested in other things I’m working on, follow me on Twitter or check out the open source projects I’ve been publishing on GitHub.

I am also working on a Twitter bot for this site to tweet the most popular, newest, random packages from npm. Please follow that account now and it will start sending out packages soon–ish.

Open Software & Tools

This site wouldn’t be possible without the immense generosity and tireless efforts from the people who make contributions to the world and share their work via open source initiatives. Thank you 🙏

© 2024 – Pkg Stats / Ryan Hefner

@google-cloud/bigquery

v7.9.1

Published

Google BigQuery Client Library for Node.js

Downloads

3,055,747

Readme

Google BigQuery: Node.js Client

release level npm version

Google BigQuery Client Library for Node.js

A comprehensive list of changes in each version may be found in the CHANGELOG.

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 BigQuery API.
  3. Set up authentication 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. Each sample's README.md has instructions for running its sample.

| Sample | Source Code | Try it | | --------------------------- | --------------------------------- | ------ | | Add Column Load Append | source code | Open in Cloud Shell | | Add Column Query Append | source code | Open in Cloud Shell | | Add Empty Column | source code | Open in Cloud Shell | | Auth View Tutorial | source code | Open in Cloud Shell | | Browse Table | source code | Open in Cloud Shell | | Cancel Job | source code | Open in Cloud Shell | | Client JSON Credentials | source code | Open in Cloud Shell | | Copy Table | source code | Open in Cloud Shell | | Copy Table Multiple Source | source code | Open in Cloud Shell | | Create Dataset | source code | Open in Cloud Shell | | Create Job | source code | Open in Cloud Shell | | Create Model | source code | Open in Cloud Shell | | Create Routine | source code | Open in Cloud Shell | | Create Routine DDL | source code | Open in Cloud Shell | | Create Table | source code | Open in Cloud Shell | | Create Table Clustered | source code | Open in Cloud Shell | | Create Table Column ACL | source code | Open in Cloud Shell | | Create Table Partitioned | source code | Open in Cloud Shell | | Create Table Range Partitioned | source code | Open in Cloud Shell | | Create View | source code | Open in Cloud Shell | | Ddl Create View | source code | Open in Cloud Shell | | Delete Dataset | source code | Open in Cloud Shell | | Delete Label Dataset | source code | Open in Cloud Shell | | Delete Label Table | source code | Open in Cloud Shell | | Delete Model | source code | Open in Cloud Shell | | Delete Routine | source code | Open in Cloud Shell | | Delete Table | source code | Open in Cloud Shell | | Extract Table Compressed | source code | Open in Cloud Shell | | Extract Table JSON | source code | Open in Cloud Shell | | Extract Table To GCS | source code | Open in Cloud Shell | | Get Dataset | source code | Open in Cloud Shell | | Get Dataset Labels | source code | Open in Cloud Shell | | Get Job | source code | Open in Cloud Shell | | BigQuery Get Model | source code | Open in Cloud Shell | | Get Routine | source code | Open in Cloud Shell | | BigQuery Get Table | source code | Open in Cloud Shell | | Get Table Labels | source code | Open in Cloud Shell | | Get View | source code | Open in Cloud Shell | | Insert Rows As Stream | source code | Open in Cloud Shell | | Inserting Data Types | source code | Open in Cloud Shell | | BigQuery Label Dataset | source code | Open in Cloud Shell | | Label Table | source code | Open in Cloud Shell | | List Datasets | source code | Open in Cloud Shell | | List Datasets By Label | source code | Open in Cloud Shell | | List Jobs | 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 Routines | 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 Clustered | source code | Open in Cloud Shell | | Load Table GCS Avro | source code | Open in Cloud Shell | | Load Table GCS Avro 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 | | Load Table Partitioned | source code | Open in Cloud Shell | | Load Table URI Firestore | source code | Open in Cloud Shell | | Nested Repeated Schema | source code | Open in Cloud Shell | | Query | source code | Open in Cloud Shell | | Query Batch | source code | Open in Cloud Shell | | Query Clustered Table | source code | Open in Cloud Shell | | Query Destination Table | source code | Open in Cloud Shell | | Query Disable Cache | source code | Open in Cloud Shell | | Query Dry Run | source code | Open in Cloud Shell | | Query External GCS Perm | source code | Open in Cloud Shell | | Query External GCS Temp | source code | Open in Cloud Shell | | Query Legacy | source code | Open in Cloud Shell | | Query Legacy Large Results | source code | Open in Cloud Shell | | Query Pagination | 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 Named Types | source code | Open in Cloud Shell | | Query Params Positional | source code | Open in Cloud Shell | | Query Params Positional Types | 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 Short Mode | source code | Open in Cloud Shell | | Query Stack Overflow | source code | Open in Cloud Shell | | Quickstart | source code | Open in Cloud Shell | | Relax Column | source code | Open in Cloud Shell | | Relax Column Load Append | source code | Open in Cloud Shell | | Relax Column Query Append | source code | Open in Cloud Shell | | Remove Table Clustering | source code | Open in Cloud Shell | | Set Client Endpoint | source code | Open in Cloud Shell | | Set User Agent | source code | Open in Cloud Shell | | Table Exists | source code | Open in Cloud Shell | | Undelete Table | source code | Open in Cloud Shell | | Update Dataset Access | source code | Open in Cloud Shell | | Update Dataset Description | source code | Open in Cloud Shell | | Update Dataset Expiration | source code | Open in Cloud Shell | | BigQuery Update Model | source code | Open in Cloud Shell | | Update Routine | source code | Open in Cloud Shell | | Update Table Column ACL | source code | Open in Cloud Shell | | Update Table Description | source code | Open in Cloud Shell | | Update Table Expiration | source code | Open in Cloud Shell | | Update View Query | source code | Open in Cloud Shell |

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

Supported Node.js Versions

Our client libraries follow the Node.js release schedule. Libraries are compatible with all current active and maintenance versions of Node.js. If you are using an end-of-life version of Node.js, we recommend that you update as soon as possible to an actively supported LTS version.

Google's client libraries support legacy versions of Node.js runtimes on a best-efforts basis with the following warnings:

  • Legacy versions are not tested in continuous integration.
  • Some security patches and features cannot be backported.
  • Dependencies cannot be kept up-to-date.

Client libraries targeting some end-of-life versions of Node.js are available, and can be installed through npm dist-tags. The dist-tags follow the naming convention legacy-(version). For example, npm install @google-cloud/bigquery@legacy-8 installs client libraries for versions compatible with Node.js 8.

Versioning

This library follows Semantic Versioning.

This library is considered to be 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 stable libraries are addressed with the highest priority.

More Information: Google Cloud Platform Launch Stages

Contributing

Contributions welcome! See the Contributing Guide.

Please note that this README.md, the samples/README.md, and a variety of configuration files in this repository (including .nycrc and tsconfig.json) are generated from a central template. To edit one of these files, make an edit to its templates in directory.

License

Apache Version 2.0

See LICENSE