Important: This documentation covers Yarn 1 (Classic).
For Yarn 2+ docs and migration guide, see yarnpkg.com.

Package detail

@google-cloud/bigquery

googleapis2.5mApache-2.07.9.1TypeScript support: included

Google BigQuery Client Library for Node.js

google apis client, google api client, google apis, google api, google, google cloud platform, google cloud, cloud, google bigquery, bigquery

readme

Google Cloud Platform logo

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

changelog

Changelog

npm history

7.9.1 (2024-09-23)

Bug Fixes

  • Throw timeout error when using jobs.query (#1402) (cf962a5)

7.9.0 (2024-08-01)

Features

  • Add retryOptions passing to underlying Service class (#1390) (a7cd3af)
  • Clean cached rows and responses after conversion (#1393) (3fd28b8)

Bug Fixes

7.8.0 (2024-06-19)

Features

7.7.1 (2024-05-31)

Bug Fixes

7.7.0 (2024-05-03)

Features

7.6.1 (2024-04-26)

Bug Fixes

  • Should not override queryParameters if params not informed (#1359) (2b66d1e)

7.6.0 (2024-04-09)

Features

  • Integrate jobs.query and stateless query for faster queries (#1337) (74aa150)

Bug Fixes

7.5.2 (2024-03-27)

Bug Fixes

  • Set projectId in jobs emitted by load streams (#1346) (bd8254c)

7.5.1 (2024-03-14)

Bug Fixes

  • Add better documentation around usage of BigQueryTimestamp class and .timestamp method. (2b2c3e0)
  • BigQueryTimestamp should keep accepting floats #1339 (2b2c3e0)
  • Restores BigQueryTimestamp behavior to accept a numeric value in the constructor representing epoch-seconds. The affected 7.5.0 version would parse a numeric value as epoch-microseconds. (2b2c3e0)

7.5.0 (2024-02-21)

Features

7.4.0 (2024-02-06)

Features

Bug Fixes

  • Prefer usage of projectId from the Dataset (#1326) (9e85219)

7.3.0 (2023-09-28)

Features

Bug Fixes

  • Avoid TypeError if resp is undefined (#1273) (ff51c1d)
  • Updated types from API discovery doc (#1284) (1d8a2b7)
  • Updating type for test blocking dependency updates (#1282) (1dbe0fe)

7.2.0 (2023-08-17)

Features

Bug Fixes

  • deps: Update dependency @google-cloud/common to v5 (#1253) (0cbfdcd)
  • deps: Update dependency @google-cloud/paginator to v5 (#1254) (658ff1a)
  • deps: Update dependency @google-cloud/precise-date to v4 (#1261) (7f12f7d)
  • deps: Update dependency @google-cloud/promisify to v4 (#1252) (6f04f39)
  • Manual update for renovate-bot google cloud storage v7 (#1262) (b58fc29)

7.1.1 (2023-08-03)

Bug Fixes

7.1.0 (2023-08-01)

Features

  • Support and optionally parse JSON field (#1229) (cd11447)
  • Support create/list datasets on a different project (#1230) (86c63fb)

7.0.0 (2023-07-31)

⚠ BREAKING CHANGES

  • migrate to node 14 (#1236)

Bug Fixes

  • deps: Update dependency google-auth-library to v9 (#1228) (22cf786)

Miscellaneous Chores

6.2.1 (2023-07-10)

Bug Fixes

6.2.0 (2023-03-22)

Features

Bug Fixes

6.1.0 (2023-01-25)

Features

6.0.3 (2022-08-23)

Bug Fixes

6.0.2 (2022-08-01)

Bug Fixes

  • adding missing links to bug_report template (#1141) (aa6388a)
  • deps: update dependency @google-cloud/common to v4 (#1127) (bea8b42)
  • deps: update dependency readable-stream to v4 (#1129) (4a252d0)

6.0.1 (2022-06-17)

Bug Fixes

  • call rowQueue insert callback only if present (#1128) (17a0c0d)
  • deps: update dependency @google-cloud/paginator to v4 (#1116) (073abc0)
  • deps: update dependency @google-cloud/storage to v6 (#1119) (d607e5a)

6.0.0 (2022-05-20)

⚠ BREAKING CHANGES

  • update library to use Node 12 (#1114)

Features

Bug Fixes

  • deps: update dependency @google-cloud/promisify to v3 (#1112) (cb0d601)
  • Fix Job#getQueryResultsStream when using startIndex (#1100) (2b7df52)

Build System

5.12.0 (2022-03-02)

Features

  • add support for accessing jobs cross-project (#1083) (9e5bae2)

5.11.0 (2022-02-10)

Features

  • add cross-project support (#1079) (f6a7456)
  • add table.createInsertStream for native streaming inserts (#997) (0ffe544)

Bug Fixes

5.10.0 (2022-01-10)

Features

  • Add jobs.delete and update to latest discovery types (#1023) (12f7771)

5.9.3 (2021-12-13)

Bug Fixes

5.9.2 (2021-11-16)

Bug Fixes

5.9.1 (2021-10-12)

Bug Fixes

  • update queryAsStream_ to set options with Query type (#999) (e7eab0b)

5.9.0 (2021-09-08)

Features

  • publish post-processor images to cloud-devrel-public-resources (#1203) (#1005) (e852cb2)

Bug Fixes

  • return 409 error in createJob() for dry run (#1003) (281e3ff)

5.8.0 (2021-08-23)

Features

  • add support for loading Firestore export file (#991) (c17a44e)

5.7.1 (2021-08-10)

Bug Fixes

5.7.0 (2021-07-21)

Features

  • add gcf-owl-bot[bot] to ignoreAuthors (#958) (9eab78d)

Bug Fixes

  • deps: update dependency yargs to v17 (#954) (28cf08d)
  • extend definition of Query.types for simple named parameters (#906) (#907) (44e1ac7)
  • handle null query parameter value (#920) (3bf900a)
  • promise never returned on table.insert (#953) (a138347)

5.6.0 (2021-04-28)

Features

Bug Fixes

  • deps: update dependency google-auth-library to v7 (#928) (2ce28c7)
  • update returned Job with API-determined location in getMetadata (#900) (8c31358)

5.5.0 (2020-11-10)

Features

Bug Fixes

  • update returned Job with API-determined location (#890) (3894140)

5.4.0 (2020-11-02)

Features

  • optionally wrap INT64 in BigQueryInt or provide a custom INT64 value type cast options (#873) (be7c6e6)

Bug Fixes

  • Detect Geography type during parameterized query (#877) (bc0ca69)
  • do not retry jobs.insert when it flakes (#864) (255491b)
  • return error when custom getQueryResults() timeout has been exceeded (#872) (96f939c)
  • deps: update dependency big.js to v6 (#862) (a47afb5)

5.3.0 (2020-09-30)

Features

  • constructor: add option to set baseUrl using environment variable (#849) (8c54f20)
  • allow setting BigQuery Job labels in createQueryJob method (#865) (be074e7)

Bug Fixes

  • deps: update dependency yargs to v16 (#854) (58dcf34)
  • perf: disable prettyPrint for slimmer API responses (#860) (1e56383)

5.2.0 (2020-08-13)

Features

5.1.0 (2020-07-27)

Features

  • detect param type if not in provided types (#813) (1e5a4cc)

Bug Fixes

  • add string type for query types (#827) (acdecbd)
  • move gitattributes files to node templates (#829) (f26e641)

5.0.1 (2020-07-07)

Bug Fixes

5.0.0 (2020-06-19)

⚠ BREAKING CHANGES

  • don't return Stream from createLoadJob (#647)
  • drop Node 8 from engines field (#662)

Features

Bug Fixes

  • add types for hasDrift and seasonalPeriods (#680) (d6c9566)
  • deps: update dependency @google-cloud/paginator to v3 (#658) (a09c493)
  • apache license URL (#468) (#669) (d3ed602)
  • drop dependency on string-format-obj (#698) (cf8f58f)
  • load job to a different project ID (#748) (bfb74ad)
  • docs: fix link for job configuration load (#678) (ea3d7af)
  • selectedFields on getRows not working correctly (#712) (13b7e39)
  • deps: update dependency @google-cloud/promisify to v2 (#657) (5d8112c)
  • deps: update dependency @google-cloud/storage to v5 (#700) (a2e34ef)
  • deps: update dependency google-auth-library to v6 (#660) (3ea642e)
  • docs: configuration.copy link (#709) (4a81b1e)
  • docs: correct createTablePartitioned sample argument (#701) (9a7520e)
  • table: add retries for insert partial failures (#589) (b8639c2), closes #655
  • types: drop changes for drift and seasonal (#681) (679d990)

Code Refactoring

4.7.0 (2020-01-30)

Features

4.6.1 (2020-01-13)

Bug Fixes

  • don't modify the constructor options (#607) (7df0799)

4.6.0 (2020-01-05)

Features

  • types to support slot ms and read masks (#592) (84d1c82)

4.5.0 (2019-12-05)

Features

  • table: allow opting out of default insert id (#582) (6bf2dbd)
  • adds policyTags parameter removes IGetParams Interface (#576) (8cf8f1d)

Bug Fixes

  • deps: TypeScript 3.7.0 causes breaking change in typings (#586) (04f8cba)
  • deps: update dependency yargs to v15 (#579) (92119e3)
  • docs: snippets are now replaced in jsdoc comments (#573) (a0d3538)

4.4.0 (2019-11-08)

Features

  • table: typescript support for range partitioning (#559) (a77c28a)
  • typescript support for data split result (#570) (2236545)

Bug Fixes

  • deps: update dependency @google-cloud/storage to v4 (#561) (0ec07f9)

4.3.0 (2019-10-09)

Features

  • TypeScript: introduce IArimaResult interface (4cd3a71)

4.2.1 (2019-09-16)

Bug Fixes

  • deps: update dependency discovery-tsd to ^0.2.0 (#540) (651e870)

4.2.0 (2019-09-07)

Bug Fixes

  • deps: update dependency yargs to v14 (#520) (9dd59a6)
  • types: update to the latest discovery types (#518) (dccf2cf)
  • update root url to bigquery.googleapis.com (#531) (277940f)

Features

  • typescript: generate latest request/response types (#528) (f8d2f4d)

4.1.8 (2019-08-02)

Bug Fixes

  • allow calls with no request, add JSON proto (885a98a)

4.1.7 (2019-08-01)

Bug Fixes

4.1.6 (2019-07-29)

Bug Fixes

  • deps: update dependency @google-cloud/storage to v3 (#508) (bdca2ea)

4.1.5 (2019-07-17)

Performance Improvements

4.1.4 (2019-07-02)

Bug Fixes

  • docs: link to reference docs section on googleapis.dev (#486) (a76cc5b)

4.1.3 (2019-06-17)

Bug Fixes

4.1.2 (2019-06-11)

Bug Fixes

4.1.1 (2019-05-30)

Bug Fixes

  • job: remove job instance from request params (#465) (27f080d)
  • correct name in .repo-metadata.json (#467) (6add722)

4.1.0 (2019-05-29)

Features

4.0.0 (2019-05-20)

⚠ BREAKING CHANGES

  • deps: this will ship async/await with the generated code.
  • upgrade engines field to >=8.10.0 (#424)
  • This removes the autoCreate option which may result in a breaking change for TypeScript users.

Bug Fixes

  • deps: update dependency @google-cloud/common to ^0.32.0 (8e28b62), closes #8203
  • deps: update dependency @google-cloud/common to v1 (#434) (0e4aeef)
  • deps: update dependency @google-cloud/paginator to v1 (#428) (5d925af)
  • deps: update dependency @google-cloud/promisify to v1 (#427) (fdeb862)
  • deps: update dependency arrify to v2 (de0f687)
  • table: allow for TableSchema to be used (#438) (7995be0)
  • types: correct interface (#407) (da5ed01)
  • correctly encode nested struct/array params (#439) (d7006bd)
  • remove teeny-request as a direct dependency (#412) (c6de54a)

Build System

Code Refactoring

  • drop autoCreate in table.insert in favor of schema (#421) (b59cd7f)

Miscellaneous Chores

v3.0.0

04-02-2019 10:02 PDT

Implementation Changes

  • fix(job): check for errorResult when polling jobs (#387)

BREAKING CHANGE Previously when polling a BigQuery Job the Node.js client would check for the presence of the errors field when trying to determine if the job suceeded. We have since changed this logic to instead check for the errorResult field. This is significant because the errors array may now be present for passing jobs, however these errors should serve more as warnings. If your application logic depended on this functionality you'll need to manually check for errors now.

await job.promise();

if (job.metadata.status.errors) {
  // optionally handle warnings
}
  • fix(ts): provide complete and correct types (#385)

BREAKING CHANGE A number of the BigQuery TypeScript types were incomplete, this change provides more complete types for the entire client.

New Features

  • feat(geo): add support for geography (#397)

Bug Fixes

  • fix: correctly encode nested custom date/time parameters (#393)

Dependencies

  • chore(deps): update dependency tmp to v0.1.0 (#398)
  • chore(deps): update dependency @types/tmp to v0.1.0
  • chore(deps): update dependency typescript to ~3.4.0

Documentation

  • docs(samples): adds queryParamsNamed and queryParamsPositional (#381)
  • refactor(samples): split query and table samples into separate files (#384)
  • refactor(samples): fix loadJSONFromGCSTruncate wrong function (#386)
  • refactor(samples): add main() function wrappers to samples

Internal / Testing Changes

  • build: use per-repo npm publish token (#382)
  • chore: publish to npm using wombat (#390)
  • fix(tests): update TIMESTAMP param tests (#394)

v2.1.0

03-12-2019 15:30 PDT

New Features

  • feat: throw errors for missing resource ids (#342)

Bug Fixes

  • fix(types): move JobLoadMetadata writeDisposition (#365)
  • fix(types): Allow views to be configured using an object or a string (#333)
  • fix(types): add missing parameters (selectedFields, startIndex) in table.getRows() options (#331)

Dependencies

  • fix(deps): update dependency @google-cloud/paginator to ^0.2.0 (#373)
  • fix(deps): update dependency @google-cloud/common to ^0.31.0 (#371)
  • fix(deps): update dependency @google-cloud/promisify to ^0.4.0 (#356)
  • fix(deps): update dependency duplexify to v4 (#343)

Documentation

  • docs(table): link to upstream limit docs (#376)
  • docs: update samples and docs to match rubric (#374)
  • docs: update links in contrib guide (#358)
  • docs: update contributing path in README (#350)
  • docs: move CONTRIBUTING.md to root (#349)
  • docs: add lint/fix example to contributing guide (#344)

Internal / Testing Changes

  • testing: remove nextQuery assertion (#377)
  • refactor(samples): split samples into their own files (#368)
  • build: Add docuploader credentials to node publish jobs (#370)
  • build: use node10 to run samples-test, system-test etc (#369)
  • build: system-tests only delete stale resources
  • chore: make test prefix unique per run (#363)
  • chore(deps): update dependency mocha to v6 (#360)
  • test: skip installation test if GOOGLE_CLOUD_TESTS_IN_VPCSC is passed (#345)
  • build: use linkinator for docs test (#354)
  • fix(deps): update dependency yargs to v13 (#353)
  • chore(deps): update dependency @types/tmp to v0.0.34 (#355)
  • build: create docs test npm scripts (#352)
  • build: test using @grpc/grpc-js in CI (#351)
  • build: check for 404s in the docs (#337)
  • build: output benchmark data in csv format (#339)
  • chore(deps): update dependency eslint-config-prettier to v4 (#338)

v2.0.6

01-08-2019 13:52 PST

Fixes

  • fix: correctly iterate query results within stream (#323)
  • fix: remove Job.setMetadata method (#319)
  • fix(deps): update dependency @google-cloud/common to ^0.29.0 (#314)

Documentation

  • fix(docs): package exports an object, not the BigQuery ctor (#322)
  • docs: regenerate README.md (#321)

Internal / Testing Changes

  • refactor: modernize the sample tests (#318)

v2.0.5

12-21-2018 13:19 PST

Bug fixes

  • fix: createQueryJob should accept pageToken (#313)

Internal / Testing Changes

  • fix(test): skip flaky invalid etag test (#317)
  • fix(test): labels: should be an object, not arry (#315)

v2.0.4

12-19-2018 14:35 PST

Implementation Changes

  • fix(ts): explicit usage of Duplex (#300)
  • fix: fix typescript compilation (#295)

Dependencies

  • fix(deps): update dependency @google-cloud/common to ^0.28.0 (#308)
  • chore(deps): update dependency @types/sinon to v7 (#307)
  • fix(deps): update dependency @google-cloud/common to ^0.27.0 (#274)

Documentation

  • fix(docs): move doc comments so stream methods show up in docs correctly (#309)

Internal / Testing Changes

  • chore(build): inject yoshi automation key (#306)
  • chore: update nyc and eslint configs (#305)
  • chore: fix publish.sh permission +x (#302)
  • fix(build): fix Kokoro release script (#301)
  • build: add Kokoro configs for autorelease (#298)

v2.0.3

12-06-2018 17:10 PST

Documentation

  • fix(docs): move comments above last overload (#292)
  • fix(docs): internal links (#293)
  • fix(docs): change source location to ./build for ts project (#291)
  • docs: fix region tag placement typo (#286)

Internal / Testing Changes

  • chore: always nyc report before calling codecov (#290)
  • chore: nyc ignore build/test by default (#289)

v2.0.2

12-04-2018 14:04 PST

Implementation Changes

TypeScript related changes:

  • fix: Changing import of Big from big.js so it doesn't use default (#270)
  • refactor(ts): enable noImplicitAny (#259)
  • refactor(ts): add @types/proxyquire (#256)
  • refactor(ts): refactor system tests to drop unused deps (#254)
  • fix(ts): CopyTableMetadata type can’t receive optional values
  • refactor(ts): complete type annotations for src (#250)
  • refactor(ts): add more types (#246)

Dependencies

  • fix: Pin @types/sinon to last compatible version (#267)
  • chore(deps): update dependency typescript to ~3.2.0 (#276)
  • chore(deps): update dependency gts to ^0.9.0 (#263)
  • chore(deps): update dependency @google-cloud/nodejs-repo-tools to v3 (#261)
  • chore(deps): update dependency @types/is to v0.0.21 (#258)

Documentation

  • chore: update license file (#283)
  • docs: Improve timestamp documentation. (#280)
  • docs: Improve documentationfor load method (#281)
  • docs: update readme badges (#279)
  • refactor(samples): replace promise with async await (#268)

Internal / Testing Changes

  • fix(build): fix system key decryption (#277)
  • refactor(tests): convert samples tests from ava to mocha (#248)
  • chore: add synth.metadata
  • chore: update eslintignore config (#262)
  • chore: drop contributors from multiple places (#260)
  • chore: use latest npm on Windows (#257)
  • chore: update CircleCI config (#249)

v2.0.1

Bug fixes

  • fix: use teeny-request for HTTP requests (#244)

Internal / Testing Changes

  • chore: include build in eslintignore (#240)
  • refactor(ts): enable noImplicitThis in the tsconfig (#237)
  • refactor(ts): improve typing (#241)

v2.0.0

Implementation Changes

This release drops support for Node.js 4.x and 9.x. Future releases might not be compatible with your application if they are still on these non-LTS version. BREAKING CHANGE This library is now compatible with es module import syntax

Old Code

const BigQuery = require('@google-cloud/bigquery')();
// or...
const BigQuery = require('@google-cloud/bigquery');
const bq = new BigQuery();

New Code

const {BigQuery} = require('@google-cloud/bigquery');
const bq = new BigQuery();
  • refactor(typescript): convert index to es module (#227
  • fix: drop support for node.js 4.x and 9.x (#142)
  • wait for job result before emitting complete. (#85)
  • fix: Update table.js (#78)
  • feat: convert to TypeScript (#157)
  • Correctly pass autoPaginate: false to query methods. (#121)
  • chore: use more arrow functions (#172)
  • chore: convert a few files to es classes (#170)

New Features

BigQuery ORC:

  • BigQuery Orc & Parquet Samples (#195)
  • Support ORC files. (#190)

Dependencies

  • chore(deps): update dependency eslint-plugin-node to v8 (#234)
  • chore(deps): lock file maintenance (#143)
  • chore(deps): update dependency sinon to v7 (#212)
  • chore(deps): update dependency eslint-plugin-prettier to v3 (#207)
  • chore(deps): update dependency typescript to ~3.1.0 (#205)
  • chore: upgrade to the latest common (#159)
  • chore(package): update to the latest @google-cloud/common (#146)
  • fix(deps): update dependency @google-cloud/common to ^0.25.0 (#197)
  • fix(deps): update dependency @google-cloud/common to ^0.24.0 (#187)
  • fix(deps): update dependency @google-cloud/storage to v2: edited (#181)
  • chore(deps): update dependency nyc to v13 (#178)
  • chore(deps): update dependency eslint-config-prettier to v3 (#169)
  • chore(deps): lock file maintenance (#160)
  • chore(deps): lock file maintenance (#153)
  • chore(deps): lock file maintenance (#150)
  • chore(deps): update dependency eslint-plugin-node to v7 (#148)
  • chore(deps): lock file maintenance (#147)
  • chore(deps): lock file maintenance (#145)
  • chore(deps): lock file maintenance (#144)
  • chore(deps): lock file maintenance (#141)
  • chore(deps): lock file maintenance (#140)
  • chore(deps): lock file maintenance (#139)
  • chore(deps): update dependency proxyquire to v2 (#135)
  • fix(deps): update dependency yargs to v12 (#138)
  • fix(deps): update dependency yargs to v11 (#137)
  • chore(deps): update dependency sinon to v6 (#136)
  • chore(deps): update dependency nyc to v12 (#134)
  • chore(deps): update dependency @google-cloud/nodejs-repo-tools to v2.3.0 (#128)
  • chore(deps): update dependency uuid to v3.3.0 (#132)
  • chore(deps): update dependency ava to v0.25.0 (#129)
  • chore(deps): update dependency sinon to v4.5.0 (#131)

Documentation

  • docs: Correct table.load().format options. (#206)
  • fix: (docs): Correct query syntax. (#180)
  • docs: Fix create job links (#164)
  • fix(samples): Refactor query samples to follow python canonical and add disable cache sample (#215)
  • chore(samples): Remove unused BigQuery samples and fix comment typos (#201)
  • Use async/await in samples (#193)
  • remove asserts in samples (#182)
  • fix: fix the samples tests (#167)
  • fix: update linking for samples (#125)
  • chore: make samples test work (#113)

Internal / Testing Changes

  • refactor(ts): re-enable fix and lint (#232)
  • fix(tests): fix system-test (#231)
  • Pass an empty object. (#191)
  • fix: (tests) Use a filter to locate datasets used in tests. (#177)
  • chore: update issue templates (#229)
  • chore: remove old issue template (#224)
  • build: run tests on node11 (#223)
  • chores(build): do not collect sponge.xml from windows builds (#221)
  • chores(build): run codecov on continuous builds (#220)
  • chore: update new issue template (#219)
  • build: fix codecov uploading on Kokoro (#213)
  • Update kokoro config (#208)
  • Don't publish sourcemaps (#202)
  • test: remove appveyor config (#200)
  • Enable prefer-const in the eslint config (#198)
  • Enable no-var in eslint (#196)
  • Retry npm install in CI (#184)
  • chore: make ci happy (#175)
  • chore: use let and const (#161)
  • chore: ignore package-lock.json (#162)
  • chore: update renovate config (#156)
  • remove that whitespace (#155)
  • chore: move mocha options to mocha.opts (#152)
  • refactor: use @google-cloud/promisify (#151)
  • fix: get eslint passing (#149)
  • Configure Renovate (#123)
  • chore(package): update eslint to version 5.0.0 (#124)
  • refactor: drop repo-tool as an exec wrapper (#127)
  • chore: update sample lockfiles (#126)
  • fix: drop support for node 4.x and 9.x (#122)
  • Added support for the NUMERIC values. (#119)
  • chore(package): update nyc to version 12.0.2 (#116)
  • chore: the ultimate fix for repo-tools EPERM (#108)
  • chore: fix prettier incompatibility (#112)
  • chore: lock files maintenance (#111)
  • chore: lock files (#109)
  • chore: timeout for system test (#107)
  • chore: lock files maintenance (#106)