Node.js idiomatic client for BigQuery.
BigQuery is Google's fully managed, petabyte scale, low cost analytics data warehouse. BigQuery is NoOps—there is no infrastructure to manage and you don't need a database administrator—so you can focus on analyzing data to find meaningful insights, use familiar SQL, and take advantage of our pay-as-you-go model.
Read more about the client libraries for Cloud APIs, including the older Google APIs Client Libraries, in Client Libraries Explained.
Table of contents:
-
Select or create a Cloud Platform project.
-
Enable billing for your project.
-
Enable the Google BigQuery API.
-
Set up authentication with a service account so you can access the API from your local workstation.
npm install --save @google-cloud/bigquery
// Imports the Google Cloud client library
const BigQuery = require('@google-cloud/bigquery');
// Your Google Cloud Platform project ID
const projectId = 'YOUR_PROJECT_ID';
// Instantiates a client
const bigquery = BigQuery({
projectId: projectId,
});
// The name for the new dataset
const datasetName = 'my_new_dataset';
// Creates the new dataset
bigquery
.createDataset(datasetName)
.then(results => {
const dataset = results[0];
console.log(`Dataset ${dataset.id} created.`);
})
.catch(err => {
console.error('ERROR:', err);
});Samples are in the samples/ directory. The samples' README.md
has instructions for running the samples.
| Sample | Source Code | Try it |
|---|---|---|
| Datasets | source code |  |
| Tables | source code | |
| Queries | source code | |
The BigQuery Node.js Client API Reference documentation also contains samples.
This library follows Semantic Versioning.
This library is considered to be in beta. This means it is expected to be mostly stable while we work toward a general availability release; however, complete stability is not guaranteed. We will address issues and requests against beta libraries with a high priority.
More Information: Google Cloud Platform Launch Stages
Contributions welcome! See the Contributing Guide.
Apache Version 2.0
See LICENSE