Google BigQuery: Node.js Samples

Table of Contents

• Before you begin
• Samples
  • Add Column Load Append
  • Add Column Query Append
  • Add Empty Column
  • Auth View Tutorial
  • Browse Table
  • Cancel Job
  • Client JSON Credentials
  • Copy Table
  • Copy Table Multiple Source
  • Create Dataset
  • Create Job
  • Create Model
  • Create Routine
  • Create Routine DDL
  • Create Table
  • Create Table Partitioned
  • Create Table Range Partitioned
  • Create View
  • Ddl Create View
  • Delete Dataset
  • Delete Label Dataset
  • Delete Label Table
  • Delete Model
  • Delete Routine
  • Delete Table
  • Extract Table Compressed
  • Extract Table JSON
  • Extract Table To GCS
  • Get Dataset
  • Get Dataset Labels
  • Get Job
  • BigQuery Get Model
  • Get Routine
  • BigQuery Get Table
  • Get Table Labels
  • Get View
  • Insert Rows As Stream
  • Inserting Data Types
  • BigQuery Label Dataset
  • Label Table
  • List Datasets
  • List Datasets By Label
  • List Jobs
  • BigQuery List Models
  • BigQuery List Models Streaming
  • List Routines
  • List Tables
  • Load CSV From GCS
  • Load CSV From GCS Autodetect
  • Load CSV From GCS Truncate
  • Load JSON From GCS
  • Load JSON From GCS Autodetect
  • Load JSON From GCS Truncate
  • Load Local File
  • Load Orc From GCS Truncate
  • Load Parquet From GCS Truncate
  • Load Table GCS Avro
  • Load Table GCS Avro Truncate
  • Load Table GCSORC
  • Load Table GCS Parquet
  • Load Table Partitioned
  • Nested Repeated Schema
  • Query
  • Query Batch
  • Query Destination Table
  • Query Disable Cache
  • Query Dry Run
  • Query External GCS Perm
  • Query Legacy
  • Query Legacy Large Results
  • Query Pagination
  • Query Params Arrays
  • Query Params Named
  • Query Params Named Types
  • Query Params Positional
  • Query Params Positional Types
  • Query Params Structs
  • Query Params Timestamps
  • Query Stack Overflow
  • Quickstart
  • Relax Column
  • Relax Column Load Append
  • Relax Column Query Append
  • Set User Agent
  • Undelete Table
  • Update Dataset Access
  • Update Dataset Description
  • Update Dataset Expiration
  • BigQuery Update Model
  • Update Routine
  • Update Table Description
  • Update Table Expiration
  • Update View Query

Before you begin

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

cd samples

npm install

cd ..

Add Column Load Append

View the source code.

Usage:

node samples/addColumnLoadAppend.js

Add Column Query Append

View the source code.

Usage:

node samples/addColumnQueryAppend.js

Add Empty Column

View the source code.

Usage:

node samples/addEmptyColumn.js

Auth View Tutorial

View the source code.

Usage:

node samples/authViewTutorial.js

Browse Table

View the source code.

Usage:

node samples/browseTable.js

Cancel Job

View the source code.

Usage:

node samples/cancelJob.js

Client JSON Credentials

View the source code.

Usage:

node samples/clientJSONCredentials.js

Copy Table

View the source code.

Usage:

node samples/copyTable.js

Copy Table Multiple Source

View the source code.

Usage:

node samples/copyTableMultipleSource.js

Create Dataset

View the source code.

Usage:

node samples/createDataset.js

Create Job

View the source code.

Usage:

node samples/createJob.js

Create Model

Creates a model in a dataset.

View the source code.

Usage:

node createModel.js <DATASET_ID> <MODEL_ID>

Create Routine

View the source code.

Usage:

node samples/createRoutine.js

Create Routine DDL

View the source code.

Usage:

node samples/createRoutineDDL.js

Create Table

View the source code.

Usage:

node samples/createTable.js

Create Table Partitioned

View the source code.

Usage:

node samples/createTablePartitioned.js

Create Table Range Partitioned

View the source code.

Usage:

node samples/createTableRangePartitioned.js

Create View

View the source code.

Usage:

node samples/createView.js

Ddl Create View

View the source code.

Usage:

node samples/ddlCreateView.js

Delete Dataset

View the source code.

Usage:

node samples/deleteDataset.js

Delete Label Dataset

Deletes a label on a dataset.

View the source code.

Usage:

node deleteLabelDataset.js <DATASET_ID>

Delete Label Table

View the source code.

Usage:

node samples/deleteLabelTable.js

Delete Model

View the source code.

Usage:

node samples/deleteModel.js

Delete Routine

View the source code.

Usage:

node samples/deleteRoutine.js

Delete Table

View the source code.

Usage:

node samples/deleteTable.js

Extract Table Compressed

View the source code.

Usage:

node samples/extractTableCompressed.js

Extract Table JSON

View the source code.

Usage:

node samples/extractTableJSON.js

Extract Table To GCS

View the source code.

Usage:

node samples/extractTableToGCS.js

Get Dataset

View the source code.

Usage:

node samples/getDataset.js

Get Dataset Labels

Gets labels on a dataset.

View the source code.

Usage:

node getDatasetLabels.js <DATASET_ID>

Get Job

View the source code.

Usage:

node samples/getJob.js

BigQuery Get Model

Retrieves an existing model from a dataset.

View the source code.

Usage:

node getModel.js <DATASET_ID> <MODEL_ID>

Get Routine

View the source code.

Usage:

node samples/getRoutine.js

BigQuery Get Table

Retrieves an existing table from a dataset.

View the source code.

Usage:

node getTable.js <DATASET_ID> <TABLE_ID>

Get Table Labels

Gets labels on a dataset.

View the source code.

Usage:

node getTableLabels.js <DATASET_ID> <TABLE_ID>

Get View

View the source code.

Usage:

node samples/getView.js

Insert Rows As Stream

View the source code.

Usage:

node samples/insertRowsAsStream.js

Inserting Data Types

View the source code.

Usage:

node samples/insertingDataTypes.js

BigQuery Label Dataset

Updates a label on a dataset.

View the source code.

Usage:

node labelDataset.js <DATASET_ID>

Label Table

View the source code.

Usage:

node samples/labelTable.js

List Datasets

View the source code.

Usage:

node samples/listDatasets.js

List Datasets By Label

View the source code.

Usage:

node samples/listDatasetsByLabel.js

List Jobs

View the source code.

Usage:

node samples/listJobs.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 Routines

View the source code.

Usage:

node samples/listRoutines.js

List Tables

View the source code.

Usage:

node samples/listTables.js

Load CSV From GCS

View the source code.

Usage:

node samples/loadCSVFromGCS.js

Load CSV From GCS Autodetect

View the source code.

Usage:

node samples/loadCSVFromGCSAutodetect.js

Load CSV From GCS Truncate

View the source code.

Usage:

node samples/loadCSVFromGCSTruncate.js

Load JSON From GCS

View the source code.

Usage:

node samples/loadJSONFromGCS.js

Load JSON From GCS Autodetect

View the source code.

Usage:

node samples/loadJSONFromGCSAutodetect.js

Load JSON From GCS Truncate

View the source code.

Usage:

node samples/loadJSONFromGCSTruncate.js

Load Local File

View the source code.

Usage:

node samples/loadLocalFile.js

Load Orc From GCS Truncate

View the source code.

Usage:

node samples/loadOrcFromGCSTruncate.js

Load Parquet From GCS Truncate

View the source code.

Usage:

node samples/loadParquetFromGCSTruncate.js

Load Table GCS Avro

View the source code.

Usage:

node samples/loadTableGCSAvro.js

Load Table GCS Avro Truncate

View the source code.

Usage:

node samples/loadTableGCSAvroTruncate.js

Load Table GCSORC

View the source code.

Usage:

node samples/loadTableGCSORC.js

Load Table GCS Parquet

View the source code.

Usage:

node samples/loadTableGCSParquet.js

Load Table Partitioned

View the source code.

Usage:

node samples/loadTablePartitioned.js

Nested Repeated Schema

View the source code.

Usage:

node samples/nestedRepeatedSchema.js

Query

View the source code.

Usage:

node samples/query.js

Query Batch

View the source code.

Usage:

node samples/queryBatch.js

Query Destination Table

View the source code.

Usage:

node samples/queryDestinationTable.js

Query Disable Cache

View the source code.

Usage:

node samples/queryDisableCache.js

Query Dry Run

View the source code.

Usage:

node samples/queryDryRun.js

Query External GCS Perm

View the source code.

Usage:

node samples/queryExternalGCSPerm.js

Query Legacy

View the source code.

Usage:

node samples/queryLegacy.js

Query Legacy Large Results

View the source code.

Usage:

node samples/queryLegacyLargeResults.js

Query Pagination

View the source code.

Usage:

node samples/queryPagination.js

Query Params Arrays

View the source code.

Usage:

node samples/queryParamsArrays.js

Query Params Named

View the source code.

Usage:

node samples/queryParamsNamed.js

Query Params Named Types

View the source code.

Usage:

node samples/queryParamsNamedTypes.js

Query Params Positional

View the source code.

Usage:

node samples/queryParamsPositional.js

Query Params Positional Types

View the source code.

Usage:

node samples/queryParamsPositionalTypes.js

Query Params Structs

View the source code.

Usage:

node samples/queryParamsStructs.js

Query Params Timestamps

View the source code.

Usage:

node samples/queryParamsTimestamps.js

Query Stack Overflow

View the source code.

Usage:

node samples/queryStackOverflow.js

Quickstart

View the source code.

Usage:

node samples/quickstart.js

Relax Column

View the source code.

Usage:

node samples/relaxColumn.js

Relax Column Load Append

View the source code.

Usage:

node samples/relaxColumnLoadAppend.js

Relax Column Query Append

View the source code.

Usage:

node samples/relaxColumnQueryAppend.js

Set User Agent

View the source code.

Usage:

node samples/setUserAgent.js

Undelete Table

View the source code.

Usage:

node samples/undeleteTable.js

Update Dataset Access

View the source code.

Usage:

node samples/updateDatasetAccess.js

Update Dataset Description

View the source code.

Usage:

node samples/updateDatasetDescription.js

Update Dataset Expiration

View the source code.

Usage:

node samples/updateDatasetExpiration.js

BigQuery Update Model

Updates a model's metadata.

View the source code.

Usage:

node updateModel.js <DATASET_ID> <MODEL_ID>

Update Routine

View the source code.

Usage:

node samples/updateRoutine.js

Update Table Description

View the source code.

Usage:

node samples/updateTableDescription.js

Update Table Expiration

View the source code.

Usage:

node samples/updateTableExpiration.js

Update View Query

View the source code.

Usage:

node samples/updateViewQuery.js