Name		Name	Last commit message	Last commit date
parent directory ..
resources		resources
test		test
.eslintrc.yml		.eslintrc.yml
README.md		README.md
browseRows.js		browseRows.js
copyTable.js		copyTable.js
createDataset.js		createDataset.js
createTable.js		createTable.js
deleteDataset.js		deleteDataset.js
deleteModel.js		deleteModel.js
deleteTable.js		deleteTable.js
extractTableToGCS.js		extractTableToGCS.js
getModel.js		getModel.js
insertRowsAsStream.js		insertRowsAsStream.js
listDatasets.js		listDatasets.js
listModels.js		listModels.js
listModelsStreaming.js		listModelsStreaming.js
listTables.js		listTables.js
loadCSVFromGCS.js		loadCSVFromGCS.js
loadCSVFromGCSAutodetect.js		loadCSVFromGCSAutodetect.js
loadCSVFromGCSTruncate.js		loadCSVFromGCSTruncate.js
loadJSONFromGCS.js		loadJSONFromGCS.js
loadJSONFromGCSAutodetect.js		loadJSONFromGCSAutodetect.js
loadJSONFromGCSTruncate.js		loadJSONFromGCSTruncate.js
loadLocalFile.js		loadLocalFile.js
loadOrcFromGCSTruncate.js		loadOrcFromGCSTruncate.js
loadParquetFromGCSTruncate.js		loadParquetFromGCSTruncate.js
loadTableGCSORC.js		loadTableGCSORC.js
loadTableGCSParquet.js		loadTableGCSParquet.js
package.json		package.json
query.js		query.js
queryDisableCache.js		queryDisableCache.js
queryParamsArrays.js		queryParamsArrays.js
queryParamsNamed.js		queryParamsNamed.js
queryParamsPositional.js		queryParamsPositional.js
queryParamsStructs.js		queryParamsStructs.js
queryParamsTimestamps.js		queryParamsTimestamps.js
queryStackOverflow.js		queryStackOverflow.js
quickstart.js		quickstart.js
updateModel.js		updateModel.js

README.md

Google Cloud Bigquery: Node.js Samples

Table of Contents

Before you begin
Samples

Before you begin

Before running the samples, make sure you've followed the steps outlined in Using the client library.

Samples

Browse Rows

View the source code.

Usage:

node browseRows.js

Copy Table

View the source code.

Usage:

node copyTable.js

Create Dataset

View the source code.

Usage:

node createDataset.js

Create Table

View the source code.

Usage:

node createTable.js

Delete Dataset

View the source code.

Usage:

node deleteDataset.js

BigQuery Delete Model

Deletes a model.

View the source code.

Usage:

node deleteModel.js <DATASET_ID> <MODEL_ID>

Delete Table

View the source code.

Usage:

node deleteTable.js

Extract Table To GCS

View the source code.

Usage:

node extractTableToGCS.js

BigQuery Get Model

Retrieves an existing model from a dataset.

View the source code.

Usage:

node getModel.js <DATASET_ID> <MODEL_ID>

Insert Rows As Stream

View the source code.

Usage:

node insertRowsAsStream.js

List Datasets

View the source code.

Usage:

node listDatasets.js

BigQuery List Models

Lists all existing models in the dataset.

View the source code.

Usage:

node listModels.js <DATASET_ID>

BigQuery List Models Streaming

Lists all existing models in the dataset using streaming method.

View the source code.

Usage:

node listModelsStreaming.js <DATASET_ID>

List Tables

View the source code.

Usage:

node listTables.js

Load CSV From GCS

View the source code.

Usage:

node loadCSVFromGCS.js

Load CSV From GCS Autodetect

View the source code.

Usage:

node loadCSVFromGCSAutodetect.js

Load CSV From GCS Truncate

View the source code.

Usage:

node loadCSVFromGCSTruncate.js

Load JSON From GCS

View the source code.

Usage:

node loadJSONFromGCS.js

Load JSON From GCS Autodetect

View the source code.

Usage:

node loadJSONFromGCSAutodetect.js

Load JSON From GCS Truncate

View the source code.

Usage:

node loadJSONFromGCSTruncate.js

Load Local File

View the source code.

Usage:

node loadLocalFile.js

Load Orc From GCS Truncate

View the source code.

Usage:

node loadOrcFromGCSTruncate.js

Load Parquet From GCS Truncate

View the source code.

Usage:

node loadParquetFromGCSTruncate.js

Load Table GCSORC

View the source code.

Usage:

node loadTableGCSORC.js

Load Table GCS Parquet

View the source code.

Usage:

node loadTableGCSParquet.js

Query

View the source code.

Usage:

node query.js

Query Disable Cache

View the source code.

Usage:

node queryDisableCache.js

Query Params Arrays

View the source code.

Usage:

node queryParamsArrays.js

Query Params Named

View the source code.

Usage:

node queryParamsNamed.js

Query Params Positional

View the source code.

Usage:

node queryParamsPositional.js

Query Params Structs

View the source code.

Usage:

node queryParamsStructs.js

Query Params Timestamps

View the source code.

Usage:

node queryParamsTimestamps.js

Query Stack Overflow

View the source code.

Usage:

node queryStackOverflow.js

Quickstart

View the source code.

Usage:

node quickstart.js

BigQuery Update Model

Updates a model's metadata.

View the source code.

Usage:

node updateModel.js <DATASET_ID> <MODEL_ID>