@google-cloud/bigquery - npm Package Compare versions

Comparing version 4.7.0 to 5.0.0

build/src/bigquery.d.ts

@@ -100,2 +100,3 @@ /*!
     location?: string;
+    userAgent?: string;
     /**
@@ -136,2 +137,4 @@ * The API endpoint of the service used to make requests.
  *     jobs referenced and created through the client.
+ * @property {string} [userAgent] The value to be prepended to the User-Agent
+ *     header in API requests.
  * @property {string[]} [scopes] Additional OAuth scopes to use in requests. For
@@ -188,5 +191,7 @@ *     example, to access an external data source, you may need the
      * @param {array} rows
+     * @param {array} selectedFields List of fields to return.
+     * If unspecified, all fields are returned.
      * @returns {array} Fields using their matching names from the table's schema.
      */
-    static mergeSchemaWithRows_(schema: TableSchema | TableField, rows: TableRow[]): any[];
+    static mergeSchemaWithRows_(schema: TableSchema | TableField, rows: TableRow[], selectedFields?: string[]): any[];
     /**
@@ -444,3 +449,3 @@ * The `DATE` type represents a logical calendar date, independent of time
      */
-    static getTypeDescriptorFromValue_(value: any): ValueType;
+    static getTypeDescriptorFromValue_(value: unknown): ValueType;
     /**
@@ -447,0 +452,0 @@ * Convert a value into a `queryParameter` object.

build/src/bigquery.js

@@ -18,2 +18,3 @@ "use strict";
 Object.defineProperty(exports, "__esModule", { value: true });
+exports.BigQueryTime = exports.BigQueryDatetime = exports.BigQueryTimestamp = exports.Geography = exports.BigQueryDate = exports.BigQuery = void 0;
 const common = require("@google-cloud/common");
@@ -25,3 +26,2 @@ const paginator_1 = require("@google-cloud/paginator");
 const extend = require("extend");
-const format = require('string-format-obj');
 const is = require("is");
@@ -61,2 +61,4 @@ const uuid = require("uuid");
  *     jobs referenced and created through the client.
+ * @property {string} [userAgent] The value to be prepended to the User-Agent
+ *     header in API requests.
  * @property {string[]} [scopes] Additional OAuth scopes to use in requests. For
@@ -223,5 +225,21 @@ *     example, to access an external data source, you may need the
      * @param {array} rows
+     * @param {array} selectedFields List of fields to return.
+     * If unspecified, all fields are returned.
      * @returns {array} Fields using their matching names from the table's schema.
      */
-    static mergeSchemaWithRows_(schema, rows) {
+    static mergeSchemaWithRows_(schema, rows, selectedFields) {
+        var _a;
+        if (selectedFields && selectedFields.length > 0) {
+            const selectedFieldsArray = selectedFields.map(c => {
+                return c.split('.');
+            });
+            const currentFields = selectedFieldsArray.map(c => c.shift());
+            //filter schema fields based on selected fields.
+            schema.fields = (_a = schema.fields) === null || _a === void 0 ? void 0 : _a.filter(field => currentFields
+                .map(c => c.toLowerCase())
+                .indexOf(field.name.toLowerCase()) >= 0);
+            selectedFields = selectedFieldsArray
+                .filter(c => c.length > 0)
+                .map(c => c.join('.'));
+        }
         return arrify(rows)
@@ -236,9 +254,9 @@ .map(mergeSchema)
                     value = value.map(val => {
-                        return convert(schemaField, val.v);
+                        return convert(schemaField, val.v, selectedFields);
                     });
                 }
                 else {
-                    value = convert(schemaField, value);
+                    value = convert(schemaField, value, selectedFields);
                 }
-                // tslint:disable-next-line no-any
+                // eslint-disable-next-line @typescript-eslint/no-explicit-any
                 const fieldObject = {};
@@ -249,4 +267,5 @@ fieldObject[schemaField.name] = value;
         }
-        // tslint:disable-next-line no-any
-        function convert(schemaField, value) {
+        function convert(schemaField, 
+        // eslint-disable-next-line @typescript-eslint/no-explicit-any
+        value, selectedFields) {
             if (is.null(value)) {
@@ -280,3 +299,3 @@ return value;
                 case 'RECORD': {
-                    value = BigQuery.mergeSchemaWithRows_(schemaField, value).pop();
+                    value = BigQuery.mergeSchemaWithRows_(schemaField, value, selectedFields).pop();
                     break;
@@ -309,3 +328,3 @@ }
         }
-        // tslint:disable-next-line no-any
+        // eslint-disable-next-line @typescript-eslint/no-explicit-any
         function flattenRows(rows) {
@@ -631,8 +650,6 @@ return rows.reduce((acc, row) => {
      */
-    static getTypeDescriptorFromValue_(
-    // tslint:disable-next-line: no-any
-    value) {
+    static getTypeDescriptorFromValue_(value) {
         let typeName;
         if (value === null) {
-            throw new Error('Type must be provided for null values.');
+            throw new Error("Parameter types must be provided for null values via the 'types' field in query options.");
         }
@@ -657,5 +674,5 @@ if (value instanceof BigQueryDate) {
         }
-        else if (is.array(value)) {
+        else if (Array.isArray(value)) {
             if (value.length === 0) {
-                throw new Error('Type must be provided for empty array.');
+                throw new Error("Parameter types must be provided for empty arrays via the 'types' field in query options.");
             }
@@ -679,2 +696,3 @@ return {
                         name: prop,
+                        // eslint-disable-next-line @typescript-eslint/no-explicit-any
                         type: BigQuery.getTypeDescriptorFromValue_(value[prop]),
@@ -709,3 +727,3 @@ };
     static valueToQueryParameter_(
-    // tslint:disable-next-line: no-any
+    // eslint-disable-next-line @typescript-eslint/no-explicit-any
     value, providedType) {
@@ -749,3 +767,3 @@ if (is.date(value)) {
                 }
-                // tslint:disable-next-line no-any
+                // eslint-disable-next-line @typescript-eslint/no-explicit-any
                 structValues[prop] = nestedQueryParameter.parameterValue;
@@ -759,3 +777,3 @@ return structValues;
         return queryParameter;
-        // tslint:disable-next-line no-any
+        // eslint-disable-next-line @typescript-eslint/no-explicit-any
         function getValue(value, type) {
@@ -904,3 +922,3 @@ return isCustomType(type) ? value.value : value;
         }
-        // tslint:disable-next-line no-any
+        // eslint-disable-next-line @typescript-eslint/no-explicit-any
         const query = extend(true, {
@@ -969,3 +987,3 @@ useLegacySql: false,
         }
-        // tslint:disable-next-line no-any
+        // eslint-disable-next-line @typescript-eslint/no-explicit-any
         const reqOpts = {
@@ -1053,4 +1071,3 @@ configuration: {
     createJob(options, callback) {
-        // tslint:disable-next-line no-any
-        const reqOpts = extend({}, options);
+        const reqOpts = Object.assign({}, options);
         let jobId = reqOpts.jobId || uuid.v4();
@@ -1179,7 +1196,7 @@ if (reqOpts.jobId) {
             if (resp.nextPageToken) {
-                nextQuery = extend({}, options, {
+                nextQuery = Object.assign({}, options, {
                     pageToken: resp.nextPageToken,
                 });
             }
-            // tslint:disable-next-line no-any
+            // eslint-disable-next-line @typescript-eslint/no-explicit-any
             const datasets = (resp.datasets || []).map((dataset) => {
@@ -1254,3 +1271,2 @@ const ds = this.dataset(dataset.datasetReference.datasetId, {
     getJobs(optionsOrCallback, cb) {
-        const that = this;
         const options = typeof optionsOrCallback === 'object' ? optionsOrCallback : {};
@@ -1269,9 +1285,8 @@ const callback = typeof optionsOrCallback === 'function' ? optionsOrCallback : cb;
             if (resp.nextPageToken) {
-                nextQuery = extend({}, options, {
+                nextQuery = Object.assign({}, options, {
                     pageToken: resp.nextPageToken,
                 });
             }
-            // tslint:disable-next-line no-any
             const jobs = (resp.jobs || []).map((jobObject) => {
-                const job = that.job(jobObject.jobReference.jobId, {
+                const job = this.job(jobObject.jobReference.jobId, {
                     location: jobObject.jobReference.location,
@@ -1328,2 +1343,6 @@ });
      *     syntax, of the query to execute.
+     * @param {object|Array<*>} query.types Provided types for query parameters.
+     *     For positional SQL parameters, provide an array of types. For named
+     *     SQL parameters, provide an object which maps each named parameter to
+     *     its type.
      * @param {boolean} [query.useLegacySql=false] Option to use legacy sql syntax.
@@ -1384,2 +1403,19 @@ * @param {object} [options] Configuration object for query results.
      * //-
+     * // Providing types for SQL parameters is supported.
+     * //-
+     * bigquery.query({
+     *   query: [
+     *     'SELECT url',
+     *     'FROM `publicdata.samples.github_nested`',
+     *     'WHERE repository.owner = ?'
+     *   ].join(' '),
+     *
+     *   params: [
+     *     null
+     *   ],
+     *
+     *   types: ['string']
+     * }, function(err, rows) {});
+     *
+     * //-
      * // If you need to use a `DATE`, `DATETIME`, `TIME`, or `TIMESTAMP` type in
@@ -1491,8 +1527,7 @@ * // your query, see {@link BigQuery#date}, {@link BigQuery#datetime},
             }
-            value = format('{y}-{m}-{d}{time}', {
-                y: value.year,
-                m: value.month,
-                d: value.day,
-                time: time ? ' ' + time : '',
-            });
+            const y = value.year;
+            const m = value.month;
+            const d = value.day;
+            time = time ? ' ' + time : '';
+            value = `${y}-${m}-${d}${time}`;
         }
@@ -1512,8 +1547,7 @@ else {
         if (typeof value === 'object') {
-            value = format('{h}:{m}:{s}{f}', {
-                h: value.hours,
-                m: value.minutes || 0,
-                s: value.seconds || 0,
-                f: is.defined(value.fractional) ? '.' + value.fractional : '',
-            });
+            const h = value.hours;
+            const m = value.minutes || 0;
+            const s = value.seconds || 0;
+            const f = is.defined(value.fractional) ? '.' + value.fractional : '';
+            value = `${h}:${m}:${s}${f}`;
         }
@@ -1520,0 +1554,0 @@ this.value = value;

build/src/dataset.js

@@ -18,2 +18,3 @@ "use strict";
 Object.defineProperty(exports, "__esModule", { value: true });
+exports.Dataset = void 0;
 const common_1 = require("@google-cloud/common");
@@ -480,3 +481,3 @@ const paginator_1 = require("@google-cloud/paginator");
         const body = table_1.Table.formatMetadata_(options);
-        // tslint:disable-next-line no-any
+        // eslint-disable-next-line @typescript-eslint/no-explicit-any
         body.tableReference = {
@@ -607,3 +608,3 @@ datasetId: this.id,
             if (resp.nextPageToken) {
-                nextQuery = extend({}, options, {
+                nextQuery = Object.assign({}, options, {
                     pageToken: resp.nextPageToken,
@@ -690,3 +691,3 @@ });
             if (resp.nextPageToken) {
-                nextQuery = extend({}, options, {
+                nextQuery = Object.assign({}, options, {
                     pageToken: resp.nextPageToken,
@@ -764,7 +765,7 @@ });
             if (resp.nextPageToken) {
-                nextQuery = extend({}, options, {
+                nextQuery = Object.assign({}, options, {
                     pageToken: resp.nextPageToken,
                 });
             }
-            // tslint:disable-next-line no-any
+            // eslint-disable-next-line @typescript-eslint/no-explicit-any
             const tables = (resp.tables || []).map((tableObject) => {
@@ -771,0 +772,0 @@ const table = this.table(tableObject.tableReference.tableId, {

build/src/index.js

@@ -19,18 +19,18 @@ "use strict";
 var bigquery_1 = require("./bigquery");
-exports.BigQuery = bigquery_1.BigQuery;
-exports.BigQueryDate = bigquery_1.BigQueryDate;
-exports.BigQueryDatetime = bigquery_1.BigQueryDatetime;
-exports.BigQueryTime = bigquery_1.BigQueryTime;
-exports.BigQueryTimestamp = bigquery_1.BigQueryTimestamp;
-exports.Geography = bigquery_1.Geography;
+Object.defineProperty(exports, "BigQuery", { enumerable: true, get: function () { return bigquery_1.BigQuery; } });
+Object.defineProperty(exports, "BigQueryDate", { enumerable: true, get: function () { return bigquery_1.BigQueryDate; } });
+Object.defineProperty(exports, "BigQueryDatetime", { enumerable: true, get: function () { return bigquery_1.BigQueryDatetime; } });
+Object.defineProperty(exports, "BigQueryTime", { enumerable: true, get: function () { return bigquery_1.BigQueryTime; } });
+Object.defineProperty(exports, "BigQueryTimestamp", { enumerable: true, get: function () { return bigquery_1.BigQueryTimestamp; } });
+Object.defineProperty(exports, "Geography", { enumerable: true, get: function () { return bigquery_1.Geography; } });
 var dataset_1 = require("./dataset");
-exports.Dataset = dataset_1.Dataset;
+Object.defineProperty(exports, "Dataset", { enumerable: true, get: function () { return dataset_1.Dataset; } });
 var job_1 = require("./job");
-exports.Job = job_1.Job;
+Object.defineProperty(exports, "Job", { enumerable: true, get: function () { return job_1.Job; } });
 var table_1 = require("./table");
-exports.Table = table_1.Table;
+Object.defineProperty(exports, "Table", { enumerable: true, get: function () { return table_1.Table; } });
 var routine_1 = require("./routine");
-exports.Routine = routine_1.Routine;
+Object.defineProperty(exports, "Routine", { enumerable: true, get: function () { return routine_1.Routine; } });
 var model_1 = require("./model");
-exports.Model = model_1.Model;
+Object.defineProperty(exports, "Model", { enumerable: true, get: function () { return model_1.Model; } });
 //# sourceMappingURL=index.js.map

build/src/job.js

@@ -18,2 +18,3 @@ "use strict";
 Object.defineProperty(exports, "__esModule", { value: true });
+exports.Job = void 0;
 /*!
@@ -350,3 +351,3 @@ * @module bigquery/job
             }
-            // tslint:disable-next-line no-any
+            // eslint-disable-next-line @typescript-eslint/no-explicit-any
             let rows = [];
@@ -359,7 +360,7 @@ if (resp.schema && resp.rows) {
                 // Query is still running.
-                nextQuery = extend({}, options);
+                nextQuery = Object.assign({}, options);
             }
             else if (resp.pageToken) {
                 // More results exist.
-                nextQuery = extend({}, options, {
+                nextQuery = Object.assign({}, options, {
                     pageToken: resp.pageToken,
@@ -366,0 +367,0 @@ });

build/src/model.js

@@ -18,2 +18,3 @@ "use strict";
 Object.defineProperty(exports, "__esModule", { value: true });
+exports.Model = void 0;
 const common = require("@google-cloud/common");
@@ -20,0 +21,0 @@ /**

build/src/routine.js

@@ -18,2 +18,3 @@ "use strict";
 Object.defineProperty(exports, "__esModule", { value: true });
+exports.Routine = void 0;
 const common = require("@google-cloud/common");
@@ -20,0 +21,0 @@ const promisify_1 = require("@google-cloud/promisify");

build/src/table.d.ts

@@ -35,2 +35,3 @@ /*!
     createInsertId?: boolean;
+    partialRetries?: number;
     raw?: boolean;
@@ -73,2 +74,7 @@ schema?: string | {};
 export declare type TableField = bigquery.ITableFieldSchema;
+export interface PartialInsertFailure {
+    message: string;
+    reason: string;
+    row: RowMetadata;
+}
 export interface TableOptions {
@@ -146,8 +152,12 @@ location?: string;
     createExtractJob(destination: File, callback: JobCallback): void;
-    createLoadJob(source: string, metadata?: JobLoadMetadata): Writable;
-    createLoadJob(source: File, metadata?: JobLoadMetadata): Promise<JobResponse>;
-    createLoadJob(source: string, metadata: JobLoadMetadata, callback: JobCallback): Writable;
-    createLoadJob(source: File, metadata: JobLoadMetadata, callback: JobCallback): void;
-    createLoadJob(source: string, callback: JobCallback): Writable;
-    createLoadJob(source: File, callback: JobCallback): void;
+    createLoadJob(source: string | File, metadata?: JobLoadMetadata): Promise<JobResponse>;
+    createLoadJob(source: string | File, metadata: JobLoadMetadata, callback: JobCallback): void;
+    createLoadJob(source: string | File, callback: JobCallback): void;
+    /**
+     * @param {string | File | File[]} source
+     * @param {JobLoadMetadata} metadata
+     * @returns {Promise<JobResponse>}
+     * @private
+     */
+    _createLoadJob(source: string | File | File[], metadata: JobLoadMetadata): Promise<JobResponse>;
     createQueryJob(options: Query): Promise<JobResponse>;
@@ -175,4 +185,5 @@ createQueryJob(options: Query, callback: JobCallback): void;
      *     The metadata object should be in the format of the
-     *     [`configuration.load`](http://goo.gl/BVcXk4) property of a Jobs
-     * resource. If a string is given, it will be used as the filetype.
+     *     [`configuration.load`](https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#JobConfigurationLoad)
+     * property of a Jobs resource. If a string is given, it will be used
+     * as the filetype.
      * @param {string} [metadata.jobId] Custom job id.
@@ -191,4 +202,5 @@ * @param {string} [metadata.jobPrefix] Prefix to apply to the job id.
      *     The metadata object should be in the format of the
-     *     [`configuration.load`](http://goo.gl/BVcXk4) property of a Jobs
-     * resource. If a string is given, it will be used as the filetype.
+     *     [`configuration.load`](https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#JobConfigurationLoad)
+     * property of a Jobs resource. If a string is given,
+     * it will be used as the filetype.
      * @param {string} [metadata.jobId] Custom job id.
@@ -253,2 +265,34 @@ * @param {string} [metadata.jobPrefix] Prefix to apply to the job id.
     insert(rows: RowMetadata | RowMetadata[], callback: InsertRowsCallback): void;
+    /**
+     * Insert rows with retries, but will create the table if not exists.
+     *
+     * @param {RowMetadata | RowMetadata[]} rows
+     * @param {InsertRowsOptions} options
+     * @returns {Promise<bigquery.ITableDataInsertAllResponse | bigquery.ITable>}
+     * @private
+     */
+    private _insertAndCreateTable;
+    /**
+     * This method will attempt to insert rows while retrying any partial failures
+     * that occur along the way. Because partial insert failures are returned
+     * differently, we can't depend on our usual retry strategy.
+     *
+     * @private
+     *
+     * @param {RowMetadata|RowMetadata[]} rows The rows to insert.
+     * @param {InsertRowsOptions} options Insert options.
+     * @returns {Promise<bigquery.ITableDataInsertAllResponse>}
+     */
+    private _insertWithRetry;
+    /**
+     * This method does the bulk of the work for processing options and making the
+     * network request.
+     *
+     * @private
+     *
+     * @param {RowMetadata|RowMetadata[]} rows The rows to insert.
+     * @param {InsertRowsOptions} options Insert options.
+     * @returns {Promise<bigquery.ITableDataInsertAllResponse>}
+     */
+    private _insert;
     load(source: string | File, metadata?: JobLoadMetadata): Promise<JobMetadataResponse>;
@@ -255,0 +299,0 @@ load(source: string | File, metadata: JobLoadMetadata, callback: JobMetadataCallback): void;

CHANGELOG.md

@@ -7,2 +7,40 @@ # Changelog
 
+## [5.0.0](https://www.github.com/googleapis/nodejs-bigquery/compare/v4.7.0...v5.0.0) (2020-06-19)
+
+
+### ⚠ BREAKING CHANGES
+
+* don't return Stream from createLoadJob (#647)
+* drop Node 8 from engines field (#662)
+
+### Features
+
+* drop Node 8 from engines field ([#662](https://www.github.com/googleapis/nodejs-bigquery/issues/662)) ([712b029](https://www.github.com/googleapis/nodejs-bigquery/commit/712b0294c6329545de70febb48762abd8b0567b9))
+* improved types ([40087fa](https://www.github.com/googleapis/nodejs-bigquery/commit/40087fa40f1e9a4180da7aaa43e2bb8a018bd632))
+* update types.d.ts ([#667](https://www.github.com/googleapis/nodejs-bigquery/issues/667)) ([a12b094](https://www.github.com/googleapis/nodejs-bigquery/commit/a12b094d2e6e48049203c9cd773fecb98713a3fa)), closes [#662](https://www.github.com/googleapis/nodejs-bigquery/issues/662) [#662](https://www.github.com/googleapis/nodejs-bigquery/issues/662) [#647](https://www.github.com/googleapis/nodejs-bigquery/issues/647) [#647](https://www.github.com/googleapis/nodejs-bigquery/issues/647) [#640](https://www.github.com/googleapis/nodejs-bigquery/issues/640) [#640](https://www.github.com/googleapis/nodejs-bigquery/issues/640) [#647](https://www.github.com/googleapis/nodejs-bigquery/issues/647) [#661](https://www.github.com/googleapis/nodejs-bigquery/issues/661) [#661](https://www.github.com/googleapis/nodejs-bigquery/issues/661) [#658](https://www.github.com/googleapis/nodejs-bigquery/issues/658) [#658](https://www.github.com/googleapis/nodejs-bigquery/issues/658) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#657](https://www.github.com/googleapis/nodejs-bigquery/issues/657) [#657](https://www.github.com/googleapis/nodejs-bigquery/issues/657) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#660](https://www.github.com/googleapis/nodejs-bigquery/issues/660) [#660](https://www.github.com/googleapis/nodejs-bigquery/issues/660) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#8203](https://www.github.com/googleapis/nodejs-bigquery/issues/8203) [#665](https://www.github.com/googleapis/nodejs-bigquery/issues/665) [#665](https://www.github.com/googleapis/nodejs-bigquery/issues/665) [#454](https://www.github.com/googleapis/nodejs-bigquery/issues/454) [#454](https://www.github.com/googleapis/nodejs-bigquery/issues/454) [#456](https://www.github.com/googleapis/nodejs-bigquery/issues/456) [#456](https://www.github.com/googleapis/nodejs-bigquery/issues/456) [#463](https://www.github.com/googleapis/nodejs-bigquery/issues/463) [#463](https://www.github.com/googleapis/nodejs-bigquery/issues/463)
+* **userAgent:** allow for optional user agent to be provided ([#671](https://www.github.com/googleapis/nodejs-bigquery/issues/671)) ([25aeca8](https://www.github.com/googleapis/nodejs-bigquery/commit/25aeca8f6c136d03d6029bda54e7cdab98af80ca))
+
+
+### Bug Fixes
+
+* add types for hasDrift and seasonalPeriods ([#680](https://www.github.com/googleapis/nodejs-bigquery/issues/680)) ([d6c9566](https://www.github.com/googleapis/nodejs-bigquery/commit/d6c95667577df2d32bff6f9d07117d011379ecd2))
+* **deps:** update dependency @google-cloud/paginator to v3 ([#658](https://www.github.com/googleapis/nodejs-bigquery/issues/658)) ([a09c493](https://www.github.com/googleapis/nodejs-bigquery/commit/a09c493f1f94e4a0272c17cb62009c92945c20d0))
+* apache license URL ([#468](https://www.github.com/googleapis/nodejs-bigquery/issues/468)) ([#669](https://www.github.com/googleapis/nodejs-bigquery/issues/669)) ([d3ed602](https://www.github.com/googleapis/nodejs-bigquery/commit/d3ed602e47ba005ca4c9d2f382867d19336f239d))
+* drop dependency on string-format-obj ([#698](https://www.github.com/googleapis/nodejs-bigquery/issues/698)) ([cf8f58f](https://www.github.com/googleapis/nodejs-bigquery/commit/cf8f58f851a8e32a4857f35c05a081cd031be124))
+* load job to a different project ID ([#748](https://www.github.com/googleapis/nodejs-bigquery/issues/748)) ([bfb74ad](https://www.github.com/googleapis/nodejs-bigquery/commit/bfb74add1850925837fa1737fded8642c80f0356))
+* **docs:** fix link for job configuration load ([#678](https://www.github.com/googleapis/nodejs-bigquery/issues/678)) ([ea3d7af](https://www.github.com/googleapis/nodejs-bigquery/commit/ea3d7afe18f8f22c6541043c92c26625ae9e0e85))
+* selectedFields on getRows not working correctly  ([#712](https://www.github.com/googleapis/nodejs-bigquery/issues/712)) ([13b7e39](https://www.github.com/googleapis/nodejs-bigquery/commit/13b7e391cb3cfd87caec094f058143842cb39306))
+* **deps:** update dependency @google-cloud/promisify to v2 ([#657](https://www.github.com/googleapis/nodejs-bigquery/issues/657)) ([5d8112c](https://www.github.com/googleapis/nodejs-bigquery/commit/5d8112c2cd3994d1d32102d63a7a90fb9478223c))
+* **deps:** update dependency @google-cloud/storage to v5 ([#700](https://www.github.com/googleapis/nodejs-bigquery/issues/700)) ([a2e34ef](https://www.github.com/googleapis/nodejs-bigquery/commit/a2e34ef32a79c0dccaa11954ca2fa3f90795c63a))
+* **deps:** update dependency google-auth-library to v6 ([#660](https://www.github.com/googleapis/nodejs-bigquery/issues/660)) ([3ea642e](https://www.github.com/googleapis/nodejs-bigquery/commit/3ea642ec9f1c471bff0d5d095fcc3e1b3813e52a))
+* **docs:** configuration.copy link ([#709](https://www.github.com/googleapis/nodejs-bigquery/issues/709)) ([4a81b1e](https://www.github.com/googleapis/nodejs-bigquery/commit/4a81b1e25c9b8f09eca28142bd54f6ca42b1f866))
+* **docs:** correct createTablePartitioned sample argument ([#701](https://www.github.com/googleapis/nodejs-bigquery/issues/701)) ([9a7520e](https://www.github.com/googleapis/nodejs-bigquery/commit/9a7520e62ebe7f561190de0a3c1080bbc07567ba))
+* **table:** add retries for insert partial failures ([#589](https://www.github.com/googleapis/nodejs-bigquery/issues/589)) ([b8639c2](https://www.github.com/googleapis/nodejs-bigquery/commit/b8639c27009aaa4eb03bbd9ebf0fa1463e2bcd2b)), closes [#655](https://www.github.com/googleapis/nodejs-bigquery/issues/655)
+* **types:** drop changes for drift and seasonal ([#681](https://www.github.com/googleapis/nodejs-bigquery/issues/681)) ([679d990](https://www.github.com/googleapis/nodejs-bigquery/commit/679d990f391433fbef180a4bbba2e32442e358da))
+
+
+### Code Refactoring
+
+* don't return Stream from createLoadJob ([#647](https://www.github.com/googleapis/nodejs-bigquery/issues/647)) ([8e26fb5](https://www.github.com/googleapis/nodejs-bigquery/commit/8e26fb561a9595e0f05e0506cebb71aa1eaba432)), closes [#640](https://www.github.com/googleapis/nodejs-bigquery/issues/640) [#640](https://www.github.com/googleapis/nodejs-bigquery/issues/640)
+
 ## [4.7.0](https://www.github.com/googleapis/nodejs-bigquery/compare/v4.6.1...v4.7.0) (2020-01-30)
@@ -9,0 +47,0 @@

package.json

 {
   "name": "@google-cloud/bigquery",
   "description": "Google BigQuery Client Library for Node.js",
-  "version": "4.7.0",
+  "version": "5.0.0",
   "license": "Apache-2.0",
   "author": "Google LLC",
   "engines": {
-    "node": ">=8.10.0"
+    "node": ">=10"
   },
@@ -33,3 +33,3 @@ "repository": "googleapis/nodejs-bigquery",
     "docs": "jsdoc -c .jsdoc.js",
-    "lint": "gts check && eslint samples/",
+    "lint": "gts check",
     "samples-test": "cd samples/ && npm link ../ && npm test && cd ../",
@@ -39,18 +39,18 @@ "test": "c8 mocha build/test",
     "presystem-test": "npm run compile",
-    "check": "gts check",
     "clean": "gts clean",
     "compile": "tsc -p . && cp src/types.d.ts build/src/",
-    "fix": "gts fix && eslint --fix '**/*.js'",
+    "fix": "gts fix",
     "predocs": "npm run compile",
     "prepare": "npm run compile",
     "pretest": "npm run compile",
-    "posttest": "npm run check",
     "docs-test": "linkinator docs",
     "predocs-test": "npm run docs",
-    "types": "dtsd bigquery v2 > ./src/types.d.ts"
+    "types": "dtsd bigquery v2 > ./src/types.d.ts",
+    "prelint": "cd samples; npm link ../; npm install",
+    "precompile": "gts clean"
   },
   "dependencies": {
-    "@google-cloud/common": "^2.0.0",
-    "@google-cloud/paginator": "^2.0.0",
-    "@google-cloud/promisify": "^1.0.0",
+    "@google-cloud/common": "^3.1.0",
+    "@google-cloud/paginator": "^3.0.0",
+    "@google-cloud/promisify": "^2.0.0",
     "arrify": "^2.0.1",
@@ -61,8 +61,8 @@ "big.js": "^5.2.2",
     "is": "^3.3.0",
+    "p-event": "^4.1.0",
     "stream-events": "^1.0.5",
-    "string-format-obj": "^1.1.1",
-    "uuid": "^3.3.2"
+    "uuid": "^8.0.0"
   },
   "devDependencies": {
-    "@google-cloud/storage": "^4.0.0",
+    "@google-cloud/storage": "^5.0.0",
     "@types/big.js": "^4.0.5",
@@ -76,30 +76,23 @@ "@types/execa": "^0.9.0",
     "@types/proxyquire": "^1.3.28",
-    "@types/sinon": "^7.0.12",
-    "@types/tmp": "0.1.0",
-    "@types/uuid": "^3.4.4",
+    "@types/sinon": "^9.0.0",
+    "@types/tmp": "0.2.0",
+    "@types/uuid": "^8.0.0",
+    "c8": "^7.0.0",
     "codecov": "^3.5.0",
     "discovery-tsd": "^0.2.0",
-    "eslint": "^6.0.0",
-    "eslint-config-prettier": "^6.0.0",
-    "eslint-plugin-node": "^11.0.0",
-    "eslint-plugin-prettier": "^3.1.0",
-    "gts": "^1.0.0",
-    "ink-docstrap": "^1.3.2",
-    "intelli-espower-loader": "^1.0.1",
+    "execa": "^4.0.0",
+    "gts": "^2.0.0",
     "jsdoc": "^3.6.3",
     "jsdoc-fresh": "^1.0.1",
     "jsdoc-region-tag": "^1.0.2",
-    "linkinator": "^1.5.0",
-    "mocha": "^7.0.0",
+    "linkinator": "^2.0.0",
+    "mocha": "^8.0.0",
     "mv": "^2.1.1",
     "ncp": "^2.0.0",
-    "c8": "^7.0.0",
-    "power-assert": "^1.6.1",
-    "prettier": "^1.17.1",
+    "p-reflect": "^2.1.0",
     "proxyquire": "^2.1.0",
-    "sinon": "^8.0.0",
-    "source-map-support": "^0.5.12",
-    "tmp": "0.1.0",
-    "typescript": "3.6.4"
+    "sinon": "^9.0.0",
+    "tmp": "0.2.1",
+    "typescript": "^3.8.3"
   }
 }

README.md

@@ -57,14 +57,14 @@ [//]: # "This README.md file is auto-generated, all changes to this file will be lost."
 ```javascript
-  // Imports the Google Cloud client library
-  const {BigQuery} = require('@google-cloud/bigquery');
+// Imports the Google Cloud client library
+const {BigQuery} = require('@google-cloud/bigquery');
 
-  async function createDataset() {
-    // Creates a client
-    const bigqueryClient = new 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();
+  // Create the dataset
+  const [dataset] = await bigqueryClient.createDataset(datasetName);
+  console.log(`Dataset ${dataset.id} created.`);
+}
+createDataset();
 
@@ -85,2 +85,3 @@ ```
 | Add Empty Column | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/addEmptyColumn.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/addEmptyColumn.js,samples/README.md) |
+| Auth View Tutorial | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/authViewTutorial.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/authViewTutorial.js,samples/README.md) |
 | Browse Rows | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/browseRows.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/browseRows.js,samples/README.md) |
@@ -92,4 +93,8 @@ | Cancel Job | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/cancelJob.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/cancelJob.js,samples/README.md) |
 | Create Dataset | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/createDataset.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/createDataset.js,samples/README.md) |
+| Create Job | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/createJob.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/createJob.js,samples/README.md) |
 | Create Table | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/createTable.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/createTable.js,samples/README.md) |
 | Create Table Partitioned | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/createTablePartitioned.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/createTablePartitioned.js,samples/README.md) |
+| Create Table Range Partitioned | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/createTableRangePartitioned.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/createTableRangePartitioned.js,samples/README.md) |
+| Create View | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/createView.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/createView.js,samples/README.md) |
+| Ddl Create View | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/ddlCreateView.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/ddlCreateView.js,samples/README.md) |
 | Delete Dataset | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/deleteDataset.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/deleteDataset.js,samples/README.md) |
@@ -109,3 +114,5 @@ | Delete Label Dataset | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/deleteLabelDataset.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/deleteLabelDataset.js,samples/README.md) |
 | Get Table Labels | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/getTableLabels.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/getTableLabels.js,samples/README.md) |
+| Get View | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/getView.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/getView.js,samples/README.md) |
 | Insert Rows As Stream | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/insertRowsAsStream.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/insertRowsAsStream.js,samples/README.md) |
+| Inserting Data Types | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/insertingDataTypes.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/insertingDataTypes.js,samples/README.md) |
 | BigQuery Label Dataset | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/labelDataset.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/labelDataset.js,samples/README.md) |
@@ -128,2 +135,4 @@ | Label Table | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/labelTable.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/labelTable.js,samples/README.md) |
 | Load Parquet From GCS Truncate | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/loadParquetFromGCSTruncate.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/loadParquetFromGCSTruncate.js,samples/README.md) |
+| Load Table GCS Avro | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/loadTableGCSAvro.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/loadTableGCSAvro.js,samples/README.md) |
+| Load Table GCS Avro Truncate | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/loadTableGCSAvroTruncate.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/loadTableGCSAvroTruncate.js,samples/README.md) |
 | Load Table GCSORC | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/loadTableGCSORC.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/loadTableGCSORC.js,samples/README.md) |
@@ -134,5 +143,7 @@ | Load Table GCS Parquet | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/loadTableGCSParquet.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/loadTableGCSParquet.js,samples/README.md) |
 | Query | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/query.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/query.js,samples/README.md) |
+| Query Batch | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/queryBatch.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/queryBatch.js,samples/README.md) |
 | Query Destination Table | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/queryDestinationTable.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/queryDestinationTable.js,samples/README.md) |
 | Query Disable Cache | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/queryDisableCache.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/queryDisableCache.js,samples/README.md) |
 | Query Dry Run | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/queryDryRun.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/queryDryRun.js,samples/README.md) |
+| Query External GCS Perm | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/queryExternalGCSPerm.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/queryExternalGCSPerm.js,samples/README.md) |
 | Query Legacy | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/queryLegacy.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/queryLegacy.js,samples/README.md) |
@@ -142,3 +153,5 @@ | Query Legacy Large Results | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/queryLegacyLargeResults.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/queryLegacyLargeResults.js,samples/README.md) |
 | Query Params Named | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/queryParamsNamed.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/queryParamsNamed.js,samples/README.md) |
+| Query Params Named Types | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/queryParamsNamedTypes.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/queryParamsNamedTypes.js,samples/README.md) |
 | Query Params Positional | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/queryParamsPositional.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/queryParamsPositional.js,samples/README.md) |
+| Query Params Positional Types | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/queryParamsPositionalTypes.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/queryParamsPositionalTypes.js,samples/README.md) |
 | Query Params Structs | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/queryParamsStructs.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/queryParamsStructs.js,samples/README.md) |
@@ -150,2 +163,4 @@ | Query Params Timestamps | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/queryParamsTimestamps.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/queryParamsTimestamps.js,samples/README.md) |
 | Relax Column Load Append | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/relaxColumnLoadAppend.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/relaxColumnLoadAppend.js,samples/README.md) |
+| Relax Column Query Append | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/relaxColumnQueryAppend.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/relaxColumnQueryAppend.js,samples/README.md) |
+| Undelete Table | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/undeleteTable.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/undeleteTable.js,samples/README.md) |
 | Update Dataset Access | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/updateDatasetAccess.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/updateDatasetAccess.js,samples/README.md) |
@@ -157,2 +172,3 @@ | Update Dataset Description | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/updateDatasetDescription.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/updateDatasetDescription.js,samples/README.md) |
 | Update Table Expiration | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/updateTableExpiration.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/updateTableExpiration.js,samples/README.md) |
+| Update View Query | [source code](https://github.com/googleapis/nodejs-bigquery/blob/master/samples/updateViewQuery.js) | [![Open in Cloud Shell][shell_img]](https://console.cloud.google.com/cloudshell/open?git_repo=https://github.com/googleapis/nodejs-bigquery&page=editor&open_in_editor=samples/updateViewQuery.js,samples/README.md) |
 
@@ -164,2 +180,23 @@
 
+## Supported Node.js Versions
+
+Our client libraries follow the [Node.js release schedule](https://nodejs.org/en/about/releases/).
+Libraries are compatible with all current _active_ and _maintenance_ versions of
+Node.js.
+
+Client libraries targetting some end-of-life versions of Node.js are available, and
+can be installed via npm [dist-tags](https://docs.npmjs.com/cli/dist-tag).
+The dist-tags follow the naming convention `legacy-(version)`.
+
+_Legacy Node.js versions are supported as a best effort:_
+
+* Legacy versions will not be tested in continuous integration.
+* Some security patches may not be able to be backported.
+* Dependencies will not be kept up-to-date, and features will not be backported.
+
+#### Legacy tags available
+
+* `legacy-8`: install client libraries from this dist-tag for versions
+  compatible with Node.js 8.
+
 ## Versioning
@@ -188,2 +225,8 @@
 
+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 template in this
+[directory](https://github.com/googleapis/synthtool/tree/master/synthtool/gcp/templates/node_library).
+
 ## License
@@ -190,0 +233,0 @@

New alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Fixed alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Improved metrics

Total package byte prevSize

470698

increased by6.29%

Dev dependency count

29

decreased by-19.44%

Lines of code

9663

increased by3.26%

Number of lines in readme file

234

increased by22.51%

Dependency changes

• + Addedp-event@^4.1.0

• + Added@google-cloud/common@3.10.0(transitive)

• + Added@google-cloud/paginator@3.0.7(transitive)

• + Added@google-cloud/projectify@2.1.1(transitive)

• + Added@google-cloud/promisify@2.0.4(transitive)

• + Added@tootallnate/once@2.0.0(transitive)

• + Addedgaxios@4.3.3(transitive)

• + Addedgcp-metadata@4.3.1(transitive)

• + Addedgoogle-auth-library@7.14.1(transitive)

• + Addedgoogle-p12-pem@3.1.4(transitive)

• + Addedgtoken@5.3.2(transitive)

• + Addedhttp-proxy-agent@5.0.0(transitive)

• + Addedjson-bigint@1.0.0(transitive)

• + Addedlru-cache@6.0.0(transitive)

• + Addednode-forge@1.3.1(transitive)

• + Addedp-event@4.2.0(transitive)

• + Addedp-finally@1.0.0(transitive)

• + Addedp-timeout@3.2.0(transitive)

• + Addedteeny-request@7.2.0(transitive)

• + Addeduuid@8.3.2(transitive)

• + Addedyallist@4.0.0(transitive)

• - Removedstring-format-obj@^1.1.1

• - Removed@google-cloud/common@2.4.0(transitive)

• - Removed@google-cloud/paginator@2.0.3(transitive)

• - Removed@google-cloud/projectify@1.0.4(transitive)

• - Removed@google-cloud/promisify@1.0.4(transitive)

• - Removed@tootallnate/once@1.1.2(transitive)

• - Removedcore-util-is@1.0.3(transitive)

• - Removedduplexify@3.7.1(transitive)

• - Removedgaxios@2.3.4(transitive)

• - Removedgcp-metadata@3.5.0(transitive)

• - Removedgoogle-auth-library@5.10.1(transitive)

• - Removedgoogle-p12-pem@2.0.5(transitive)

• - Removedgtoken@4.1.4(transitive)

• - Removedhttp-proxy-agent@4.0.1(transitive)

• - Removedisarray@1.0.0(transitive)

• - Removedjson-bigint@0.3.1(transitive)

• - Removedlru-cache@5.1.1(transitive)

• - Removedmime@2.6.0(transitive)

• - Removednode-forge@0.10.0(transitive)

• - Removedprocess-nextick-args@2.0.1(transitive)

• - Removedreadable-stream@2.3.8(transitive)

• - Removedsafe-buffer@5.1.2(transitive)

• - Removedstring-format-obj@1.1.1(transitive)

• - Removedstring_decoder@1.1.1(transitive)

• - Removedteeny-request@6.0.3(transitive)

• - Removeduuid@3.4.07.0.3(transitive)

• - Removedyallist@3.1.1(transitive)

• Updated@google-cloud/common@^3.1.0

• Updated@google-cloud/paginator@^3.0.0

• Updated@google-cloud/promisify@^2.0.0

• Updateduuid@^8.0.0