BigQuery is Google's fully managed, petabyte scale, low cost analytics data warehouse. BigQuery is NoOps—there is no infrastructure to manage and you don't need a database administrator—so you can focus on analyzing data to find meaningful insights, use familiar SQL, and take advantage of our pay-as-you-go model.
Before running the samples, make sure you've followed the steps in the Before you begin section of the client library's README.
View the source code.
Usage: node datasets.js --help
datasets.js <command>
Commands:
datasets.js create <projectId> <datasetId> Creates a new dataset.
datasets.js delete <projectId> <datasetId> Deletes a dataset.
datasets.js list <projectId> Lists datasets.
Options:
--version Show version number [boolean]
--help Show help [boolean]
Examples:
node datasets.js create my-project-id my_dataset Creates a new dataset named "my_dataset".
node datasets.js delete my-project-id my_dataset Deletes a dataset named "my_dataset".
node datasets.js list my-project-id Lists all datasets in my-project-id.
For more information, see https://cloud.google.com/bigquery/docs
View the source code.
Usage: node tables.js --help
tables.js <command>
Commands:
tables.js create <projectId> <datasetId> <tableId> <schema> Creates a new table.
tables.js list <projectId> <datasetId> Lists all tables in a dataset.
tables.js delete <projectId> <datasetId> <tableId> Deletes a table.
tables.js copy <projectId> <srcDatasetId> <srcTableId> Makes a copy of a table.
<destDatasetId> <destTableId>
tables.js browse <projectId> <datasetId> <tableId> Lists rows in a table.
tables.js load <projectId> <datasetId> <tableId> <fileName> Loads data from a local file into a table.
tables.js load-gcs <projectId> <datasetId> <tableId> Loads data from a Google Cloud Storage file into a
<bucketName> <fileName> table.
tables.js load-gcs-csv <projectId> <datasetId> <tableId> Loads sample CSV data from a Google Cloud Storage file
into a table.
tables.js load-gcs-csv-autodetect <projectId> <datasetId> Loads sample CSV data from a Google Cloud Storage file
<tableId> into a table.
tables.js load-gcs-csv-truncate <projectId> <datasetId> Loads sample CSV data from GCS, replacing an existing
<tableId> table.
tables.js extract <projectId> <datasetId> <tableId> Extract a table from BigQuery to Google Cloud Storage.
<bucketName> <fileName>
tables.js insert <projectId> <datasetId> <tableId> Insert a JSON array (as a string or newline-delimited
<json_or_file> file) into a BigQuery table.
Options:
--version Show version number [boolean]
--help Show help [boolean]
Examples:
node tables.js create my-project-id my_dataset my_table Creates a new table named "my_table" in "my_dataset".
"Name:string, Age:integer, Weight:float, IsMagic:boolean"
node tables.js list my-project-id my_dataset Lists tables in "my_dataset".
node tables.js browse my-project-id my_dataset my_table Displays rows from "my_table" in "my_dataset".
node tables.js delete my-project-id my_dataset my_table Deletes "my_table" from "my_dataset".
node tables.js load my-project-id my_dataset my_table Imports a local file into a table.
./data.csv
node tables.js load-gcs my-project-id my_dataset my_table Imports a GCS file into a table.
my-bucket data.csv
node tables.js extract my-project-id my_dataset my_table Exports my_dataset:my_table to gcs://my-bucket/my-file
my-bucket my-file as raw CSV.
node tables.js extract my-project-id my_dataset my_table Exports my_dataset:my_table to gcs://my-bucket/my-file
my-bucket my-file -f JSON --gzip as gzipped JSON.
node tables.js insert my-project-id my_dataset my_table Inserts the JSON array represented by json_string into
json_string my_dataset:my_table.
node tables.js insert my-project-id my_dataset my_table Inserts the JSON objects contained in json_file (one per
json_file line) into my_dataset:my_table.
node tables.js copy my-project-id src_dataset src_table Copies src_dataset:src_table to dest_dataset:dest_table.
dest_dataset dest_table
For more information, see https://cloud.google.com/bigquery/docs
View the source code.
Usage: node queries.js --help
queries.js <command>
Commands:
queries.js sync <projectId> <sqlQuery> Run the specified synchronous query.
queries.js async <projectId> <sqlQuery> Start the specified asynchronous query.
queries.js stackoverflow <projectId> Queries a public Stack Overflow dataset.
Options:
--version Show version number [boolean]
--help Show help [boolean]
Examples:
node queries.js sync my-project-id "SELECT * FROM Synchronously queries the natality dataset.
publicdata.samples.natality LIMIT 5;"
node queries.js async my-project-id "SELECT * FROM Queries the natality dataset as a job.
publicdata.samples.natality LIMIT 5;"
node queries.js shakespeare my-project-id Queries a public Shakespeare dataset.
For more information, see https://cloud.google.com/bigquery/docs